《PHP MySQL和WEB开发》笔记第十一章

<?//fopen("search.html",'a');echo "<a href=\"search.php\">Enter The Search Web.";//fopen("search_result.php",'w');//get_magic_quotes_gpc魔术引擎是否开启?>

这是search.php

<?require("page.inc");$searcher=new page();$searcher->content="<font size=\"+5\">Book-O-Rama Catalog Search</font><br />  <form action=\"search_result.php\" method=\"post\">  Choose Search Type<br />  <select name=\"search_type\">  <option value=\"Author\">Author</option><br />  <option value=\"Title\">Title</option><br />  <option value=\"ISBN\">ISBN</option><br />  </select><br />  Enter search Term:<br />  <input name=\"searchterm\" type=\"text\" size=\"40\" /><br />  <input name=\"submit\" value=\"Search\" type=\"submit\">  </form>";$searcher->display();?>

page.inc里面改一句话

public $button=array("home"=>"home.php", "contact"=>"contact.php", "service"=>"services.php", "sitemap"=>"sitemap.php", "news"=>"news.php", "search"=>"search.php");

这是search_reasult.php的页面

<?require("page.inc");$search_result=new page();$search_type=$_POST['search_type'];$searchterm=$_POST['searchterm'];$content="";if(!get_magic_quotes_gpc()){$searchterm=addslashes($searchterm);$search_type=addslashes($search_type);}if($searchterm==''){$search_result->content="Please Input The Search Iterm";$search_result->display();return;}@$con=new mysqli('localhost','lustudy_web','123456','lustudy');if(mysqli_connect_error()){$content= "ERROR:Can not connect database.Please Try Again Later";exit;}$sqlstr="select * from books where ".$search_type." like '%".$searchterm."%'";$web_reasult=$con->query($sqlstr);$reasult_num=$web_reasult->num_rows;$content.= "Number of books found : ".$reasult_num."<br /><br />";//if($reasult_num==0){exit;}for($i=0;$i<$reasult_num;$i++){//什么时候用逗号什么时候用分号来着$row=$web_reasult->fetch_assoc();$content.= ($i+1)." Title: ".$row['title']."<br />Athor : ".$row['author']."<br />ISBN : ".$row['isbn']."<br />Price : ".$row['price']."<br /><br />";}$content.="<a href=\"search.php\"><font color=\"#330000\">返回</font></a><br /><br />";$web_reasult->free();$con->close();$search_result->content=$content;$search_result->display();/*11.4绑定参数插入数据 prepared方法*/  require("database.inc");  $con=new mysqli($lu_host,$lu_user,$lu_psw,$lu_db);  //use prepared insert (bind_param)$isbn='1-111-11111-7';  $author='wenbo'; $title='how to kill you';  $price=71;$str2="insert into books values (?,?,?,?)"; //use ? to replace the param $result_check=$con->query("select * from books where isbn='".$isbn."'"); if($result_check->num_rows != 0){echo "The Book is exist.<br />";} //check if the record is exist.else{$result2=$con->prepare($str2);  $result2->bind_param("sssd",$isbn,$author,$title,$price);  $result2->execute(); echo $result2->affected_rows.'book inserted into database';  }//use prepared to select(bind_result)//1.select string$selectstr="select isbn,title,author,price from books";//2.prepare select$result3=$con->prepare($selectstr);//3.bind result$result3->bind_result($isbn2,$title2,$author2,$price2);//4.excute the select$result3->execute();//5.echo the result use whilewhile($result3->fetch()){echo "ISBN:$isbn2 <br />";echo "Title:$title2 <br />";echo "Author:$author2 <br />";echo "Price:$price2 <br /><br />";}//it has a problem Price:30.239999771118 should be 30.24,dont know why//i should use decimal.http://blog.csdn.net/howroad/article/details/78202832/*11.5使用php与数据库交互的其他借口*/ //下载pear  http://pear.php.net/go-pear.phar//require_once("Mail.php");//因为pear 安装一直失败，所以暂时不研究这一篇了……?>

应用十一章的mysql思想自己做了一个网站，相关的信息都在下一篇文章里。
http://blog.csdn.net/howroad/article/details/78134194