Query a db with Pear

[1cookie]

hi

I'm trying to run a script that makes use of Pear. You may see the code from the screen shot attached. I have a problem with my Pear configuration. When I run the script via Apache I get: Fatal error: Class 'DB' not found in C:\Program Files[. Are there any Pear experts out there?? Ive had a look at the http://pear.php.net/ manual but am finding it inpenetrable.

[NogDog]

Assuming that the correct DB.php file is loaded by your require statement, that error message does not make much sense. You might want to try requiring it via its full path name in case another file in the include_path is being loaded instead.

[1cookie]

Assuming that the correct DB.php file is loaded by your require statement, that error message does not make much sense. You might want to try requiring it via its full path name in case another file in the include_path is being loaded instead.

hi NogDog

The DB.php is in the same directory as the script?. My php.ini includes path is attached in a screenshot; is this ok?.

[1cookie]

If I replace the variables with the appropriate constansts, then I still get the same error!

i.e.

$host="localhost";
$user="root";
$passwd="*****";
$database="library";

[NogDog]

The error is telling you that no class named "DB" has been defined when you try to use it. Presumably it should have been defined by that require statement, so at this point I really don't know why that should be based on the evidence provided so far.

[1cookie]

The error is telling you that no class named "DB" has been defined when you try to use it. Presumably it should have been defined by that require statement, so at this point I really don't know why that should be based on the evidence provided so far.

looks like that's my 'Pear' experience cut short then..

[NogDog]

Probably there's some "silly" error here that I'm just not seeing in the supplied code. You might want to try something really basic to see if anything obvious jumps out:

<?php
<?php
ini_set('dipslay_errors', 1);
error_reporting(E_ALL);
require_once 'DB.php';
$db = new DB();
echo "<pre>".print_r($db, 1)."</pre>";

It should display something like the following if it works:

DB Object
(
)

[1cookie]

Probably there's some "silly" error here that I'm just not seeing in the supplied code. You might want to try something really basic to see if anything obvious jumps out:

<?php
<?php
ini_set('dipslay_errors', 1);
error_reporting(E_ALL);
require_once 'DB.php';
$db = new DB();
echo "<pre>".print_r($db, 1)."</pre>";

It should display something like the following if it works:

DB Object
(
)

...hmm, that's interesting, upon testing this code my browser displays:

Fatal error: Class 'DB' not found in C:\Program Files

[NogDog]

Try changing the require statement to the following, just in case it's an include_path issue:

require_once "./DB.php"; 

(This assumes that as you mentioned above, the desired DB.php file is in the same directory as your test script.)

[1cookie]

Try changing the require statement to the following, just in case it's an include_path issue:

require_once "./DB.php"; 

(This assumes that as you mentioned above, the desired DB.php file is in the same directory as your test script.)

Well, I think we can deduce it's not an include path issue. I run the script with the changes and get the exact same error.

[NogDog]

Only other thing I can think of is that there's something wrong with the DB.php file itself. I did a local install of the PEAR DB package on my PC and the same test script runs fine.

[1cookie]

Only other thing I can think of is that there's something wrong with the DB.php file itself. I did a local install of the PEAR DB package on my PC and the same test script runs fine.

...oh, the DB.php file is:

<?php
$host="localhost";
$user="root";
$passwd="password";
$database="library";
?>

which is in the same directory..

I think i'm going to have to look at the DB installation further. Hey, thanks for all your help NogDog, I appreciate your'e help.

[NogDog]

That is definitely not the PEAR DB script. The version I have is about 1490 lines long.

[1cookie]

I run the go-pear.bat batch file, see screen shot please. Can you deduce anything from this??

[1cookie]

That is definitely not the PEAR DB script. The version I have is about 1490 lines long.

ah, turns out I have a misunderstanding with just exactly what DB.php consists of.. I'm reading from a book, and it's like, hopeless...

Question, DB.php DOES come bundled with my php installation?