Sripting Languages II

Paper Code: 
WDT 331 B
Credits: 
2
Periods/week: 
1
Max. Marks: 
100.00
Objective: 

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

Unit I: 
Server-Side Scripting Languages

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 Files & Functions

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: 
MYSQL

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: