Help with database book example...
Posted: Wed Aug 31, 2005 1:52 pm
Hello folks new to PHP and this forums. Thanks for any help on this.
I'm reading a book called "PHP and MySQL Web Development", and I'm stuck on an example that doesn't not seem to work... on my machine or on an F2O.org free account. Here is the code:
It prints out the <h1>Book-O-Rama Search Results</h1>, and then it doesn't seems to spit anything else back... not even the closing body or html tags. Can anyone help me on this? This might have something to do with another issue I had here: viewtopic.php?t=37583
I'm reading a book called "PHP and MySQL Web Development", and I'm stuck on an example that doesn't not seem to work... on my machine or on an F2O.org free account. Here is the code:
Code: Select all
<html>
<head>
<title>Book-O-Rama Search Results</title>
</head>
<body>
<h1>Book-O-Rama Search Results</h1>
<?php
// create short variable names
$searchtype=$_POST['searchtype'];
$searchterm=$_POST['searchterm'];
$searchterm= trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo 'You have not entered search details. Please go back and try again.';
echo '</body></html>';
exit;
}
if (!get_magic_quotes_gpc())
{
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
}
@ $db = new mysqli('localhost', 'bookorama', 'bookorama123', 'books');
if (mysqli_connect_errno())
{
echo 'Error: Could not connect to database. Please try again later.';
echo '</body></html>';
exit;
}
$query = "select * from books where ".$searchtype." like '%".$searchterm."%'";
$result = $db->query($query);
$num_results = $result->num_rows;
echo '<p>Number of books found: '.$num_results.'</p>';
for ($i=0; $i <$num_results; $i++)
{
$row = $result->fetch_assoc();
echo '<p><strong>'.($i+1).'. Title: ';
echo htmlspecialchars(stripslashes($row['title']));
echo '</strong><br />Author: ';
echo stripslashes($row['author']);
echo '<br />ISBN: ';
echo stripslashes($row['isbn']);
echo '<br />Price: ';
echo stripslashes($row['price']);
echo '</p>';
}
$result->free();
$db->close();
?>
</body>
</html>