Try placing the following into a .php file,
<?php
// Connecting, selecting database
// enter below your database host, user and pass
$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
// Closing connection
mysql_close($link);
?>
If that fails you either dont have a mysql server or PHP was not
compiled with mysql support, see here for instructions
http://php.net/manual/en/ref.mysql.php
Esteamedpw@xxxxxxx wrote:
Hey guys,
I'm doing a tutorial from a book (PHP and MySQL Web Development) and I'm
having a problem... when I use the script they supply I get this error:
Fatal error: Class 'mysqli' not found in
C:\apachefriends\xampp\htdocs\results.php on line 29
here is the code:
=======================================================
<?php
// create short variable names
$searchtype=$_POST['searchtype'];
$searchtype=$_POST['searchterm'];
$searchterm= trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo 'You have not entered search details. Please go back and try again.';
exit;
}
if (!get_magic_quotes_gpc())
{
$searchtype= addslashes($searchtype);
$searchterm= addslashes($searchterm);
}
$db = new mysqli('localhost', 'root', 'root', 'bookorama');
//$db = mysql_connect('localhost', 'root', 'root'); // tried this way, no
luck
//mysql_select_db("bookorama", $db);
if(mysqli_connect_errno())
{
echo 'Error: Could not connect to the Database. Please try again later.';
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>
===================================================
I updated PHP from 5.0.3 to 5.0.4 to see if it would help, no luck.
Now I'm just completely lost.
Thanks,
Clint
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
