O'REILLY Web Database Application with PHP & MySQL By Hugh E.Williams & David Lane
Chapter1.Database Applications and the web
Three-Tier Architectures
The client tier
The Middle Tire
The Database Tier
Chapter2.PHP
Introduction PHP
Conditions and Branches
Loops
A worked example
Arrays
Strings
Regular Expressions
Date and Time Functions
Integer and Float Functions
User-Defined Functions
Objects
Chapter3. MySQL and SQL
Database basics
Quick Start Guide
MySQL Command Interpreter
Managing Databases,Tables,and Indexes
Inserting,Updating,and Deleting Data
Querying with SQL SELECT
Join Queries
Modifying the database
Functions
More on SQL and MySQL
Chapter4.Querying WebDatabases
Connecting to a MySQL Database
Formatting Results
Chapter5.User-Driven Querying
User Input
Querying with User Input
Chapter6.Writing to WebDatabases
Database Inserts,Updates,and Deletes
Issues in Writing Data to Databases
Chapter7.Validation on the Server and client
Validation and Error Reporting for Web Database Applications
Server-side Validation
Client-side Validation with JavaScript
Chapter8.Sessions
Building Applications That Keep sate
Session Management Over the Web
PHP Session Management
Chapter9.Authentication and security
HTTP Authentication
HTTP Authentication with PHP
Authentication Using a Database
Web Database Applications and Authentication
Protecting Data on the Web
Chapter10.Winestore Customer Management
Overview of the Winestore Application
Customer Management
Authenticating Users
The Winestore Include Files
Chapter11.The winestore Shopping cart
The winestore Home Page
The Shopping Cart Architecture
Managing Redirection
Chapter12.Ordering and Shipping at the Winestore
Finalizing Orders
HTML and Email Receipts
Chapter13.Related Topics
Automated HouseKeeping
Templates
Searching and Browsing.Download