Build Your Own Database Driven Website Using PHP and MySQL, 3rd Edition
By Kevin Yank
Publisher: SitePoint
Final Release Date: October 2004
Pages: 373

Build Your Own Database-Driven Website Using PHP & MySQL is a practical guide for first-time users of PHP & MySQL that teaches readers by creating a fully working Content Management System, Shopping Cart and other real-world applications. There has been a marked increase in the adoption of PHP, most notably in the beginning to intermediate levels. PHP now boasts over 30% of the server side scripting market (Source:

The previous edition sold over 17,000 copies exclusively through alone. With the release of PHP 5, SitePoint have updated this bestseller to reflect best practice web development using PHP 5 and MySQL 4.

The 3rd Edition includes more code examples and also a new bonus chapter on structured PHP Programming which introduces techniques for organizing real world PHP applications to avoid code duplication and ensure code is manageable and maintainable. The chapter introduces features like include files, user-defined function libraries and constants, which are combined to produce a fully functional access control system suitable for use on any PHP Website.

Product Details
Recommended for You
Customer Reviews


by PowerReviews
oreillyBuild Your Own Database Driven Website Using PHP and MySQL, 3rd Edition

(based on 3 reviews)

Ratings Distribution

  • 5 Stars



  • 4 Stars



  • 3 Stars



  • 2 Stars



  • 1 Stars



Reviewed by 3 customers

Sort by

Displaying reviews 1-3

Back to top


This is a great intro to PHP & MySQL

By AndrewAK

from Anchorage, Alaska

About Me Bookworm


  • Easy To Follow
  • Informative
  • Well Written


    Best Uses

    • Educational
    • Reference
    • Staying Informed

    Comments about oreilly Build Your Own Database Driven Website Using PHP and MySQL, 3rd Edition:

    The examples were easy to understand and I was able to apply them to my own projects with minimal manipulation.

    (1 of 1 customers found this review helpful)


    Good for developers wanting to learn PHP

    By Regnard Kreisler Review

    from Undisclosed

    Comments about oreilly Build Your Own Database Driven Website Using PHP and MySQL, 3rd Edition:

    Kevin Yank's take on the very popular combo of PHP and MySQL presents an easy to follow blueprint in building a dynamic website_ It spends the first few chapters dealing with the ground work (installation of servers, basics of database design, etc.) and then proceeds to building a fully functional content management system.

    The book also takes time to deal with nitty-gritty functions like error-handling and file operations in the code, a nice touch for server-side newbies.

    The simplistic step-by-step approach is perfect for web designers wanting to move into web development, but may disappoint advanced users. The book also offers little reference to PHP functions. All code in the book can be downloaded online.

    Build Your Own Database Driven Website Using PHP and MySQL is recommended for developers with working knowledge of HTML who would like to have hands-on PHP-MySQL experience on the get-go.

    (1 of 1 customers found this review helpful)


    Little depth, but a good introduction

    By Kerry DeMatteis

    from Undisclosed

    Comments about oreilly Build Your Own Database Driven Website Using PHP and MySQL, 3rd Edition:

    Author Kevin Yank states up front that this book is intended for intermediate- to advanced-level Web designers. I think this is an appropriate designation, as a beginner would quickly become overwhelmed at the rate with which Yank introduces such heady topics as Relational Database Design (Chapter 5) and Regular Expressions (Chapter 7). It's important to note that this book is an introduction to server-side technologies, not web site design; therefore, I recommend that the reader have experience with creating web sites and with client-side coding (HTML, JavaScript). Consider the pace: Chapters 1-3 of the book cover installation, your first MySQL database, and your first PHP page. Then by Chapter 6, the reader is coding a (admittedly rudimentary) content-management system!

    Is this book for you? Consider that for the price, you get a basic introduction to a broad number of topics: 1) PHP installation, 2) MySQL installation, 3) relational database design, 4) using server-side programming to reduce client-side coding, 5) database administration, 6) writing effective SQL queries, 7) structured programming techniques, such as using includes, and 8) implementing cookies and sessions. If you are already comfortable with at least half of the topics in this list, then you are probably ready to graduate to a more in-depth book than this one. If much of this sounds new to you, then you will find Yank's book an excellent introduction. Yank writes as if he was a friendly tour guide, at each step of the way walking you through what he has done and why he chose to do it that way. Because the style is so conversational, it's easy to go back and re-read a chapter, which many readers might find themselves doing.

    While the cover of the 3rd Edition (February 2005 update) goes at length to point out that the book covers PHP5, there is negligible content that goes beyond PHP4.x. None of the coding, and none of the author's discussions on effective programming techniques, addresses OO programming at all, let alone how it's implemented in PHP5. This is not necessarily a negative aspect of the book since, again, it's essentially an introduction. Just don't let the packaging fool you into thinking you're getting more than you actually are.

    For me, the primary value of a book like this is in the initial chapter, where it provides all of the necessary steps for installing PHP and MySQL in one place. While the online documentation for both technologies is excellent, I have found that it can be confusing to switch back and forth between the two sites to get your own set-up installed and configured. If you're like me and must add Apache installation to the process, it only compounds the problem. Yank provides clear instructions for Windows and Linux users, with a nod to Mac X users, on installation and post-installation tasks.

    Mainly for this information, this book is an excellent way to get started with server-side technology, but it is not at all suitable for production purposes. As with any server or server-side technology, security is a major and much-debated topic of concern with PHP and MySQL. Yank does address some of the basic methods of protecting a MySQL server from attacks, including how to password-protect the root user account and how to grant only necessary access to new users. I'm sure many PHP programmers will argue with Yank's recommendation that PHP's "Magic Quotes" feature be left On, since turning it Off "exposes you to hackers attempting SQL injection attacks on your Website if you are not very careful to write scripts that protect themselves from such malicious behavior" (p. 24). Mind you, he is simply quoting the recommendation at, since the On setting is recommended for beginners, but it points out why this book is not suitable for production-ready applications. Yank does provide abundant footnotes for the reader to find more detailed information, including the online documentation at and

    Yank very often invites the reader to consult the forums at for further information and advice. Do not construe this as a mere marketing ploy. The SitePoint forums are indeed an excellent resource, with an active and often well-experienced audience.

    All of the code listed in the book is available as a download from Simply provide your e-mail address, then you will be prompted with a question that you can answer only if you have the book in front of you.

    Errata for the 3rd Edition can be found at:

    Displaying reviews 1-3

    Back to top

    Buy 2 Get 1 Free Free Shipping Guarantee
    Buying Options
    Immediate Access - Go Digital what's this?
    Print: $39.95
    The shipment of this item may be delayed.