PHP语句.doc

html head titleBook_o_Rama Catalog Search/title /head body h1Book_O_Rama Catalog Search/h1 form action=results.php method=post Choose Search Type:br / select name=searchtype option value=authorAuthor/option option value=titleTitle/option option value=ISBNISBN/option /select br / Enter Search Term:br / input nwme=searchterm type=text br / input type=submit value=search /form /body /html html head titleBook_o_Rama Search Results/title /head body h1Book_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.; } if (!get_magic_quotes_gpc()) { $searchtype=addslashes($searchtype); $searchterm=addslashes($searchterm); } @ $db = new mysqli(localhost,bookorama,bookorama123, book_o_rama ); if (mysqli_connect_errno()) { echo ERROR: Could not connect to database.Please try and later.; exit; } $query = select * from books where .$searchtype.like %.$seachterm.% ; $results = $db-query($query); $num_results = $result-num_rows; echopNumber of books found: .$num_results./p; for($i=0;$i $num_results; $i++) { $row = $result-fetch_assoc(); echo pstrong.($i+1)..Title:; echo htmlsprcialchars(stripslashes($row[title])); echo /strongbr /Author; ; echo scripslashes($row[author]); echo br /ISBN: ; echo scripslashes($row[ISBN]); echo br /Price: ; echo scripslashes($row[price]); echo /p; } $result-free(); $db-close(); ? /body /html html head titleBook_o_Rama Book Entry Results/title /head body h1Book_o_Rama Book Entry /h1 form action=insert_book.php method=post table border=0 tr tdISBN/td tdinput type=text name=isbn maxlength=13 size=13/td /tr tr tdAuthor/td tdinput type=text name=author maxlength=30 size=30/td /tr tr tdTitle/td tdinput type=text name=title maxlength=60 size=30/td /tr tr tdPrice $/td tdi