PHP and MySQL Web Development
(4th Edition)

Programming with PHP and MySQL with security in mind.

By: Staff


Many PHP books follow a similar arc: start with a bit of history of PHP, the major control structures and commands, then a series of simple projects maybe followed by an appendix or two listing various commands. Luke Welling and Laura Thomson's book is not dissimilar in this regard, except that it does a better job, especially in depth of material covered and the often skimped-on sections covering writing secure web applications.

It could be said that one the major selling features of (PHP) web frameworks is they can sometimes prevent novice coders from doing truly insecure things simply by following the way things are demonstrated in a dozen PHP books. Many books still show pulling data from the $_POST variable and sticking it onto a page -- or worse -- in to a database. Now of course that is fine if you've got the Internet to yourself, but sooner or later someone or something unexpected will bite you. Fortunately this book will show you a couple of good ways to head off many potential holes in your application early on.

In fact, the security is one of the best reasons to pick up this book, even if you are relying on the built-in sanitation of your framework of choice. All the good stuff from asking yourself where are the problems going to come from and securing your server and database in various ways to explaining and how to SSL works and using it; and of of course asking questions like, "do I need to be storing your customers' credit card details in the first place?"- Probably not.

Some other good things about this book: the designing databases section is quite good. I like the approach they take asking, "what do you want to ask MySQL?" as a way of organizing the database leading to efficientquerys . Another good part is on choosing field types (not every numeric field has to be an INT) and avoiding redundant or empty fields. The book uses MySQL 5.1 so it has coverage of stored procedures, views, replication and a few other features. I was a bit surprised that they use the PEARMBD2 library for DB access, not PDO. But I think it's a good decision, as a good database library can save a lot of repetitive code and performance-wise it's pretty good. In short, the book is a few steps above the usual coverage MySQL.

After the first four sections (covering PHP, MySQL, e-commerce, advanced PHP), there is a section of projects. These seven include a shopping cart, e-mail service (WarmMail), forum and a PDF generator. There's some coverage of Ajax and using web services as well. I particularly liked the forum, as like other things in this book, it seemed more like something that could be used in an actual project.

If there is an area that the book doesn't cover, it's testing -- every programmer's favourite task --, except for some mentions of it, there isn't really a section dedicated to it. The closest is the coverage in the Developing large projects section. Here they cover planning, prototyping, debugging, but beyond mention of regression testing, there isn't too much.

Like the MySQL book reviewed last week this is a big volume, also about 1000 pages. A bit of an oddity in this day is the book comes with a CD with the source code for the book, the book in .pdf format and installs for Windows and Linux of PHP, Apache and MySQL. With the coverage of both MySQL 5 and some of the newest features of PHP 5.3, it's book that won't be outdated next month. I'm not sure if this is a complete beginner's book, but it's probably one book that all intermediatePHP developers could benefit from.

Date published: 18-Dec-2008





Professional CodeIgniter

Set your code on fire, professionally. Seriously, it's a bright red book about the popular PHP framework.

CakePHP Applications Development

Learning the CakePHP 1.2 framework though examples.

Learning jQuery 1.3

Learning to use jQuery to build better websites, though examples and popular plug-ins.

Coders at Work

Talking to programmers.

Algorithms in a Nutshell

Before picking an algorithm know what problem you're trying to solve.


2017 YYZTech

For American computers stores, visit: AmericanComputerDealer.com