Scripting Languages-II

Paper Code: 
25WDT331B
Credits: 
4
Periods/week: 
2
Max. Marks: 
100.00
Objective: 

This course 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

  1. Develop skills to write server-side scripts using operators, decision controls, loops and functions in PHP and apply them to websites.
  2. Apply the concepts of Built-in functions and cookies to websites.
  3. Integrate PHP code with MySQL to provide database functionality in websites.
  4. Design, Develop, Test, debug and deploy full-fledged websites.
  5. Apply the best practices in scripting, including code readability and modularity.
  6. Contribute effectively in course-specific interaction

 

Approach in teaching:

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

Learning activities for the students:

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

Two Internal Tests, Quiz, Home Assignments, Presentations.

 

 

6.00
Unit I: 
Introduction:

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:

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, Sessions & Introduction to PHP OOPs:

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.

 

e-Resources:

  1. https://youtu.be/1ZE-s0EySXg
  2. https://youtu.be/DEcjb-hMgX4
  3. https://youtu.be/-I-7wWUyT0k
  4. https://youtu.be/8ukRI2VsA-s
  5. https://www.w3schools.com/w3css/defaulT.asp

 

Journals:

  1. International Journal of Design
  2. Journal of the Brazilian Computer Society, SpringerOpen
  3. Journal of Internet Services and Applications, SpringerOpen
Academic Year: 
2025-26
  • Printer-friendly version