PHP MySQL Website Programming: Problem - Design - Solution

Front Cover

PHP MySQL Website Programming: Problem-Design-Solution shows the development process for a website 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. You can find a working model of the site online at

This invaluable tutorial provides a lot of insight into the ways you can implement web applications with PHP and MySQL in real-world situations.


What people are saying - Write a review

We haven't found any reviews in the usual places.


Building a PHP MySQL Web Site
Planning the Web Site
Designing the User Interface
Managing Users and Sessions
Visitor Accounts
Dynamic News Content
User Discussion Forums
Shopping Carts
Checking Out
The Road Ahead

Other editions - View all

Common terms and phrases

About the author (2003)

Dilip Thomas hails from the sleepy little town of Cochin, set in God's own country (India). He is committed to the PHP community, and much of his thrill comes from peering into that community from a philosophical perspective. He first got hooked onto open source in his sophomore days in college, and he has been playing the role of a technology evangelist ever since. His interests also lie in the Apache Jakarta project and open standards technologies in general. He was once spotted organizing bungee jumping shows to flustered audiences in his favorite city of Bangalore.

Jessey White-Cinis is a freelance contractor currently living in Los Angeles. His expertise lies primarily in core-level web programming and development; however, he also has an extensive background in *NIX system administration. Jessey began his career in Kansas as a developer for (now Earthlink) at the age of 17. When he was 19, Jessey moved back to his hometown of Los Angeles to work as a webmaster, developer, and systems administrator for Epitaph Records. These days, Jessey enjoys working on a wide variety of web development projects while maintaining close professional relationships with his former employers. In his "free time," Jessey enjoys traveling, mountain biking, and writing and producing his own music.

Chris Lea is, on his better days, a developer. He started out on the East Coast, going to school at the University of North Carolina at Chapel Hill and earning a bachelor's degree in physics with highest honors and distinction. Fortunately, he managed to escape graduate school and made it to sunny Los Angeles, which is where he currently spends most of his time. If you track him down, it's likely that he will be playing around with Linux, Apache, PHP, and other related bits of software. For fun, he sees his friends, plays his guitar, and harasses Mike Buzzard over instant messenger.

Mike Buzzard is a self-taught applications developer residing in San Francisco. He is a partner member of Cuban Council, a freelance collective of programmers and designers based in the United States and Denmark. Mike spends most of his time building web-based software solutions using a wide array of languages, platforms, and databases for the entertainment industry as well as the international online design community. Mike's work history ranges from software development companies to architecture and engineering services, where his efforts have always been focused toward online applications development. In his spare time, Mike occasionally guest lectures at Stanford University, where he instructs students in PHP and MySQL for solving course projects involving art, product design, and communications.

Bibliographic information