Acknowledgments.

Introduction.

Part I: Working with MySQL.

Chapter 1 Database Design with MySQL.

Chapter 2 The Structured Query Language for Creating and Altering Tables.

Chapter 3 The Structured Query Language for Inserting, Editing, and Selecting Data.

Part II: Working with PHP.

Chapter 4 Getting Started with PHP—Variables.

Chapter 5 Control Structures.

Chapter 6 PHP’s Built-in Functions.

Chapter 7 Writing Organized and Readable Code.

Part III: Simple Applications.

Chapter 8 Guestbook 2003, the (Semi-)Bulletproof Guestbook.

Chapter 9 Survey.

Part IV: Not So Simple Applications.

Chapter 10 Threaded Discussion.

Chapter 11 Content-Management System.

Chapter 12 Catalog.

Chapter 13 Problem-Tracking System.

Chapter 14 Shopping Cart.

Chapter 15 XML Parsing.

Chapter 16 SOAP.

Chapter 17 Project Management.

Part V: Appendixes.

Appendix A: What’s on the CD-ROM.

Appendix B: HTML Forms.

Appendix C: Brief Guide to MySQL/PHP Installation and Configuration.

Appendix D: MySQL Utilities.

Appendix E: MySQL User Administration.

Appendix F: PHP Function Reference.

Appendix G: Regular Expressions Overview.

Appendix H: Helpful User-Defined Functions.

Appendix I: PHP and MySQL Resources.

Appendix J: MySQL Function Reference.

Index.

End-User License Agreement.