Module 1

PHP Introduction

• Web Applications and their types
• Static v/s Dynamic Websites
• Server side programming
• 3 Tier Architecture
• Introduction to PHP
• History and Features
• Changes and Current Version
• Interpreter based Execution Model of PHP
• Installation of Xampp/Wampp Server
• Syntax of PHP script
• Executing Hello world application of PHP

Module 2

Data Types, Operators

•  integers , string, floating numbers, Booleans , arrays etc.
• PHP Variables and Constants
• Important Rules for declaring PHP variables
•  User-defined Constants
• String constants, variable interpolation into strings
•  Assignment Operators
• Relational Operators
• Logical Operators
•  Bitwise Operators
• Operators precedence and associatively

Module 3

Conditional Statements

• If-else statement
• If… else if… else statement
• Nested if-else statement
• Switch case statement
• Ternary operator
•  Assignment to apply conditional statements

Module 4

Loops & Control Statements

• While loop
• Do While loop
• For loop
• Nested loops
• Break, Continue and Exit keywords
•  Assignment to apply loops and control statements.

Module 5

Loops & Control Statements Cont....

• Nested While loop
• Nested Do While loop
• Nested For loop
• Series and Patterns

Module 6

Functions in PHP

• Function as reusable components
•  Defining a Function
•  Calling a Function
• Passing arguments to a function
•  Returning a value from a function
•  use of include(), include_once(), require() and require_once() library function
• Assignment to apply functions

Module 7

Advance Function Concepts

•  Default Arguments
• Difference b/w argument passing by value and by reference
•  Defining and using Recursive functions
• Assignment to apply advance function concepts

Module 8

Arrays

• Understanding array as a collection of values
• Defining an array
• Accessing array elements using index
• Initializing array
• Using array() function for creating array
• Obtaining the size of an array
•  Traversing array elements using while & for loop
• Using foreach loop for traversing array elements
•  Use of list() and each() functions in traversing array
•  Assignment to use arrays

Module 9

Two dimensional Arrays

• Defining a two-d array
• Accessing elements of two-d array
• Initializing a two-d array
• Traversing elements of two-d array
•  Example of use of two-d array
• Assignment to use two-d arrays

Module 10

Associative Arrays

• Understanding an associative array
• Defining an associative array
•  Initializing an associative array
•  Accessing elements of an associative array using => operator
•  Traversing elements of associative array
•  Creating a Multi-dimensional array
•  Assignment to use associative arrays

Module 11

Common Array Functions

• Sorting array using sort(), rsort(), asort(), arsort(), usort(), and uksort()
•  Use of array_key_exists(), array_keys(), array_values(), array_diff_key() functions
• Use of array_push(), array_pop(), array_shift(), array_replace(), array_slice() and array_walk() functions
•  Use of in_array(), current(), next(), prev(), reset() functions
• Assignment to use array functions

Module 12

String Handling

• Use of single & double quotes in representing Strings
• Use of basic string functions strlen(), substr(), strcmp(), and str_replace()
•  Use of trimming functions trim(), ltrim(), and rtrim()
•  Use of case changing functions strtolower(), strtoupper(), ucwords(), ucfirst(), and lcfirst()
•  Use of position finding functions strpos(), strrpos(), and strstr()
•  use explode() and implode() functions
• use of printf(), sprintf(), and sscanf()
•  Assignment to use String functions

Module 13

Object Oriented Programming in PHP

• Classes and Objects
• Encapsulation
• Abstraction
• Inheritance
• Polymorphism and Dynamic Binding
• Assignment to implement OOP Concepts

Module 14

HTML & HTTP Basics

• Request Response Model of HTTP
• Type of HTTP requests
• Difference b/w Get & Post Requests
•  Basic HTML elements html, head, body, title and form
• HTML Input elements text, radio, select, button, submit, textarea, and hidden
•  New HTML 5 Input elements email, number, range, and url
•  Use of $_GET, $_POST, and $_SERVER global variables
• Server-side Validation using isset(), empty() and
• Web based assignment different type of input controls and request type

Module 15

Introduction to CSS

• CSS basics
• Applying inline & external css styles
• CSS Selectors
• Layout and Wireframing of Website

Module 16

State Management

• Understanding stateless nature of HTTP
• Maintaining user state using $_COOKIE global variable
•  Maintaining user state using $_SESSION global variable
•  Maintaining user state using hidden form fields
•  Maintaining user state using parameter appending to url
• Assignment to apply all the state management methods

Module 16

Reading & Writing data from files

• Understanding need of file handling
• Creating file using touch() and fopen() functions
• Different modes of opening files r, w, a, r+, w+, a+
• Use of file read/write functions fread(), fwrite(), fgetc() fgets(), fscanf(),
• file_put_contents(), file_get_contents() functions
•  Use of file utility functions fseek(), ftell(), feof(), filesize(), fclose()
• Assignment to create, append, write, and read file date

Module 17

Interacting with File System

• Need of File System interaction
• Creating directory using mkdir() function
•  Removing directory using rmdir() funciton
•  Removing files using unlink() function
•  Renaming files and directory rename() function
•  Use of opendir(), readdir(), scandir() and closedir() functions
•  Use of is_file(), is_directory() and chmod() functions
•  Assignment to perform file system operations

Module 18

Advance File System concepts

• Use of basename(), realpath(), dirname() functions
•  Use of __FILE__ and __DIR__ magic constants
•  Reading csv files using fgetcsv() function
•  File uploading & downloading

Module 19

File System based Mini Project

•  Creating links of directories
• Uploading files and creating their links
• Deleting & downloading files using links
• Renaming Files & Folders using their links

Module 20

MySql

• Introduction to RDBMS Package
• Use of phpMyAdmin as interface of MySql
• Creating, removing and managing user accounts
• Creating, removing and managing databases
•  Understanding different types of Storage engines Innodb, MyISAM, CSV etc
• Creating, altering and removing Tables
•  Performing Insert, update, delete and select operations on the table
•  Importing & Exporting database and tables
• Assignment to use phpMyAdmin for managing users, databases and tables

Module 21

MySql PHP Connectivity

• mysql PHP library as means of database connectivity
• Use of mysqli_connect(), mysqli_select_db(), mysqli_query(), and mysqli_fetch_array(),
• mysqli_fetch_assoc(), mysqli_fetch_object(), mysqli_close(), mysqli_free_result() functions
• Use of Object Oriented MySQLi Connection and Methods
• Exeucting DML (insert, update, delete, & select) queries from PHP
•  Exeucting DDL (create, alter, & drop) queries from PHP
•  Assignment to perform DDL & DML operations

Module 22

Advance MySql PHP Connectivity Concepts

• Executing queries in batches for improving performance
• Executing transactions, committing and rolling back
• Using limits for selecting records
•  Using joins for selecting records from multiple tables
•  Assignment to perform Advance SQL operations

Module 23

Advance MySql queries

• Use of group by, having, and oder by clauses in select queries
•  Use of between, in, like in select queries
• Use of aggregate functions count(), max(), min(), avg() in select queries
•  Use of nested queries
•  Assignment to perform use of these concepts in PHP applications

Module 24

Obtaining database meta data in PHP

•  Use of mysql_fetch_field(), mysql_num_fields(), mysql_num_rows(), mysql_field_name(), mysql_field_type(), mysql_filed_table(), mysql_field_len() functions
•  Use of mysql_db_name(), mysql_list_dbs(), mysql_list_tables(), mysql_list_fields()
•  Use of mysql_insert_id(), mysql_get_client_info(), mysql_get_host_info() and mysql_get_proto_info(), mysql_get_server_info() functions
•  Assignment to perform use of these concepts in PHP applications

Module 25

Working with MySqli & PDO

• mysqli & PDO PHP library as means of database connectivity
• Prepared statements
• Stored procedures & Functions

Module 26

A mini project using database

• A mini web site having user registration, login, view profile, edit profile, logout in user interface
• View Users, edit user details and delete users in admin interface