PHP MySQL Website Programming: Problem - Design - Solution / Edition 1

Paperback (Print)
Buy New
Buy New from
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 96%)
Other sellers (Paperback)
  • All (19) from $1.99   
  • New (9) from $29.02   
  • Used (10) from $1.99   


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.

Read More Show Less

Product Details

  • ISBN-13: 9781590591505
  • Publisher: Apress
  • Publication date: 7/17/2003
  • Edition description: 2002
  • Edition number: 1
  • Pages: 528
  • Product dimensions: 1.06 (w) x 9.61 (h) x 6.69 (d)

Meet the Author

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.

Read More Show Less

Table of Contents

Introduction 1
Ch. 1 Building a PHP MySQL Web Site 7
Ch. 2 Planning the Web Site 17
Ch. 3 Designing the User Interface 35
Ch. 4 Managing Users and Sessions 57
Ch. 5 Visitor Accounts 107
Ch. 6 Dynamic News Content 151
Ch. 7 Syndication 187
Ch. 8 Advertising 209
Ch. 9 Online Polls 259
Ch. 10 User Discussion Forums 293
Ch. 11 Newsletters and Malling Lists 351
Ch. 12 Shopping Carts 391
Ch. 13 Checking Out 433
Ch. 14 The Road Ahead 469
Index 483
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted July 30, 2004

    Very sloppy, poorly supported by code.

    The design of the example web site is novel, and the code is promising, but there are many errors in the code, some very simple. For example, the authors state a .htaccess file or php.ini should be modified to have a correct include path - neither of these worked, but using ini_set() function does work. There are many of the error functions that do not work properly because the code uses a Mail::Error reference or DB::Error reference but really needs to be a Pear::Error reference. I would not waste good money on this book, but if you find it in a second hand store or someone gives it to you (which is how I received it), there are some useful ideas.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)