الفصل الخامس
قواعد البيانات
<option value="title">Title
<option value="isbn">ISBN
</select>
<br>
Enter Search Term:<br>
<input name="searchterm" type=text> <br>
<input type=submit value="Search"> </form>
<h1> Book Search Results </h1>
<?
if (!$searchtype || !$searchterm)
{
}
echo "You have not entered details. Try again."; exit;
$searchtype = addslashes($searchtype); $searchterm = addslashes($searchterm);
@ $db = mysql_pconnect("localhost", "root", ""); if (!$db)
{
echo "Error: Not connected. Try later.";
exit; }
mysql_select_db("books");
$query
=
"select * from books where ".$searchtype." like
"%".$searchterm."%"";
$result = mysql_query($query);
192
ص ١٩٤