PHP and MySQL Web Development [Paperback]

This is the book I purchased to get started on server-side scripting; it probably says "user-level intermediate-advanced" to avoid lawsuits; I had no prior knowledge of server-side programming, and no trouble understanding.

It is divided in four logical parts:
(1) PHP tutorial
(2) MySQL tutorial
(3) General discussion on server-side scripting & e-commerce (very interesting)
(4) Projects

This book does an excellent job at explaining PHP & MySQL to the beginner, and goes much beyond the frustrating "intermediate" level where similar books often stop. It assumes a working knowledge of HTML, which everyone interested in this book already has in all likelihood.

It is cleverly written, clear and concise. The authors share their extensive experience with the reader, notably in the third part where common pitfalls are discussed.

The index is well done, which makes this book an excellent desktop reference in addition to being a good tutorial.

The CD contains all the code for the examples, the complete book in searchable PDF, and other goodies like the Apache Server and PHP.

My recommendation: go to phpide.de and download PHPTriad to install & configure Apache/PHP/MySQL on your PC, or have someone knowledgeable do it manually for you to avoid headaches.

The only reason I can't give five stars to the first or second edition is the number of mistakes/typos in the code examples. The upload code doesn't work, PDF generation uses obsolete functions even in the second edition, etc.

Although most of the code supplied as example functions properly, it is annoying to know that a book written to teach you to program contains errors in the programming examples.

The second edition adds a chapter about XML and removes outdated URLs. Otherwise, it is the same book (including code typos).

Combined with the PHP & MySQL manuals available for download from their respective sites, allow a week or two of reading and you should have everything needed to start working.

All things considered, I strongly recommend this book.

PS: if your heart balances between ASP & PHP for server-side, consider that more servers are PHP-enabled, since it is cheaper (free).
If you want to stay in known terrain and use JScript, than go for ASP.

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.

The book gives you a little of both world: PHP and MySQL. Teaching you the most popular functions of both PHP and MySQL, you should be able to write your own simple MySQL-driven PHP powered website or application in no time.

The book also dwell into simple real-world web applications written in PHP which you can build upon as you learn. These apps include: a web mail based service, a mailing list generator, a web forum, a content managing system and even a shopping cart system! All source and even the entire book is included within the accompanying CD-ROM disc.

This book alone is more than enough to get you started with PHP and MySQL programming. Of course, if you want to master or fine tune your skills in this field, I would suggest you continue your reading with: "PHP Functions", "Web Application Development with PHP 4.0", and "MySQL"; all published by New Rider.