Pear DB, undefined class name 'db'

Hephaistos

What am I doing wrong? Or is there something wrong with PEAR:😃B?

I get the following error

Fatal error: Undefined class name 'db' in .\htdocs\test\db2.php on line 9

This is the code i used.

<?php

include('dbinfo.php');
require_once( 'DB.php' );
$db = DB::connect( "mysql://$dbuser:$dbpass@$dbhost/$dbname" );
$sql = 'SELECT * FROM demo';
$demoResult = $db->query($sql);
while ($demoRow = $demoResult->fetchRow()) {
    echo $demoRow[2] . '<br>';
}
$db->disconnect();

?>

The code is from the following article

http://www.phpbuilder.com/columns/allan20010115.php3

Any help will be greatly appreciated

eoghain

Have you got PEAR DB installed?

If so where is it installed?

Is this directory in your include path in php.ini?

Standard PEAR install installs the PEAR data in separate directories under a directory (i.e. /usr/lib/pear) and puts that directory in you include path in php.ini. Then to access the pieces of PEAR you need to do:

include ("DB/DB.php");

Hephaistos

I have php/mysql installed on my windows laptop. When I look at my phpinfo() page I can see that I have succesfully included PEAR

Looks like this:
include_path .;C:\php\PEAR .;C:\php\PEAR

I used the go-pear bat file that came with PHP to install PEAR and I saw a lot of succesfully installed messages. I think that means it has been succesfully installed right?

In the directory c:\php\PEAR i can see DB.php, PEAR.php and some other files.

BTW

this is the resulting web page that i get

Record number 1
Record number 2
Record number 3
Record number 4
Record number 5

Fatal error: Undefined class name 'db' in C:\Program Files\Apache Group\Apache2\htdocs\test\db2.php on line 9

So it seems to be working to at least some level

Hephaistos

Never mind. The problem was that I "accidentally" put a file in the same dir on de webserver named db.php. So of course in stead of opening DB.php from the PEAR directory the db.php file on the webserver was opened.

Beginners mistake. I know I am a newbie 🙂