Database Applications and the Web

• The Web
• Three-Tier Architectures

The PHP Scripting Language

• Introducing PHP
• Conditions and Branches
• Loops
• Functions
• Working with Types
• User-Defined Functions
• A Working Example

Arrays, Strings, and Advanced Data Manipulation in PHP

• Arrays
• strings
• Regular Expressions
• Dates and Times
• Integers and Floats

Introduction to Object-Oriented Programming with PHP 5

• Classes and Objects
• Inheritance
• Throwing and Catching Exceptions

SQL and MySQL

• Database Basics
• MySQL Command Interpreter
• Managing Databases and Tables
• Inserting, Updating, and Deleting Data
• Querying with SQL SELECT
• Join Queries

Querying Web Databases

• Querying a MySQL Database Using PHP
• Processing User Input
• MySQL Function Reference

Writing to Web Databases

• Database Inserts, Updates,and Deletes
• Issues in Writing Data to Databases

Sessions

• Introducing Session Management
• PHP Session Management
• Case Study: Using Sessions in Validation
• When to Use Sessions
• PHP Session API and Configuration

Authentication and Security

• HTTP Authentication
• HTTP Authentication with PHP
• Form-Based Authentication
• Protecting Data on the Web

Errors, Debugging, and Deployment

• Errors
• Common Programming Errors
• Custom Error Handlers

Advanced Features of Object-Oriented Programming in PHP 5

• Working with Class Hierarchies
• Class Type Hints
• Abstract Classes and Interfaces

Advanced SQL

• Advanced Querying
• Manipulating Data and Databases
• Functions
• Automating Querying
• Table Types

Practical Application

• Creating a PHP & MySQL Application