Introduction to PHP & MySQL

PHP Training Overview
MySQL™ and PHP are two of the most popular open source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world's most popular open source database. Together, these two technologies provide you with a powerful platform for building database-driven Web applications.
This hands-on MySQL and PHP training course teaches attendees everything they need to successfully build data-driven Web sites using MySQL and PHP.
Accelebrate also offers an Advanced PHP training class.
Important Note: Upon request, we would be glad to teach this course with a database other than MySQL.
Location and Pricing
Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor’s or students’ travel expenses. To receive a customized proposal and price quote private training at your site or online.
In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses.
PHP Training Prerequisites
All MySQL and PHP training attendees must be fluent in HTML. The course can be customized to any level of programming and relational database familiarity.
Hands-on/Lecture Ratio
This MySQL and PHP training class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.
PHP Training Materials
All MySQL and PHP training students receive a copy of Apress' Beginning PHP and MySQL 5: From Novice to Professional and related courseware.
Software Needed on Each Student PC
The following should be installed on each student PC:
Linux, Windows, MacOS X, or Solaris operating system
Web server (either Apache httpd or Microsoft IIS)
PHP 5 or later with the PEAR extensions enabled
MySQL 4.1 or later (5 or later recommended)
Internet Explorer 6 or later or Firefox 2 or later
Note: XAMPP, provides a single installer with everything you need for the class on Linux, Windows, MacOS X, or Solaris.
PHP Training Objectives
*To teach attendees the PHP programming skills they need to successfully build interactive, data-driven sites
*To teach students enough MySQL database skills to build the databases that will power their sites
PHP Training Outline
*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!
Conclusion
*Flow Control
Conditional Processing
*If Conditions
If Conditions
Loops
*while
*do...while
*for
*break and continue
while
do...while
for
break and continue
Conclusion
*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
Conclusion
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
Conclusion
*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
Conclusion
*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
Conclusion
*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
Conclusion
*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
Conclusion
*Inserting, Updating and Deleting Records
INSERT
UPDATE
DELETE
Conclusion
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
Conclusion
*Regular Expressions
Perl-compatible Regular Expression Functions
*preg_match()
*preg_replace()
*Regular Expression Tester
preg_match()
preg_replace()
Regular Expression Tester
Regular Expression Syntax
*Start and End ( ^ $ )
*Number of Occurrences ( ? + * {} )
*Common Characters ( . \d \D \w \W \s \S )
*Grouping ( [] )
*Negation ( ^ )
*Subpatterns ( () )
*Alternatives ( )
*Escape Character ( \ )
Start and End ( ^ $ )
Number of Occurrences ( ? + * {} )
Common Characters ( . \d \D \w \W \s \S )
Grouping ( [] )
Negation ( ^ )
Subpatterns ( () )
Alternatives ( )
Escape Character ( \ )
Form Validation Functions with Regular Expressions
Conclusion
*Session Control and Cookies
Sessions
*Configuring Sessions
*Session Functions
Configuring Sessions
Session Functions
Cookies
Conclusion
*Sending Email with PHP
mail()
*Shortcomings of mail()
Shortcomings of mail()
PHPMailer
Conclusion
*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