Category Archives: MySQL

Enabling advanced features in phpMyAdmin

A subscriber to was watching my Up and Running with phpMyAdmin course, and was¬†puzzled by the absence of three fields in his version of phpMyAdmin when defining a table. The three fields are Mime types, Browser transformation, and Transformation … Continue reading

Posted in phpMyAdmin | 2 Comments

Two PHP courses just published on

I’m delighted to announce that has just published two new PHP courses that I created recently. The first one, PHP for Web Designers, serves as a gentle introduction to PHP, and is aimed primarily at web designers who have … Continue reading

Posted in PHP, phpMyAdmin, Video | 4 Comments

Source files for PHP Solutions

Several people have written asking what has happened to the friends of ED website because they can’t find the source files for PHP Solutions, 2nd Edition. The site was merged with that of its parent company, Apress, a long time … Continue reading

Posted in Books, MySQL, PHP | 44 Comments

Using num_rows with a MySQLi prepared statement

While refactoring some code that I had written about six years ago, I was puzzled by the MySQLi num_rows property constantly returning 0, even though I knew there were matching records in the database. It turns out that the problem … Continue reading

Posted in MySQL, PHP | 9 Comments

Join others learning PHP with PHP Solutions

So far, more than 90 people have signed up to join a self-study group organized by Boston PHP to learn PHP with the help of my book, PHP Solutions: Dynamic Web Design Made Easy, 2nd Edition. This is the third … Continue reading

Posted in Books, MySQL, PHP | 15 Comments

PHP Solutions second edition now available

It’s almost exactly four years since PHP Solutions: Dynamic Web Design Made Easy was first published. The book has proved extremely popular, but a lot has happened in PHP since it was first published. Support for PHP 4 was abandoned … Continue reading

Posted in Books, MySQL, PHP, phpMyAdmin | 57 Comments

DW CS5 with PHP book on Rough Cuts

If you would like to get early access to my next book “Adobe Dreamweaver CS5 with PHP: Training from the Source”, the first six chapters (of 12) are now available as Rough Cuts in Creative Edge and Safari Books Online. … Continue reading

Posted in Books, Dreamweaver, MySQL, PHP | 37 Comments

New tutorials and articles

I have just added to my site a tutorial on converting a Spry Menu Bar into a server-side include. I have also been busy adding a bunch of brief articles to the Dreamweaver Cookbook on the Adobe site. I answer … Continue reading

Posted in AJAX/JavaScript, Dreamweaver, MySQL, PHP | 22 Comments

New setup procedure for phpMyAdmin 3.1.x

I seem to be jinxed with the way phpMyAdmin “celebrates” the publication of one of my books by changing its setup process. It happened twice with Foundation PHP for Dreamweaver 8. I updated the instructions between the first and second … Continue reading

Posted in Books, Dreamweaver, PHP, phpMyAdmin | 20 Comments

Problem with PHP 5.2.7

PHP 5.2.7, which was released last Thursday (4 December), has a bug that prevents “magic quotes” from working. If you rely on magic quotes, do not install PHP 5.2.7. Either revert to PHP 5.2.6 or wait until a fix is … Continue reading

Posted in MySQL, PHP | 9 Comments