PHP Online for Novice by XPLORE IT CORP

Overview of PHP
Static vs. Dynamic Web Sites
Client-Side Scripting vs. Server-Side Scripting
Overview of PHP Advantages
PHP Scripting Fundamentals
Print Statement, Code Blocks
Primitive Data Types
Defining Constants and Variables
Looping Constructs
PHP Operators
Logical, Relational & Bitwise Operators
Other Operators
Conditional Constructs
Timestamps
Arrays in PHP
Usage of Arrays in PHP
Indexing Arrays, Initializing Arrays
Adding and Removing from Arrays
Array Functions
PHP Functions
Declaring Functions
Using Include Files
The Require Statement, Recursion
Dynamic Function Calls
Predefined PHP Functions & Mailing Functions
Classes And Objects
The Basics & Auto loading 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
PHP s Database APIs
PHP s SQL API
Database Drivers
Database Driver Class Wrappers
Simple SQL Queries via PHP
Tracking Visitors with Session Ids
Populating Forms
Retrieving Data from Forms
State Management and cookies
Setting and Retrieving Cookies
Expiring and Deleting Cookies
Storing Arrays in Cookies
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
MySQL
Introduction to MySQL
Overview 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
Data Manipulation Statements &
Control Statements
Stored Procedures and Functions
Stored Routines and the Grant Tables
Stored Routine Syntax, Stored Procedures
Triggers
Views