See more Amazon Details

Contents Listing

Preface



1. Database Applications and the Web

Three-Tier Architectures

The Client Tier

The Middle Tier

The Database Tier

Our Case Study



2. PHP

Introducing PHP

Conditions and Branches

Loops

A Worked Example

Arrays

Strings

Regular Expressions

Date and Time Functions

Integer and Float Functions

User-Defined Functions

Objects

Common Mistakes



3. 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



4. Querying Web Databases

Connecting to a MySQL Database

Formatting Results

Case Study: The Front-Page Panel

Interacting with Other DBMSs Using PHP



5. User-Driven Querying

User Input

Querying with User Input

Case Study: Previous and Next Browsing

Case Study: Producing a select List



6. Writing to Web Databases

Database Inserts, Updates, and Deletes

Issues in Writing Data to Databases



7. Validation on the Server and Client

Validation and Error Reporting for Web Database Applications

Server-Side Validation

Client-Side Validation with JavaScript



8. Sessions

Building Applications That Keep State

Session Management Over the Web

PHP Session Management

Case Study: Adding Sessions to the Winestore

When to Use Sessions



9. Authentication and Security

HTTP Authentication

HTTP Authentication with PHP

Authentication Using a Database

Web Database Applications and Authentication

Protecting Data on the Web



10. Winestore Customer Management

Overview of the Winestore Application

Customer Management

Authenticating Users

The Winestore Include Files



11. The Winestore Shopping Cart

The Winestore Home Page

The Shopping Cart Architecture

Managing Redirection



12. Ordering and Shipping at the Winestore

Finalizing Orders

HTML and Email Receipts



13. Related Topics

Automated Housekeeping

Templates

Searching and Browsing



A. Installation Guide



B. Internet and Web Protocols



C. Modeling and Designing Relational Databases



D. Managing Sessions in the Database Tier



E. Resources



Index