Continuing copying my book reviews from my LinkedIn Amazon widget to my blog. As I’ve started implementing a new feature for Web2Intranet.com, I thought I’d give my reviews for a couple of the books I’ve used in developing that website.
Sams Teach Yourself PHP, MySQL and Apache All in One (4th Edition), by Julie C. Meloni
I found this to be an excellent introductory book on PHP and mySQL (as well as Apache), which is why I bought it. I’ve had in mind for a while now a website service I’ve wanted to implement, and used this book as the starting point in PHP programming a mySQL-based website (starting with zero knowledge in either PHP or databases). It was very helpful in creating and configuring a Linux and Windows web server, and the projects in the book became the starting point for the development of my own web service. I still refer to the book every now and then, though for PHP questions I typically use the PHP Manual at http://us3.php.net/manual/en, and for MySQL questions I’ve graduated to needing the “SQL For MySQL Developers” book.
SQL for MySQL Developers: A Comprehensive Tutorial and Reference, by Rick F. van der Lans
After developing my own MySQL-based website for a while, I got to the point of needing a more advanced MySQL reference than the introductory “Sams Teach Yourself PHP, MySQL and Apache” book that I had been using. “SQL for MySQL Developers: A Comprehensive Tutorial and Reference” has been that reference and has worked out quite well. It has helped me in constructing complicated search queries, in modifying database tables (without uninstalling and re-installing my application), and in dealing with multi-user/multi-threading issues. I don’t think I would necessarily use this book to start learning about MySQL, but once you are doing hard-core MySQL development, this book would definitely be handy. When I have a MySQL question, I start with this book, as I have found the MySQL Reference Manual at http://dev.mysql.com/doc/refman/5.1/en to be difficult to use.