PHP with MySql

Introduction to Php

 History of PHP

 Versions and Differences between them

 Practicality

 Power

 Installation and configuring Apache and PHP

PHP Basics

 Default Syntax

 Styles of PHP Tags

 Comments in PHP

 Output functions in PHP

 Datatypes in PHP

 Configuration Settings

 Error Types

Variables in PHP

 Variable Declarations

 Variable Scope

 PHP Superglobal Variables

 Variable Variables

Control Structures

 Execution Control Statements

 Conditional Statements

 Looping Statements whith Realtime Examples

Constants in PHP

Magic Constants

 Standard Pre-defined Constants

 Core Pre-difined Languages

 User defined Constants

Arrays

 What is an Array?

 How to create an Array

 Traversing Arrays

 Array Functions

Functions

 Creating Functions

 Passing Arguments by Value

 Passing Arguments by Reference

 Recursive Functions

Include Functions

 Include, Include_once

 Require, Require_once

Regular Expressions

 Validating textboxes,emails,phone number,etc

 Creating custom regular expressions

Object Oriented Programming in PHP

 Classes, Objects, Fields, Properties, set(), Constants, Methods

 Encaptulation

 Inheritance and types

 Polymorphism

 Constructor and Destructor

 Static Class Members, Instance of Keyword, Helper Functions

Object Cloning and Copy

PHP with MySQL

 What is MySQL

 Integration with MySQL

 MySQL functions

 Gmail Data Grid options

 SQL Injection

 Uploading and downloading images in Database

 Registration and Login forms with validations

 Pagging,Sorting

Strings and Regular Expressions

 Declarations styles of String Variables

 Heredoc style

 String Functions

 Regular Expression Stntax(POSIX)

 PHP Regular Expression Functions(POSIX Extended)

Working with the Files and Operating System

 File Functions

 Open, Create and Delete files

 Create Directories and Manipulate them

 Information about Hard Disk

 Directory Functions

 Calculating File, Directory and Disk Sizes

Error and Exception Handling

Error Logging

 Configuration Directives

 PHP Exception Class

 Throw New Exception

 Custom Exceptions

Date and Time Functions

 HTTP Authentication

 PHP Authentication

Cookies

 Types of Cookies

 How to Create and Access Cookies

Sessions

 Session Variables

 Creating and Destroying a Session

 Retriving and Setting the Session ID

Web Services

 Why Web Services

 RSS Syntax

 SOAP

 How to Access Web Services

MySQL Concepts

 Introduction

 Storage Engines

 Functions

 Operators

 Constraints

 DDL commands

 DML Commands

 DCL Command

 TCL Commands

 Views

 Joins

 Curosrs

 Indexing

 Stored Procedures

 Mysql with PHP Programming

 Mysql with Sqlserver(Optional)