need help, big time with php and mysql connection!
Posted: Sun May 03, 2009 12:48 am
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:
The above code is part of my db_test.php file which is saved in htdocs folder. The file has the following codes:
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!
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( ));
}
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);
?>