Scripting Languages-II

Paper Code: 
24WDT331B
Credits: 
04
Periods/week: 
02
Max. Marks: 
100.00
Objective: 

Course Objectives:

 

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: 

Course

Learning outcome

(at course level)

Learning and teaching strategies

Assessment Strategies

Course Code

Course

Title

 

24WDT331B

 

Scripting Languages-II (Theory)

 

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

CO8. Apply the concepts of Built-in functions and cookies to websites.

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

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

CO11.  Apply the best practices in scripting, including code readability and modularity.

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

Assessment Strategies

Class test, Semester end examinations, Practical Assignments, Individual and group projects

 

 

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: 

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: 

Suggested Readings:

  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: 
2024-25
  • Printer-friendly version