SCRIPTING LANGUAGES-II

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

Course Objectives

This module will enable students to:

  1. learn the server-side scripting languages
  2. work with databases
  3. create full-fledged dynamic websites using PHP

 

Course Outcomes:

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies

Students will be able to:

CO 5.Develop skills to write server-side scripts using operators, decision controls, loops and functions in PHP and apply them to websites.

CO 6.Comprehend and apply the concepts of Built-in functions and cookies to websites.

CO 7.Integrate PHP code with MySQL to provide database functionality in websites.

CO 8.Design, Develop, Test, debug and deploy full-fledged websites.

 

Approach in teaching:

Interactive Lectures, Discussion, Reading assignments, Demonstrations, Group activities, Teaching using advanced IT audio-video tools 

 

Learning activities for the students:

Self-learning assignments, Effective questions, Seminar presentation, Giving tasks.

 

Assessment Strategies

Class test, Semester end examinations, Quiz, Solving problems in tutorials, Assignments, Presentation

 

 

6.00
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.

6.00
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).

 

6.00
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.

 

6.00
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

 

6.00
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: 
2021-22
  • Printer-friendly version