PHP MySQL Website Programming: Problem - Design - Solution shows the development process for a web site using a specific set of technologies: the Apache web server, the MySQL database system, and the PHP scripting language. It gives you a completely hands-on experience and guides you through the construction of a complete application-driven site from design to deployment.

Each chapter in the book is broken into three parts:

• Problem: The authors analyze each task and identify areas that may be particularly hard to implement.
• Design: Once the problems have been identified, a proposal is sketched out for solving them.
• Solution: The code is developed and deployed to accomplish the task at hand.

Throughout the book, good object-oriented PHP coding methods are used where appropriate. The site you construct features a modular design, so the individual chapters are generally focused on designing and building a specific piece of the site's functionality. A working model of the site can be found online at http://apress.mediatemple.net

On the whole, this book provides a lot of insight into the ways you can implement web applications with PHP and MySQL in real-world situations.

Table of Contents

Chapter 1: Building a PHP MySQL Web Site
Chapter 2: Planning the Web Site
Chapter 3: Designing the User Interface
Chapter 4: Managing Users and Sessions
Chapter 5: Visitor Accounts
Chapter 6: Dynamic News Content
Chapter 7: Syndication
Chapter 8: Advertising
Chapter 9: Online Polls
Chapter 10: User Discussion Forums
Chapter 11: Newsletters and Mailing Lists
Chapter 12: Shopping Carts
Chapter 13: Checking Out
Chapter 14: The Road Ahead