Bug #13232 Updated: PEAR messes up with simultaneous connections.

ID: 13232 Updated by: mj Reported By: fidian@commnav.com Status: Feedback Bug Type: PEAR related Operating System: Linux 2.2.16 PHP Version: 4.0.6 New Comment: Two additional points: 1.: What DBMS do you use? (I tested with MySQL and it worked) 2.: Of course you have to change the line echo "Result: " . $count[0] . "\n"; into echo "Result: " . $data[0] . "\n"; to make your example work. Previous Comments: ------------------------------------------------------------------------ [2001-10-09 15:44:09] mj@php.net Your example works for me. Please try with the latest CVS version of DB.php ------------------------------------------------------------------------ [2001-10-09 13:58:11] sander@php.net Reclassified. ------------------------------------------------------------------------ [2001-09-10 10:30:19] fidian@commnav.com PEAR seems to not be able to handle multiple connections to different databases. To illustrate, create two tables in different databases (can be on the same server, but different databases within that server). include("DB.php"); $oneWrapper = new DB(); $oneDB = $oneWrapper->connect("type://user:pass@server/one"); printRes($oneDB->query("select count(*) from table_one")); $twoWrapper = new DB(); $twoDB = $twoWrapper->connect("type://user:pass@server/two"); printRes($twoDB->query("select count(*) from table_two")); printRes($oneDB->query("select count(*) from table_one")); printRes($oneDB->query("select count(*) from table_two")); function printRes($res) { if (DB::isError($res)) { echo "Error: " . DB::errorMessage($res) . "\n"; } else { $data = $res->fetchRow(); echo "Result: " . $count[0] . "\n"; } } This code will print out Result: 0 Result: 0 Error: no such table Result: 0 Looking back at the code, you will see that $oneDB is now pointing at the $twoDB's database instead of its correct one. ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=13232&edit=1