1. Chapter 1 Database Applications and the Web

   1. Three-Tier Architectures

   2. The Client Tier

   3. The Middle Tier

   4. The Database Tier

   5. Our Case Study

2. Chapter 2 PHP

   1. Introducing PHP

   2. Conditions and Branches

   3. Loops

   4. A Working Example

   5. Arrays

   6. Strings

   7. Regular Expressions

   8. Date and Time Functions

   9. Integer and Float Functions

   10. User-Defined Functions

   11. Objects

   12. Common Mistakes

3. Chapter 3 MySQL and SQL

   1. Database Basics

   2. Quick Start Guide

   3. MySQL Command Interpreter

   4. Managing Databases, Tables, and Indexes

   5. Inserting, Updating, and Deleting Data

   6. Querying with SQL SELECT

   7. Join Queries

   8. Modifying the Database

   9. Functions

   10. More on SQL and MySQL

4. Chapter 4 Querying Web Databases

   1. Connecting to a MySQL Database

   2. Formatting Results

   3. Case Study: The Front-Page Panel

   4. Interacting with Other DBMSs Using PHP

5. Chapter 5 User-Driven Querying

   1. User Input

   2. Querying with User Input

   3. Case Study: Previous and Next Browsing

   4. Case Study: Producing a select List

6. Chapter 6 Writing to Web Databases

   1. Database Inserts, Updates, and Deletes

   2. Issues in Writing Data to Databases

7. Chapter 7 Validation on the Server and Client

   1. Validation and Error Reporting for Web Database Applications

   2. Server-Side Validation

   3. Client-Side Validation with JavaScript

8. Chapter 8 Sessions

   1. Building Applications That Keep State

   2. Session Management Over the Web

   3. PHP Session Management

   4. Case Study: Adding Sessions to the Winestore

   5. When to Use Sessions

9. Chapter 9 Authentication and Security

   1. HTTP Authentication

   2. HTTP Authentication with PHP

   3. Authentication Using a Database

   4. Web Database Applications and Authentication

   5. Protecting Data on the Web

10. Chapter 10 Winestore Customer Management

    1. Overview of the Winestore Application

    2. Customer Management

    3. Authenticating Users

    4. The Winestore Include Files

11. Chapter 11 The Winestore Shopping Cart

    1. The Winestore Home Page

    2. The Shopping Cart Architecture

    3. Managing Redirection

12. Chapter 12 Ordering and Shipping at the Winestore

    1. Finalizing Orders

    2. HTML and Email Receipts

13. Chapter 13 Related Topics

    1. Automated Housekeeping

    2. Templates

    3. Searching and Browsing

1. Appendix A Installation Guide

   1. Installing MySQL, Apache, and PHP

   2. Installing the Winestore Examples

   3. Installing Apache to Use SSL

   4. Installation Resources

2. Appendix B Internet and Web Protocols

   1. The Internet

   2. Hypertext Transfer Protocol

3. Appendix C Modeling and Designing Relational Databases

   1. The Relational Model

   2. Entity-Relationship Modeling

4. Appendix D Managing Sessions in the Database Tier

   1. Using a Database to Keep State

   2. PHP Session Management

   3. MySQL Session Store

5. Appendix E Resources

   1. Client Tier Resources

   2. Middle Tier Resources

   3. Database Tier Resources

   4. Security and Cryptography Resources

6. Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Web Database Applications with PHP and MySQL is a platypus. The platypus (Ornithorhynchus anatinus) of Australia and Tasmania has been described as a living fossil. Its earliest known remains date back 100,000 years, and it combines mammalian and reptilian features. It is aquatic, furry, warmblooded, and lays eggs. It sports webbed feet, a beaverlike tail, and a ducklike bill.

The preferred plural of platypus is either "platypus" or "platypuses," and a baby platypus has been referred to as a "platapup."

The platypus was first described by Dr. George Shaw, a British scientist. He thought the animal was a hoax and took a pair of scissors to the pelt, expecting to find stitches attaching appendages to skin.

The platypus is an air-breathing mammal that spends most of its day resting in an underground burrow. However, it feeds only in the water and is rarely observed on land. The platypus hunts mostly at night for such food as shrimp, worms, and aquatic insects. Because the animal doesn't need to hear or see its intended food, a platypus protects its eyes and ears by automatically closing them underwater and relies on its bill to locate prey. While diving, the platypus temporarily stores food in special cheek pouches. When the animal returns to the surface to breathe, the food is ground up between rough pads located inside the bill.

A female platypus produces a clutch of one to three eggs in late winter or spring. The mother is believed to incubate them between her lower belly and curled-up tail for about 10 days as she rests in an underground nest made of vegetation collected from the water. She doesn't have nipples; her milk is instead secreted from two patches of skin midway along her belly. It's believed that a platypup feeds by slurping up milk with sweeps of its stubby bill. When juveniles enter the water at about four months, they are nearly as long as an adult.

The platypus is the only Australian mammal known to be venomous. Adult males have a pointed spur located above the heel of each hind leg that can inject poison produced by a gland in the thigh. Platypus venom isn't considered life-threatening to humans. However, spurring is painful, because platypus spurs are sharp and can be driven in with great force; the poison itself triggers severe pain in the affected limb. The platypus is officially classified as "common but vulnerable" in Australia. As a species, it isn't currently considered endangered. However, platypus populations are believed to have declined or disappeared, particularly in urban and agricultural settings; the specific underlying reasons for this decline is unknown. Mary Anne Weeks Mayo was the production editor and copyeditor for Web Database Applications with PHP and MySQL. Rachel Wheeler, Colleen Gorman, Emily Quill, and Jane Ellin provided quality control. Leanne Soylemez and Phil Dangler provided production assistance. Brenda Miller wrote the index.

Ellie Volckhausen designed the cover of this book, based on a series design by Edie Freedman. The cover image is an original engraving from Johnson's Natural History. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font.

Melanie Wang designed the interior layout, based on a series design by David Futato. Mihaela Maier converted the files from Microsoft Word to FrameMaker 5.5.6 using tools created by Mike Sierra. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont's The Sans Mono Condensed. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand 9 and Adobe Photoshop 6. The tip and warning icons were drawn by Christopher Bing. This colophon was compiled by Mary Anne Weeks Mayo.