代碼基本沒有改動，函數有變化，老師只用了一個函數，自己做寫了4個function，減少了代碼量
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>無標題文檔</title> </head><body> <form action="zufang.php" method="post"> <div>區域：<input type="checkbox" id="qy" οnclick="CheckAll(this,qy)" />全選</div> <?php include("./ChaXun.class.php"); $db=new ChaXun(); $sql="select distinct Area from House"; $attr=$db->Query($sql); //var_dump($attr); foreach($attr as $v) {echo"<input type='checkbox' class='qy' name='qy[]' value='{$v[0]}'/>{$v[0]}"; } ?> <br /> <br /> <div>租賃類型：<input type="checkbox" id="zulin" οnclick="CheckAll(this,zulin)" />全選</div> <?php $sqlzu="select distinct RentType from House"; $attrzu=$db->Query($sqlzu); //var_dump($attrzu); foreach($attrzu as $vzu) {echo"<input type='checkbox' class='zulin' value='{$vzu[0]}' name='zulin[]'/>{$vzu[0]}"; }?> <br /> <br /> <div>房屋類型：<input type="checkbox" id="fangwu" οnclick="CheckAll(this,fangwu)" />全選</div>
//CheckAll(this,fangwu),this是指該元素，也就是全選的checkbox，
<?php $sqlfw="select distinct HouseType from House"; $attrfw=$db->Query($sqlfw); //var_dump($attrfw); foreach($attrfw as $vfw) {echo"<input type='checkbox' class='fangwu' value='{$vfw[0]}' name='fangwu[]' />{$vfw[0]}"; } ?> <br /> <br /> <div>關鍵字：<input type="text" name="guanjianzi" value="" /></div> <br /><input type="submit" value="搜索" /> <br /> <br /> <table style="width:500px;" cellpadding="0" cellspacing="0" border="1"> <tr> <td>關鍵字</td> <td>區域</td> <td>建筑面積</td> <td>租金</td> <td>租賃類型</td> <td>房屋類型</td> </tr><?php$tj1="1=1";$tj2="1=1";$tj3="1=1";$tj4="1=1";if(!empty($_POST["qy"])){ $attr=$_POST["qy"];$str = implode("','",$attr);$tj1= " Area in ('{$str}')";} if(!empty($_POST["zulin"])) { $attr=$_POST["zulin"];$strzu=implode("','",$attr);$tj2=" RentType in ('{$strzu}')"; } if(!empty($_POST["fangwu"])) { $attr=$_POST["fangwu"];$strfw=implode("','",$attr);$tj3=" HouseType in('{$strfw}')"; }if(!empty($_POST["guanjianzi"])) {$tj4="KeyWord like '%{$_POST['guanjianzi']}%'";$name=$_POST["guanjianzi"];} $ss=" where {$tj1} and {$tj2} and {$tj3} and {$tj4}";//where前面一定要加空格 $sqlall="select * from House".$ss; //var_dump($sqlall); $attrall=$db->Query($sqlall);foreach($attrall as $vall) {echo"<tr> <td>{$vall[1]}</td><td>{$vall[2]}</td><td>{$vall[3]}</td> <td>{$vall[4]}</td> <td>{$vall[5]}</td> <td>{$vall[6]}</td> </tr>";}?> </table></form></body> <script type="text/javascript"> function CheckAll(a,b)//2個參數，a指this，b指類名 {var ckall=a.checked;var ck=document.getElementsByClassName(b);for(var i=0;i<ck.length;i++){ck[i]=ckall;} } </script> </html>
?
標準的視圖應該是這個！
)
