COURSE CODE: LA301

Description:
This hands on PHP Programming course provides the knowledge necessary to design and develop dynamic, database-driven web pages using PHP version 5. PHP is a web language which is , quick to learn, easy to deploy and provides substantial functionality required for e-commerce. This course introduces the PHP framework and syntax, and covers in depth the most important techniques used to build dynamic web sites. Students will learn how to connect to any ODBC-compliant database, and perform hands on practice with a MySQL database to create database-driven HTML forms and reports. Students also learn how to configure PHP and Apache Web Server. Comprehensive lab exercises provide facilitated hands on practice crucial to develop competence web sites.

Prerequisites:
Basic computer skills and knowledge of HTML fundamentals

Course Overview:

  • Linux Introduction
  • XHTML
  • Javascript + CSS - Intro
  • AJAX
  • PHP5 Programming
  • MySQL for Developer
  • CakePHP - Framework - Introduction
  • Drupal - CMS - Introduction

Overview Of PHP

  • Static vs. Dynamic Web Sites
  • Dynamic Content from Databases
  • Developing Dynamic Internet Applications
  • Client-Side Scripting vs. Server-Side Scripting
  • Overview of PHP Advantages & Capabilities
  • Configuring PHP.INI
  • PHP vs. ASP

Basic Scripting and Looping Constructs

  • PHP Scripting Fundamentals
  • Print Statement
  • Code Blocks
  • Primitive Data Types
  • Defining Constants and Variables
  • Looping Constructs
  • While
  • Do While
  • For
  • Exit & Break

PHP Operators

  • Logical Operators
  • Relational Operators
  • Bitwise Operators
  • Other Operators

Conditional Constructs

  • True and False Expressions
  • If, Else and Elseif
  • Switch/Case Statement
  • The ? (Ternary) Operator
  • Timestamps

Arrays in PHP

  • What are Arrays?
  • Usage of Arrays in PHP
  • Indexing Arrays
  • Initializing Arrays
  • Adding and Removing from Arrays
  • One-dimensional Arrays
  • Multidimensional Arrays
  • Array Functions

PHP Functions

  • Introduction to Functions
  • Declaring Functions
  • Scope
  • Passing Arguments to Functions
  • Returning Values from a Function
  • Using Include Files
  • The Require Statement
  • Recursion
  • Dynamic Function Calls
  • Predefined PHP Functions
  • Mailing Functions

Classes And Objects (PHP 5)

  • Introduction
  • The Basics
  • Autoloading Objects
  • Constructors and Destructors
  • Visibility
  • Scope Resolution Operator (::)
  • Static Keyword
  • Class Constants
  • Class Abstraction
  • Object Interfaces
  • Overloading
  • Object Iteration
  • Patterns
  • Magic Methods
  • Final Keyword
  • Object cloning
  • Comparing objects
  • Reflection
  • Type Hinting

File Handling

  • Searching File Contents With Regular Expressions
  • Changing and Editing File Contents
  • Splitting and Joining Information Inside Files
  • File Uploading
  • String Functions
  • Regular Expression Functions
  • Reading, Writing and Deleting Files
  • Handling File Permissions
  • File Locking
  • Reading Directory Contents
  • Creating and Deleting Directories

Working with Databases and Forms

  • Configuring PHP For Database Support
  • PHP’s Database APIs
  • PHP’s SQL API
  • MySQL vs. Access
  • MySQL vs. SQL Server
  • Database Drivers
  • Database Driver Class Wrappers
  • ODBC
  • Simple SQL Queries via PHP
  • Tracking Visitors with Session IDs
  • Populating Forms
  • Retrieving Data from Forms

Using Cookies with PHP

  • Purpose of Cookies
  • Cookie Myths
  • Setting Cookies
  • Retrieving Cookies
  • Expiring Cookies
  • Deleting Cookies
  • Storing Arrays in Cookies

Miscellaneous PHP Tasks

  • Error Logging
  • Session Management & Maintaining State
  • Using Environmental Variables
  • Changing Execution by Redirecting to Other URLs
  • Embedding JavaScript with PHP
  • Using HTTP & FTP Protocols to Pass Data
  • Showing Different Content to Different Browsers
  • Getting IP Addresses from Visitors

Using MySQL 5.0

Introduction to MySQL AB

  • Overview of MySQL AB
  • What is MySQL?
  • History of MySQL
  • The Main Features of MySQL

Create & Manage Database and tables

  • Connecting to and Disconnecting from the Server
  • Entering Queries
  • Creating and Using a Database
  • Creating and Selecting a Database
  • Creating a Table
  • Loading Data into a Table
  • Retrieving Information from a Table
  • Getting Information About Databases and Tables

Data Types

Functions and Operators

SQL Statement Syntax

Data Definition Statements

  • ALTER DATABASE Syntax
  • ALTER TABLE Syntax
  • CREATE DATABASE Syntax
  • CREATE TABLE Syntax
  • DROP DATABASE Syntax
  • DROP TABLE Syntax
  • RENAME TABLE Syntax

Data Manipulation Statements & Control Statements

  • DELETE Syntax
  • DO Syntax
  • INSERT Syntax
  • LOAD DATA INFILE Syntax
  • REPLACE Syntax
  • SELECT Syntax
  • Subquery Syntax
  • TRUNCATE Syntax
  • UPDATE Syntax

Stored Procedures and Functions

  • Stored Routines and the Grant Tables
  • Stored Routine Syntax
  • Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()

Triggers

  • CREATE TRIGGER Syntax
  • DROP TRIGGER Syntax
  • Using Triggers

Views

  • ALTER VIEW Syntax
  • CREATE VIEW Syntax
  • DROP VIEW Syntax
  • Using PHP MyAdmin to configure MySQLFunctions and Operators

Introduction to the Apache Web Server

  • Configuration Files
  • PHP Installation and Configuration
  • WWW Sites within Apache
  • Website Properties
  • RPM Installation vs. Binary Installation

DURATION

  • 3 Months - 2.5 Hrs per Day - Mon - Friday
  • 6 Months - 6 Hrs per Week - Mon - Wed - Friday

FEES

  • Rs. 20,000 (Inclusive of Service Tax 12.36%)