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/li>

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

Use of in_array(), current(), next(), prev(), reset() 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.1

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

dvance 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