PHP and MySQL Overview

Request more details:

Description:
In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. The class also covers SQL basics. This course would be a good grounding for someone embarking on web application development for the LAMP (Linux, Apache, MySql and PHP) platform.
Prerequisites:
Experience in the following areas is required:

- HTML

Experience in the following areas would be beneficial.

- CSS
- Basic Programming
- XML
PHP Basics:
How PHP Works
The php.ini File
Basic PHP Syntax
PHP Tags
PHP Statements and Whitespace
Comments
PHP Functions
Hello World!
PHP Tags
PHP Statements and Whitespace
Comments
PHP Functions
Hello World!
Variables
Variable Types
Variable Names (Identifiers
Type Strength
Hello Variables!
Variable Scope
Superglobals
Constants
Variable-Testing and Manipulation Functions
Variable Types
Variable Names (Identifiers
Type Strength
Hello Variables!
Variable Scope
Superglobals
Constants
Variable-Testing and Manipulation Functions
PHP Operators
Creating Dynamic Pages
Single Quotes vs. Double Quotes
Howdy World!
Single Quotes vs. Double Quotes
Howdy World!
Flow Control:
Conditional Processing
If Conditions
If Conditions
Loops
while
do...while
for
break and continue
while
do...while
for
break and continue
Arrays:
Enumerated Arrays
Initializing Arrays
Appending to an Array
Reading from Arrays
Looping through Arrays
Initializing Arrays
Appending to an Array
Reading from Arrays
Looping through Arrays
Associative Arrays
Initializing Associative Arrays
Reading from Associative Arrays
Looping through Associative Arrays
Superglobal Arrays
Initializing Associative Arrays
Reading from Associative Arrays
Looping through Associative Arrays
Superglobal Arrays
Two-dimensional Arrays
Reading from Two-dimensional Arrays
Looping through Two-dimensional Arrays
Reading from Two-dimensional Arrays
Looping through Two-dimensional Arrays
Array Manipulation Functions
PHP and HTML Forms:
HTML Forms
How HTML Forms Work
A Sample HTML Form
Form Variables
How HTML Forms Work
A Sample HTML Form
Form Variables
String Manipulation:
Formatting Strings
Concatenation
String Manipulation Functions
Examples of String Functions
Concatenation
String Manipulation Functions
Examples of String Functions
Magic Quotes
magic_quotes_gpc
magic_quotes_runtime
Recommendation on Magic Quotes
Conclusion
magic_quotes_gpc
magic_quotes_runtime
Recommendation on Magic Quotes
Reusing Code and Writing Functions:
Including Files
require
require_once
auto_prepend_file and auto_append_file
require
require_once
auto_prepend_file and auto_append_file
User Functions
Defining and Calling Functions
Default Values
Variable Scope
By Reference vs. By Value
Defining and Calling Functions
Default Values
Variable Scope
By Reference vs. By Value
Form Processing
Code Organization
Code Organization
Simple SELECTs:
Introduction to the Northwind Database
Some Basics
Comments
Whitespace and Semi-colons
Case Sensitivity
Comments
Whitespace and Semi-colons
Case Sensitivity
SELECTing All Columns in All Rows
SELECTing Specific Columns
Sorting Records
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
The WHERE Clause and Operator Symbols
Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY
Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY
The WHERE Clause and Operator Words
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
Checking Multiple Conditions
AND
OR
Order of Evaluation
AND
OR
Order of Evaluation
Subqueries, Joins and Unions:
Subqueries
Joins
Table Aliases
Multi-table Joins
Table Aliases
Multi-table Joins
Outer Joins
Unions
UNION ALL
UNION Rules
UNION ALL
UNION Rules
Inserting, Updating and Deleting Records:
INSERT
UPDATE
DELETE
Managing Data:
Querying a Database
mysqli() Overview
mysqli Methods and Properties
Inserting and Updating Records
mysqli Prepared Statements
mysqli() Overview
mysqli Methods and Properties
Inserting and Updating Records
mysqli Prepared Statements
PEAR:DB:
Advantages and Disadvantages of PEAR DB
Why use a database abstraction layer?
When not to use a database abstraction layer?
Why use a database abstraction layer?
When not to use a database abstraction layer?
Using PEAR DB
Authentication with PHP and SQL:
A Database-less Login Form
Regular Expressions:
Regular Expressions
Perl-compatible Regular Expression Functions
preg_match()
preg_replace()
Regular Expression Tester
preg_match()
preg_replace()
Regular Expression Tester
Regular Expression Syntax
Session Control and Cookies:
Session Control and Cookies
Sessions
Configuring Sessions
Session Functions
Configuring Sessions
Session Functions
Cookies
Conclusion
Sending Email with PHP:
Sending Email with PHP
mail()
Shortcomings of mail()
Shortcomings of mail()
PHPMailer
Conclusion
File System Management:
File System Management
Opening a File
fopen()
fopen()
Reading from a File
fgets()
fgets()
Writing to a File
fwrite()
fwrite()
File Locking
flock()
flock()
Uploading Files via an HTML Form
Getting File Information
More File Functions
Directory Functions
Getting a Directory Listing
Getting a Directory Listing
Conclusion