Beginning PHP4 Databases by Andrew Hill, Chris Lea, Christopher Scollo, Deepak Thomas, Harish Rawat.
Published by Wrox Press. Sample Chapter: click here
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!
DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.
