Page 1 of 1

need help, big time with php and mysql connection!

Posted: Sun May 03, 2009 12:48 am
by freesoul
Hi all,

I am new to php and trying to learn from scratch. I installed everything using Xampp. I have been following this book ('Learning php and mysql by O Reilly,2nd edition') but got stuck at this stage where am unable to query the Database with PHP Functions. I got everything right but when i view the file db_test.php file in browser i get nothing but the following code:

Code: Select all

 
// Include our login information
include('db_login.php');
// Connect
$connection = mysql_connect($db_host, $db_username, $db_password);
if (!$connection){
die ("Could not connect to the database: <br />". mysql_error( ));
}
 
The above code is part of my db_test.php file which is saved in htdocs folder. The file has the following codes:

Code: Select all

 
<?php
// Include our login information
include('db_login.php');
// Connect
$connection = mysql_connect($db_host, $db_username, $db_password);
if (!$connection){
die ("Could not connect to the database: <br />". mysql_error( ));
}
// Select the database
$db_select=mysql_select_db($db_database);
if (!$db_select){
die ("Could not select the database: <br />". mysql_error( ));
}
// Assign the query
$query = "SELECT * FROM books NATURAL JOIN authors";
// Execute the query
$result = mysql_query( $query );
if (!$result){
die ("Could not query the database: <br />". mysql_error( ));
}
// Fetch and display the results
while ($result_row = mysql_fetch_row(($result))){
echo 'Title: '.$result_row[1] . '<br />';
echo 'Author: '.$result_row[4] . '<br /> ';
echo 'Pages: '.$result_row[2] . '<br /><br />';
}
//Close the connection
mysql_close($connection);
?>
 
I have checked everything and followed it all right and now cannot make any clue where am I going wrong or is the file saved in the wrong directory or something else :( . Please help or give some hint for further troubleshooting!

Re: need help, big time with php and mysql connection!

Posted: Sun May 03, 2009 9:23 am
by freesoul
I uninstalled and reinstalled xampp and dreamweaver from scratch and got everything displayed this time from my database without ne error. Still got no clue why the issue came up last time. Will hv to give some thot on this. :)