PEAR :: DB not able to connect

JohnsonKJose

Hi All,
I am geting the following error while running the code

<?php
//set some connection attributes
$username = "root";
$password = "";
$hostname = "localhost";
$database = "taskforward";

//specify which database flavor to use
$dbms = "mysql";

require_once("DB.php");

//create a database link
//$link_id = mysql_connect($hostname, $username, $password) or die(mysql_error());

//connect to the database according to the connect string
$db = DB::connect("$dbms://$username:$password@$hostname/$database");

//select database
//mysql_select_db($database, $link_id);

//assign a sql statement to a variable
$sql = "select fname, password from tf_user";

//return result set to php
//$result = mysql_query($sql, $link_id) or die(mysql_error());
$result = $db->query($sql);

if(!$result) echo "wait no result set";
while($row = $result->fetchRow())
{
	echo "fname is $row[1] <br> password is $row[3] <br><br>";
}

//free the resources available with the result set
//mysql_close();

$db->disconnect();

?>
<HTML>
<HEAD>
<TITLE> New Document </TITLE>

</HEAD>

</BODY>

</HTML>

Error
Warning: main(DB.php): failed to open stream: No such file or directory in g:\web\php\php and database\db\ch02\test1.php on line 11

Fatal error: main(): Failed opening required 'DB.php' (include_path='.;c:\php4\pear') in g:\web\php\php and database\db\ch02\test1.php on line 11

But I can run the same code with out using PEAR :: DB like
<?php
//set some connection attributes
$username = "root";
$password = "";
$hostname = "localhost";
$database = "taskforward";

//create a database link
$link_id = mysql_connect($hostname, $username, $password) or
					 die(mysql_error());

//select database
mysql_select_db($database, $link_id);

//assign a sql statement to a variable
$sql = "select fname, password from tf_user";

//return result set to php
$result = mysql_query($sql, $link_id) or
					 die(mysql_error());

if(!$result) echo "wait no result set";
while(list($fname, $password) = mysql_fetch_row($result))
{
	echo "fname is $fname <br> password is $password <br><br>";
}

//free the resources available with the result set
mysql_close();

?>
<HTML>
<HEAD>
<TITLE> New Document </TITLE>

</HEAD>

</BODY>

</HTML>

can some one please tell me where I am going wrong?

Thanks in advance
Regards

Johnson

cl_stef

It seems that the error comes from the "require_once" function.

Warning: main(DB.php): failed to open stream: No such file or directory in g:\web\php\php and database\db\ch02\test1.php on line 11

It means that the PHP engine can't find the file required, you should check the location of "DB.php" and ensure that all the path are correctly specified.

You can also try to give a full link to your file as parameter by using the following syntax:

require getenv("DOCUMENT_ROOT")."/path/to/include/file.php";

The filename without the path may not be enough in your case, especially if DB.php doesn't exist in the same directory as test1.php.

I hope this helps...

JohnsonKJose

Hi,
In fact I made a search for the DB.php file in my computer but I couldn't locate the same.
Is it required that I have to separately download the DB.php file?
I have installed PHP in my H:\PHP directory and I have also the following directory H:\php-4.3.3-Win32\PEAR

My document root is G:\web\php

Can you please tell me how to go about?
Thanks in advance

Regards
Johnson

enterume

I think the problem is from the include_path in yoru php.ini.

currenlty it is define with

include_path='.;c:\php4\pear'

where your pear directory is at H:\php-4.3.3-Win32\PEAR . You need to point it to the path where php install, and the location of the PEAR folder.

hope it help. thanks.

cl_stef

If you don't want any trouble dealing with php.ini and all that, you can download the easyphp free software, it will set up a full working PHP/mysql solution in no time.

Think about it... Concerning your problem there is something I don't understand (maybe due to the fact that english isn't my main language).. Does that DB.php really exists somewhere on your hard disk?

anyhow, if all that you need is creating a link to your mysql database, there is a very very simple piece of code I can show you.

JohnsonKJose

Hi Friends,

Sorry for the delay. Still I am not able to run the php file.
I have made the following changes in the in the
include_path='.; H:\php-4.3.3-Win32\PEAR ' in the php.ini file.
Still I am getting the following error
Warning: main(DB.php): failed to open stream: No such file or directory in g:\web\php\php and database\db\ch02\test1.php on line 11

Fatal error: main(): Failed opening required 'DB.php' (include_path='.;c:\php4\pear') in g:\web\php\php and database\db\ch02\test1.php on line 11

I have made a search in my hard disk for the DB.php file, but I am not able to locate this file. Then I have checked inside the H:\php-4.3.3-Win32\PEAR\ directory which contain one sub directory ‘go-pear-bundle’ like H:\php-4.3.3-Win32\PEAR\go-pear-bundle. In that sub directory I have the following files
DB-1.5.0RC1.TGZ file (65kb),
PEAR.php file
Tar file ......etc.

I don’t know from where I will get the DB.php file to run this code?
Can some one please help?.

Thanks in advance
Regards
Johnson

enterume

Hi Johnson,

you should look into the directroy where you install the PHP. I am not familiar with window PHP installation, but in linux, every install of PHP, it will have PEAR located at the PHP library.

Thanks
Louis

JohnsonKJose

Hi Friends,

Thanks a lot.
At last I am able to manage the issue.
I have to run one batch file 'go-pear' in my H:\php-4.3.3-Win32 directory. That will set all the required pear directories.

Once again thanks for all your support and help

Regards
Johnson