Replacement for PEAR: MDB2 on PHP 5.3

php mysql pear mdb2
mattweg picture mattweg · Oct 7, 2009 · Viewed 12k times · Source

I've been using pear packages in php for years. I'm in the process of upgrading/moving a sites that uses the MDB2 pear package and it has not been updated for PHP 5.3.X.

In 5.3, MDB2 is returning those new annoying errors.

Unknown: Assigning the return value of new by reference is deprecated in /usr/local/lib/php/MDB2.php on line 390

I know I can change my error reporting settings to get rid of them, but I'd rather not make any exceptions. Anyway, Is anyone else using MDB2 these days and have a solution? Are there similar database packages you recommend?

Answer

Pascal MARTIN picture Pascal MARTIN · Oct 7, 2009

I would definitly go for an ORM, at least if you are working on a big project, for which you don't want to use mysqli_* or PDO functions/methods directly -- Doctrine being the most developped/used, nowadays (It's the default ORM of the symfony Framework, and can be integrated in Zend Framework quite easily).

About the E_DEPRECATED errors, though : PHP 5.3 is quite young, and lots of libraries/software/projects have not been adapted yet -- you'll probably have lots of those in the next couple of months :-(

Related questions

Call to undefined method MDB2_Error::setFetchMode()

I am using PEAR's MDB2 to connect to my MySQL DB's. I have never had a problem before but this particular host is causing me problems. At first I thought it was the user credentials but I have tested on …

Read More
Select all fields where fieldone is not equal to null + Propel

I have a question about using the propel ORM and creating a query. I have a table "locations" with fields: location sublocation postcode street number Now I want to select all the locations where the location field IS NOT equal …

Read More
Pear DB class not found

I have create a class called Database.php for interacting with MySql database using Pear Db class. Database.php <?php require_once('DB.php'); require_once('cException.php'); class DataBase { private $dsn = 'mysql://root:xxxxxx@localhost/avatar'; private $conn; //…

Read More