Web Programming with PHP, MySQL

Objective:
The course is designed with an objective to
 Understand basic PHP programming elements, variables, data types, operations,
functions and control structures.
 Use PHP for handling user input from web forms.
 Create a database and access data using MySQL.
 Use PHP to interface with a MySQL database via web forms.
 Create database driven web applications with PHP and MySQL

Learning Outcome:
On completion of the course, students will be able to
 Design web applications using PHP.
 Demonstrate the ability to use MySQL as a back end database for web applications.
 Design database driven web application with PHP and MySQL.

Unit I: 5L
Introduction to PHP: What is PHP, Basics of PHP, Benefits Of Using PHP MYSQL, Server
Client Environment, Web Browse Web Server Installation & Configuration.

Unit II: 10L
Development Concept: How PHP Script Work, PHP Syntax, Embed PHP In HTML/HTML in
PHP, PHP Data Type, Variable in PHP, Contents in PHP , Operators in PHP, If Statement,
If......Else Statement, Nested If Statement, Switch Statement.

Unit III: 15L
Looping structure, array and functions: While loop, do-while loop, for loop, what is array,
syntax of array, multidimensional array, What is function, Syntax of function, User Defined
Function, System Defined Function, Parameterized Function, some string functions of PHP.

Unit IV: 20L
Working with MYSQL: Working with phpMyAdmin, Types of Data Type, Creating Database
& Tables, Dropping Database & Tables, Adding Fields, Selecting Table, Database Connections,
Managing Database Connections, Performing Queries, Closing Connection, Create Database &
Table.

Books Recommended:
1. Holzner S. ,”The Complete Reference PHP”– McGraw Hill Education,2017
2. Welling L.,Thomson L, PHP and MySQL Web Development”, Pearson Education,2017.
3. Vaswani V, “The Complete Reference MySQL”, McGraw Hill Education, 2017.
4. Powell T.,”The Complete Reference HTML & CSS”, McGraw Hill Education, 2017.

Computer Lab Based on Web Programming with PHP, MySQL:
 HTML Form data handling with PHP
 Design web application using PHP and MYSQL

No comments:

Post a Comment