SCRIPTING LANGUAGES-II

Paper Code: 
WDT 331B
Max. Marks: 
100.00
Objective: 

This module is designed to help students for creating dynamic web sites.

Unit I: 

Introduction to server-side scripting languages, Working and importance of PHP.

PHP: Introduction, Basic syntax, Inserting comments, Data types, Variables, Constants, Strings, Operators, Conditional statements and looping constructs, Arrays.

Unit II: 

PHP functions (with parameters, functions returning values), Built-in functions- Date, Time, String, arrays,  Handling an HTML forms, Embed PHP in HTML, PHP server variables.

Including Multiple Files (require, require_once, include, include_once).

Unit III: 

Working with PHP MyAdmin: Creating Databases, Types of Databases, Creating Tables in Database, Specifying Field Data Types, Selecting the Most Appropriate Data Type Adding, Field Modifiers and Keys, Selecting a Table Type Altering Tables, Altering Table and ,Field Names, Altering Field Properties, Adding and Removing Fields and Keys, Altering Table Types, Backing Up and Restoring Databases and Tables, Backing Up Databases and Tables, Restoring Databases and Tables from Backup, Dropping Databases and Tables, Viewing ,Database, Table, and Field Information.

Unit IV: 

Introduction to MY-SQL, Data types and MySql Syntax, Connecting to My-Sql, Executing simple Queries, Retrieving Queryresults (mysql_connect, mysql_close, mysql_select_db, mysql_query, mysql_fetch_row, mysql_fetch_array)

Common Programming Techniques: Sending values to a script, using hidden form inputs, editing existing records, making sortable displays

Unit V: 

Cookies and Sessions: Setting & accessing cookies, setting cookie parameters, deleting cookies. Setting & accessing session variables, deleting session variables.

Introduction to PHP OOPs: Basics of classes and objects.

ESSENTIAL READINGS: 
  1. Ivan Bayross, “HTML, Javascript, DHTML,, and PHP”, BPB Publications.
  2. Larry Ullman,  “PHP 6 & MySQL 5, For Dynamic Websites” Peachpit Press.
REFERENCES: 
  1. Jamsa, King & Anderson “HTML & Web Design”, TMH Publications.
  2. Website: http://www.w3schools.com.
Academic Year: