Web Database Applications with PHP and MySQL, 2nd Edition

 1. Database Applications and the Web.

      The Web

      Three-Tier Architectures

 2. The PHP Scripting Language.

      Introducing PHP

      Conditions and Branches

      Loops

      Functions

      Working with Types

      User-Defined Functions

      A Working Example

 3. Arrays, Strings, and Advanced Data Manipulation in PHP.

      Arrays

      Strings

      Regular Expressions

      Dates and Times

      Integers and Floats

 4. Introduction to Object-Oriented Programming with PHP 5.

      Classes and Objects

      Inheritance

      Throwing and Catching Exceptions

 5. SQL and MySQL.

      Database Basics

      MySQL Command Interpreter

      Managing Databases and Tables

      Inserting, Updating, and Deleting Data

      Querying with SQL SELECT

      Join Queries

      Case Study: Adding a New Wine

 6. Querying Web Databases.

      Querying a MySQL Database Using PHP

      Processing User Input

      MySQL Function Reference

 7. PEAR.

      Overview

      Core Components

      Packages

 8. Writing to Web Databases.

      Database Inserts, Updates, and Deletes

      Issues in Writing Data to Databases

 9. Validation with PHP and JavaScript.

      Validation and Error Reporting Principles

      Server-Side Validation with PHP

      JavaScript and Client-Side Validation

10. Sessions.

      Introducing Session Management

      PHP Session Management

      Case Study: Using Sessions in Validation

      When to Use Sessions

      PHP Session API and Configuration

11. Authentication and Security.

      HTTP Authentication

      HTTP Authentication with PHP

      Form-Based Authentication

      Protecting Data on the Web

12. Errors, Debugging, and Deployment.

      Errors

      Common Programming Errors

      Custom Error Handlers

13. Reporting.

      Creating a Report

      Producing PDF

      PDF-PHP Reference

14. Advanced Features of Object-Oriented Programming in PHP 5.

      Working with Class Hierarchies

      Class Type Hints

      Abstract Classes and Interfaces

      Freight Calculator Example

15. Advanced SQL.

      Exploring with SHOW

      Advanced Querying

      Manipulating Data and Databases

      Functions

      Automating Querying

      Table Types

      Backup and Recovery

      Managing Users and Privileges

      Tuning MySQL

16. Hugh and Dave's Online Wines: A Case Study.

      Functional and System Requirements

      Application Overview

     Common Components

17. Managing Customers.

      Code Overview

      Customer Validation

      The Customer Form

18. The Shopping Cart.

      Code Overview

      The Winestore Home Page

      The Shopping Cart Implementation

19. Ordering and Shipping at the Online Winestore.

      Code Overview

      Credit Card and Shipping Instructions

      Finalizing Orders

      HTML and Email Receipts

20. Searching and Authentication in the Online Winestore.

      Code Overview

      Searching and Browsing

      Authentication

A. Linux Installation Guide

B. Microsoft Windows Installation Guide

C. Mac OS X Installation Guide

D. Web Protocols

E. Modeling and Designing Relational Databases

F. Managing Sessions in the Database Tier

G. Resources

H. The Improved MySQL Library

Index