Stuart Herbert has posted his review of a book from Packt Publishing covering one of the most popular PHP-based database administration packages out there, phpMyAdmin, "Mastering phpMyAdmin 2.11 for Effective MySQL Management".

Mastering phpMyAdmin 2.11 for Effective MySQL Management by Marc Delisle is the third edition of this book, and it follows the usual pattern of Packt Publishing books. The book has clearly defined objectives on the cover, and it follows a clear progression of its chosen subject from start to end. It is well presented, with a clear layout and clean page design that makes it easy to read.

Stuart gives a high-level overview of both phpMyAdmin ("it feels like phpMyAdmin as been around forever") and the book with an index of the topics covered.

In a new post today, Martynas Jusevicius shows how to combine a little SQL magic with the Propel framework to fins the distance between two places:

Eventually the simple distance formula that I have blogged about turned out to be too inaccurate, even for locations within city bounds. I needed to use a formula to calculate great-circle distance which takes into account that the Earth is a sphere.

He includes the SQL to pull the data in the right format and the PHP code (using Propel) to reproduce it without having to write it by hand (complete with the bind variables to help with security and consistency).

DevShed has posted the second article in their series looking at benchmarking your PHP scripts. This time they look at the use of "timers" to check on script execution length.

Since you already know how to create timer functions and classes, in this tutorial, I'll create some concrete examples that show where these timing mechanisms can be applied in order to evaluate the performance of certain PHP applications.

They create a few classes that connect to a database and pull out rows (handing it off to a Result class). They use these classes in two examples - one with compression (output buffering) and one without using their Timer class to evaluate the differences.

Kae Verens has posted a new book review of one of Packt Publising's latest PHP-related offerings, "Mastering phpMyAdmin 2.11 for Effective MySQL Management":

In short, my review is this: overall, the book detailed everything I can think of (and more) about phpMyAdmin - I learned about some features in phpMyAdmin that I was not already aware of. I would ask for less screenshots, more how-tos and less 3rd-person speech for the next revision, but if there are any questions I have about phpMyAdmin, the answer is in this book.

The review gets into more detail about the book - its structure, the wealth of content in it (including some unknown features) and a few things that could have been better. Kae mentions a few places where the author "forgets that the reader does not know the subject" and gets a bit too technical too fast. The screenshots, while good in moderation, overpowered parts of the chapters and made them harder to follow.

code:diesl has posted their list of the top six books that can help you master the PHP language:

If you are new to PHP or are thinking of moving to PHP form other language then the following list of books will provide you with the required knowledge to become a seasoned PHP programmer. Of course, the list is subjective and you may have a different list of books in mind.

Their list is made up of:

• Zend PHP5 Certification
• PHP in Action
• PHP and MySQL Web Development
• PEAR
• PHP Cookbook
• SQL for MySQL Developers

On the Builder.com.au site today, there's an introduction posted to walk you through one of the most popular web-based database administration tools for PHP/MySQL on the web, phpMyAdmin.

phpMyAdmin is a HTML interface developed in PHP, for creating and managing MySQL databases. Before you download and install the latest version, have a look at the requirements section on the phpMyAdmin Wiki.

They look at the overall interface, how to set up users, making a new database, creating a table inside of it, pushing data into the table and the various options that the tool has to help you manage your database(s) - all with nice big screenshots to show you where it all is.

The Internet Super Hero blog has posted about a preview release of the PDO_MYSQLND and a connector for MySQL to Open Office that have both been announced at this year's MySQL Conference.

The post explains what each of the technologies are for and where they fit in most development. The PDO_MYSQLND functionality is a direct connection for the PDO libraries to connect to MySQL using the native driver.

PDO_MYSQLND inherits all benefits of the MySQL native driver for PHP. In addition to the shared advantages you get the first PDO driver for MySQL developed by Sun/MySQL!

On his blog today, Stefan Mischook has posted a new video tutorial showing how to hook together one of the more popular web development combinations on the internet - PHP and MySQL.

I've gotten around to releasing a new set of beginners video tutorials on PHP. This time around, I have a four part video on how to get PHP to talk to MySQL.

All four parts are there, bundled into a Flash presentation. Note: these are not installation tutorials - they only show how to get PHP talking to the MySQL backend, not how to set them up together.

A little while back Matthew Turland posted an interesting item to has blog talking about what he calls the "odd triangle" of PHP, MySQL and Oracle.

In [an article from Maggie Nelson in a blog entry], she remarks on the article being MySQL-oriented and how limited MySQL explain plan support is compared to Oracle. I've had some thoughts in my head for a while that are related to these points, so I finally decided to, knock on wood, put pen to paper.

Matthew talks about things he agrees with (Oracle over MySQL when it comes to hierarchal data and set operators) and some of the things that can make Oracle, with all its power, fall by the wayside. This includes its licensing, the administration costs and some of the recent developments between Sun and MySQL.