This book aims to teach the skills necessary to develop any size web application with PHP, backed by a database. They start off with the now de facto PHP introduction and then jump head first into database fundamentals. Nearly half of this book is devoted to teaching database layout, design, and use. This is long over due in the PHP community. Too many PHP developers are creating database enabled applications that have absolutely no prior experience with databases! This book covers everything from elementary topics, such as table creation, selects, inserts, and deletes, to advanced database usage with joins, stored procedures, triggers, and cursors. While they did cover indexing, I feel that it was a bit lacking and could have used a more in depth exploration.
One pleasant surprise was that no one particular database is favored; in fact use of the database abstraction layer in PEAR is encouraged for code portability. I am encouraged by the use of PEAR in this book, as it can only help to bring the community together in its use and promote PEAR as a standard of sorts. The PEAR database abstraction layer is picked apart so that you may understand exactly how it works and be that much more efficient with using it.
At the end of this book, it offers two chapters dedicated to designing and implementing applications using a native XML database. The first of the two chapters concentrates on the fundamentals of native XML databases; what they are and how they work. The second chapter then presents a case study using Xindice.
I found this book to be very thorough and well put together. Cheers to Wrox for another fine book!
