Category Archives: MySQL

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 | 7 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 | 13 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 | 35 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

Changes in phpMyAdmin 3.0

phpMyAdmin, the popular front-end to the MySQL database, has issued the first stable release of the version 3.0 series. The basic functionality remains unchanged, but there are some important differences. To begin with, phpMyAdmin 3.0 requires a minimum of PHP … Continue reading

Posted in Books, MySQL, phpMyAdmin | 44 Comments

Adobe releases PHP hotfix for Dreamweaver 8.0.2

At long last, Adobe has released a hotfix for a number of serious issues affecting the PHP MySQL server model in Dreamweaver 8.0.2. Unfortunately, you can’t just go to the Adobe site and download it. You need to contact Adobe … Continue reading

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

DATE_FORMAT() problem was with my data, not 8.0.2 updater

When the Dreamweaver 8.0.2 updater came out, I originally reported that it mishandles the MySQL DATE_FORMAT() function in the Test SQL Statement panel. After further testing, and some help from Alexandru Costin of InterAKT, I’ve discovered the problem was with … Continue reading

Posted in Dreamweaver, MySQL | 4 Comments