PHP course for Novice by DOCC Kolkata

History of PHP

Installing PHP
General Requirements
UNIX based Systems
Windows based Systems
Integrated Development Environment (IDE)
PHP Language Basics

Programming Basics
Comment markers
PHP Tags
Output Commands
Using STDIN STDOUT and STDERR
Using Files
Include_path
Opening files
Reading files
Writing to Files
RTRIM
PHP Variables

Naming Rules
Data Types
Numerical
Integer
Floating Point Numbers
Floating Point Precision
Single Quoted Strings
Double Quoted Strings
Creating and Assigning Variables
Assigning Values to Variables
Type Conversion
Variable Scoping
Global Keyword
Static Keyword
Super Globals
Constants
Variable Variables
Operators
Assignment Operators
Increment/Decrement Operators
Arithmetic Operators
String Operators
Comparison Operators
Logical Operators
Control Structures

Statement Blocks
If Construct
Else Keyword
Elseif Keyword
Looping Constructs
While Loop
Do-while Loop
For Loop
Foreach Loop
Loop Control Words
Break
Continue
Regular Expressions

Meta-Characters
Backslash
Unicode Character Properties
Circumflex and Dollar
Full Stop
Square Brackets
Vertical Bar
Multipliers
Subpatterns
Repetition
Pattern Matching with ereg and eregi
Pattern Matching with preg_match
Splitting Text
Switch
PHP Arrays

Syntax
Creating/Modifying with Square-Bracket Syntax
Array Functions
Pitfalls when using Arrays
Using a Return value as a Key
Converting to Array
Sorting an Array
Multi-Dimensional Arrays
Example
Creating a new Multi-Dimensional Array
PHP Functions

Conditionally Created Functions
Functions Created Inside Functions
Argument Passing by Value
Argument Passing by Reference
Returning Values
Including External PHP Functions
PHP Object Oriented

Classes and Inheritance
Classes
Inheritance
Keywords
PHP & PEAR

What is PEAR?
Command Line Package Installer
Fully-Automatic Installation
Semi-Automatic Installation
What is PECL?
PHP & HTML

HTML/PHP Examples

MySQL

Installing MySQL
Testing MySQL
Basic SQL Statements

Creating Databases and Tables
Inserting Data into Tables
Viewing Tables
UPDATE
Drop
Connecting to MySQL

mysql_connect
mysql_error
mysql_select_db
Die
Using PHP to Perform Database Functions

Inserting Data into a Database
Creating Queries
Executing Queries
Processing the Returned Query Data
Updating the Database