Connecting to Mysql Using Pear DB

[rgraves]

Hi,

I'm new to using PEAR and I'm trying to connect to a mysql database using it's DB package.

Here's the code I have:

require '/usr/local/lib/php/DB.php';
$dbh = DB::connect('mysql://myusername:mypassword@localhost/mydb');
print "Connected to 'mydb'";

It seems to load the DB.php file properly because if I comment out line 2, it displays line 3 without any errors. However, when I try to connect to mysql, the page is blank. No errors, nothing.

Any ideas?

[Roger_Ramjet]

What version of mysql is it: from the manual

mysql -> MySQL (for MySQL <= 4.0)
mysqli -> MySQL (for MySQL >= 4.1) (requires PHP 5) (since DB 1.6.3)

[rgraves]

I'm using Mysql version 3.23.49

[rgraves]

The problem seems to be having an absolute path to the DB.php file. I originally had require ('/usr/local/lib/php/DB.php') and that wasn't working. I didn't think it was a big issue.

I changed it to:

ini_set('include_path', '/usr/local/lib/php/');
require 'DB.php';

and it worked. I'll get our sysadmin to update the include_path variable.