MySQL/PHP Database Applications

BRAD BULGER is a seasoned software developer who has worked for several companies that no longer exist and is now a member of The Madfish Group, where he builds Web sites. JAY GREENSPAN is a New York-based writer, editor, and technical consultant. He is author of MySQL Weekend Crash Course(r) and runs Trans-City Productions, Inc., a firm that provides editorial services to high-tech companies. DAVID WALL is a freelance technical consultant, lecturer, and writer operating through his consultancy David Wall Enterprises. He specializes in Linux/Apache/MySQL/PHP (LAMP) servers and in Voice over IP technologies from IBM and Cisco Systems.

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