PHP and MySQL Web Development (4th Edition)

Authors Luke Welling and Laura Thomson's technique aims to get readers going on their own projects as soon as possible. They present easily digestible sections on specific technical processes--"Accessing array contents" and "Using encryption with PHP" are two examples. Each section centers on a sample program that strips the task at hand down to its essentials, enabling the reader to fit the process into his or her own solutions as required. Tables that list options and other nuggets of reference material appear as well, but the many examples and the authors' commentary on them take center stage.

For reference material on MySQL, have a look at Paul DuBois's MySQL. On the PHP side, Web Application Development with PHP 4.0 is excellent. --David Wall

Topics covered:

• The MySQL database server (for both Unix and Windows)
• Accessing MySQL databases through PHP scripting (the letters don't really stand for anything)
• Database creation and modification
• PHP tricks in order of increasing complexity--everything from basic SQL queries to secure transactions for commerce
• Authentication
• Network connectivity
• Session management
• Content customization

PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server.

This practical, hands-on book includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, connecting to Web services using XML, and developing Web 2.0 applications with Ajax-based interactivity.

The fourth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP 5 through version 5.3, such as namespaces and closures, as well as features introduced in MySQL 5.1.

I'm an experienced C/C++ programmer on Windows, but I knew nothing about PHP and MySQL -- and very little about Apache and Unix -- prior to opening this book. I've now read about 80% of it and, in the process, I've built a commercial-grade Website with user registration and shopping cart facilities, which was my objective. Reading this book was a very efficient use of my time -- it gave me exactly what I needed to build a practical Web application system with PHP and MySQL, and very little extraneous stuff.

The main prerequisite for this book is a working knowledge of HTML, and just a little background in procedural programming. Some of the earliest examples use HTML tags for tables and forms, with PHP use thoroughly explained, but without many notes on the HTML. A beginning programmer can learn effectively from this book, but as an experienced programmer I felt that it also worked well to bring me up to speed quickly on a new language.

Another value of this book not mentioned in other reviews are the many good recommendations for organizing your PHP code (applying basic software engineering principles) as your Web application gets larger and more complex. Many, many Websites have been built haphazardly and are now difficult to maintain because they haven't followed the excellent advice in this book.

I did notice the typos mentioned by other reviewers, but after reading 80% of this (867-page) book I feel they are very minor and really do not detract from the book significantly at all.

All in all, this is one of those rare books that is probably worth ten times the amount that you pay for it, and much more if you use it effectively.


Sams vs. O'Reilly PHP & MySQL books: Which one to buy?   October 15, 2002
macktheknife (Northern, CA)
123 out of 129 found this review helpful

I have just started learning some PHP & MySQL development using "PHP & MySQL Web Development" published by Sams and "Web Database Applications with PHP & MySQL" from O'Reilly. Prospective readers might be wondering the difference between the two in deciding which one to buy, so I hope to shed some light on the issue.

Sams: The Welling and Thomson book is more "hands-on" in that it takes the reader step-by-step in developing an e-commerce website. The chapters are organized in a goal-oriented manner: PHP, MySQL, the basics of e-commerce, security, and design of the site.

O'Reilly: The Williams and Lane book is structured in a similar way by showing readers PHP and then MySQL. Examples to reinforce concepts are also provided. While the O'Reilly book also tries to take the reader in developing an e-commerce site, it is a bit more theoretical. Also, there are some differences in focus: the O'Reilly book has a section on using JavaScript while the Sams book has a final chapter on creating PDF files using PHP.

If I had to choose just one book, I would go with the Sams book due to its more gentle learning curve. However, I believe that the O'Reilly book is no slouch, and I will probably come to appreciate it more once I gain more experience in PHP and MySQL development.

One last word about my programming background: I knew a bit of Perl, Java, HTML, and JavaScript before tackling PHP and MySQL. I consider myself to be an "advanced beginner" (an oxymoron, of course). To get the most out of these two books, you should know HTML well enough to read it (you should at least recognize some tags) and it would definitely be helpful if you have some programming experience. You could very well make PHP your first programming language, but I would advise against it. Start with something like Perl (whose syntax is very similar to PHP's).

I highly recommend both books to prospective PHP and MySQL developers who are willing to spend some time and effort.


sleek and purple   July 30, 2001
40 out of 42 found this review helpful

Although it has a purple spine, this book contains everything a person would hope to know about php and mysql. From the basics of php 4.0 to mysql privleges, Welling and Thomson provide quick easy and painless reading.

It provides it's message to the windows crowd, which in itself is a beautiful concept; usually books about php and mysql are directed at unix users (rightfully so, I admit). I am a user of windows, and the php installation instructions for either the windows build of Apache or MS IIS were definately adequate.

The php crash course chapter is an especially good reference. For example, other books I've purchased on php ignored some of the useful variations of the if-then control structure. The chapter on php session control was beautifully simple, although at first it came as a surprise, since other php books didn't cover it (session control was first implemented in php 4.0).

I did have some difficulty installing and using the gd image library, since most of the sites listed in the book didn't exist. Windows users, just remember that the php.ini file needs to be edited (remove the semicolon before the gd dll) and the gd dll needs to be moved into the php working directory. Of course, maybe that's intuitive and I'm just a moron.

In conclusion, it's a good book.


Impressed   April 23, 2001
39 out of 41 found this review helpful

You never know what your really going to get when you buy a book online but I am totally happy with this purchase. This book offers real world examples and full source code for many of the PHP/MySQL projects developers tackle on a day to day basis. Details can be found on: Image generation, cookies, user authentication, shopping carts, content management, mailing-lists, PDF document generation and a lot of detail on how to set up and install both PHP and MySQL on your server. The authors do not only show you the code but explain what's happening so that you can customize the scripts for your own use and they do this very well. This book is aimed at intermediate web developers who are familiar with HTML, some type of programming (ASP, Perl), but you certainly do not have to be an expert programmer to understand what's going on. All and all-the best web programming book I've bought, period.


Excellent feature demonstration -- a buyer!   November 4, 2002
Todd E Smith
21 out of 21 found this review helpful

I don't write alot of reviews, and hardly ever give 5 stars, but this one is worth it. This massive text (800+ pages) includes all of the basic elements that either a beginner or an advanced user may look to a text for assistance with (note: these subjects, PHP and web databases, are traditionally self-taught at this time, a good text is ESSENTIAL!). The CD includes open source licensed Apache, PHP and MySQL (Linux and WIN), and all code from the book.

The book format is logical and good for self-pacing; early sections teach PHP language features (including arrays, regular expressions, objects/classes), then MySQL language and calling constructs (RDMS design theory, SELECT, UPDATE, INSERT, and advanced SQL). Later chapters discuss implementing user authentication and security, session mgmt and other advanced concepts. Final chapters (over 250 pages) provide ample example web database applications that probably cover about any project you would use these languages for (including shopping cart, content mgmt, web-based e-mail, mailing list mgr and a web-based forum). The final chapter describes using PDF to format text documents (my ISP does not provide this module therefore I skipped that section).

I recently began a private web database project and made the decision to proceed open source (PHP, MySQL) versus going the Microsoft way (ASP, SQL Server). This meant I had to learn PHP and MySQL. I purchased 4 books and the Welling & Thomson text was most utilized of all. My only gripe is they don't provide summary reference sections on PHP and MySQL functions / commands. You will probably just download the official user manuals for these anyway.

This book is well worth the price, IMHO.