Anyone looking to expand their current PHP knowledge level to that of an Advanced PHP developer. To gain the most from this class, you should already have:

* Completion of the "Introduction to PHP and MySQL"    course or equivalent experience from building    PHP/MySQL applications
* Experience developing web applications using PHP &    MySQL for at least six weeks after taking the    "Introduction to PHP and MySQL" course
* Practical experience using PHP syntax, functions, and    variables
* Practical experience with the SQL command set,    including SELECT, INSERT, and UPDATE

During the 3 days, this course will introduce you to a range of advanced PHP and MySQL techniques, including:

* Sticky forms
* Database design, creation, and optimization
* FULLTEXT searches
* Sortable display of database results
* Secure form validation
* Using HTTP headers
* Regular expressions

By the end of the course you will have created a basic content management , user registration, and simple e-commerce systems.

Unit 1: Introducing the Course

* Getting familiar with the course methodology and    format
* Understanding the course objectives and    prerequisites
* Why PHP and MySQL?

Unit 2: Introduction to PHP

* Basic Syntax
* Sending Data to the Web Browser
* Understanding PHP, HTML, and White Space
* Writing Comments
* What Are Variables?
* About Strings
* About Numbers
* About Constants
* Single vs. Double Quotation Marks

Unit 3: Programming with PHP

* Creating an HTML Form
* Handling an HTML Form
* Managing Magic Quotes
* Conditionals and Operators
* Validating Form Data
* What Are Arrays?
* For and While Loops

Unit 4: Creating Dynamic Web Sites

* Including Multiple Files
* Handling HTML Forms with PHP Redux
* Making Sticky Forms
* Creating and Calling Your Own Functions
* Variable Scope
* Date and Time Functions
* Sending Email

Unit 5: Introduction to SQL and MySQL

* Choosing Your Column Types
* Choosing Other Column Properties
* Using the mysql Client
* Creating Databases and Tables
* Inserting Records
* Selecting Data
* Using Conditionals
* Using LIKE and NOT LIKE
* Sorting Query Results
* Limiting Query Results
* Updating Data
* Deleting Data
* Using Functions

Unit 6: Advanced SQL and MySQL

* Database Design
* Performing Joins
* Grouping Selected Results
* Creating Indexes
* Using Different Table Types
* Performing FULLTEXT Searches
* Database Optimization

Unit 7: Error Handling and Debugging

* General Error Types and Debugging
* Displaying PHP Errors
* Adjusting Error Reporting in PHP
* Creating Custom Error Handlers
* Logging PHP Errors
* PHP Debugging Techniques
* SQL and MySQL Debugging Techniques

Unit 8: Using PHP with MySQL

* Modifying the Template
* Connecting to MySQL and Selecting the Database
* Executing Simple Queries
* Retrieving Query Results
* Ensuring Secure SQL
* Counting Returned Records
* Updating Records with PHP

Unit 9: Web Application Development

* Adjusting Behavior for Server Settings
* Sending Values to a Script Manually
* Using Hidden Form Inputs
* Editing Existing Records
* Paginating Query Results
* Making Sortable Displays
* Understanding HTTP Headers

Unit 10: Cookies and Sessions

* Using Cookies
* Using Sessions
* Sessions and Cookies
* Improving Session Security

Unit 11: Web Application Security

* More Secure Form Validation
* Handling HTML
* Validating Data by Type
* Form Validation with JavaScript
* Regular Expressions
* Database Security and Encryption

Unit 12: Extended Topics

* Handling File Uploads
* PHP and JavaScript
* Using Output Buffering
* Using the Improved MySQL Extension
* New MySQL Features
* Using PEAR

Unit 13: Example—Content Management

* Creating the Template
* Creating the Basic Pages
* Managing URLs
* Managing Files

Unit 14: Example—User Registration

* Creating the Templates
* Writing the Configuration Scripts
* Creating the Home Page
* Registration
* Activating an Account
* Logging In and Logging Out
* Password Management

Unit 15: Example—E-Commerce

* Creating the Database
* The Administrative Side
* Creating the Public Template
* The Product Catalog
* The Shopping Cart
* Recording the Orders