This book on phpMyAdmin is written by Marc Delisle, one of the core developers of the application which I think just about any software developer utilising MySQL has dabbled with at the least. I can honestly say that anyone that experimented with phpMyAdmin before reading this book will use it much more thoroughly and more productively afterwards.

He includes an overall opinion of the book as well as a specific chapter - the one covering MySQL 5 additions - and his total enjoyment with the contents of the book.

Recently at work, I was tasked with finding a method to retrieve data from a third-party SQL Server 2000-based system into our own MySQL-based application. It's worth noting that both system are behind their own firewalls and I was trying to bear security in mind as I did this.

Some highlights of his work included using GoToAssist to get to the system, using EMS SQL Manager to work with the SQL server itself and some of the PHP code he "threw at it" to grab the info he needed from the database (with the PDO drivers).

Are you looking to work on cutting edge technologies? Are you a great PHP/MySQL coder that can pick up new ways of doing things and new languages quickly? Are you looking for an opportunity to be a major part of one of the most talented teams in the world?

Internet Marketing Firm IntegraClick, Inc., and its subsidiary, Clickbooth.com, are seeking highly motivated, intelligent, and trustworthy employees to whom we can extend excellent career growth opportunities at our Miami and Sarasota locations. We are firmly established as a leader in our industry and have been extremely profitable for over 5 years. If you are looking for a San Francisco or New York pace, this is the place for you.

Qualifications

• PHP 4.0/5.0 (4+ years experience)
• MySQL 4.x/5.x (3+ years experience in development - extra weight given to candidates with administrative experience)
• Javascript (4+ years experience)
• HTML/DHTML/XHTML (4+ years experience)
• XML
• AJAX
• Web services - SOAP, XMLRPC
• HTTP, SMTP protocol knowledge a plus

Expertise in coding, analyzing, and troubleshooting large-scale distributed/redundant advertising systems a plus.

Additionally, the right candidate will possess

• A strong sense of ownership, urgency, and drive.
• A strong ability to adapt and problem solve.
• Proven technical troubleshooting and performance tuning experience.

Required Education
BS in Computer Science, Software Engineering or similar degree preferred but similar relevant experience acceptable

Contact Delia Arteaga-Bussalleu for more information: Delia@clickbooth.com

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.

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).

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.

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.

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

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!