note 51807 added to function.mysql-connect
| From: | fox at osu1 dot php dot net | Date: | Mon, 11 Apr 2005 20:33:08 +0000 |
| Subject: | note 51807 added to function.mysql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-87860@lists.php.net to get a copy of this message | ||
Can anyone help me.. I m trying to organize search on my database.
Here is the code
<?php
// create short variable names
$searchtype=$HTTP_POST_VARS['searchtype'];
$searchterm=$HTTP_POST_VARS['searchterm'];
$searchterm= trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo 'You have not entered search details. Please go back and try again.';
exit;
}
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
@ $db = mysql_pconnect('localhost', 'bookorama', 'bookorama123');
if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
mysql_select_db('books');
$query = "select * from books where ".$searchtype." like
'%".$searchterm."%'";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
echo '<p>Number of books found: '.$num_results.'</p>';
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
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>';
}
?>
and i ve no idea why, php can't connect to mysql database??
can anyone help me,, please write to mrfox-ilja@yandex.ru
----
Manual Page -- http://www.php.net/manual/en/function.mysql-connect.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+51807
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+51807&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+51807&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+51807&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+51807&report=yes&reason=useless
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+51807&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+51807&report=yes
Search -- http://master.php.net/manage/user-notes.php