<!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="http://www.w3.org/1999/xhtml"><head><metahttp-equiv="Content-Type"content="text/html;charset=utf-8"/><title>无标题文档</title></head><body><?php$db=newMySQLi("localhost","root","726","housedb");//一共有四个条件$tj1="1=1";$tj2="1=1";$tj3="1=1";$tj4="1=1";//区域的条件if(!empty($_POST["qx"])&&count($_POST["qx"])>0)//判断区域有没有传入数据，qs是一个数组并且它数量大于0{$qx=$_POST["qx"];$str=implode("','",$qx);分隔符返回一个字符串$tj1="areain('{$str}')";}//租赁类型的条件if(!empty($_POST["zl"])&&count($_POST["zl"])>0){$zl=$_POST["zl"];//codein('类型','数量','都好久','队伍','额')$str=implode("','",$zl);$tj2="renttypein('{$str}')";}//房屋类型的条件if(!empty($_POST["fw"])&&count($_POST["fw"])>0){$fw=$_POST["fw"];//codein('类型','数量','都好久','队伍','额')$str=implode("','",$fw);$tj3="housetypein('{$str}')";}//关键字的条件if(!empty($_POST["key"])){$key=$_POST["key"];$tj4="keywordlike'%{$key}%'";}?><h2>租房子</h2><formaction="zfchaxun.php"method="post"><div>区域：<inputtype="checkbox"onclick="checkall(this)"/>全选</div><div><?php$sqlq="selectdistinctareafromhouse";$rq=$db->query($sqlq);$aq=$rq->fetch_all();foreach($aqas$v){echo"<inputtype='checkbox'name='qx[]'value='{$v[0]}'>{$v[0]}";}?></div><br/><div>租赁类型：<inputtype="checkbox"/>全选</div><div><?php$sqlz="selectdistinctrenttypefromhouse";$rz=$db->query($sqlz);$az=$rz->fetch_all();foreach($azas$v){echo"<inputtype='checkbox'name='zl[]'value='{$v[0]}'>{$v[0]}";//设置name值}?></div><br/><div>房屋类型：<inputtype="checkbox"/>全选</div><div><?php$sqlf="selectdistincthousetypefromhouse";$rf=$db->query($sqlf);$af=$rf->fetch_all();foreach($afas$v){echo"<inputtype='checkbox'name='lx[]'value='{$v[0]}'>{$v[0]}";}?></div><br/><div>关键字：<inputtype="text"name="key"/><inputtype="submit"value="查询"/></div><br/></form><tablewidth="100%"border="1"cellpadding="0"cellspacing="0"><tr><td>关键字</td><td>区域</td><td>面积</td><td>租金</td><td>租赁类型</td><td>房屋类型</td></tr><?php$sqlall="select*fromhousewhere{$tj1}and{$tj2}and{$tj3}and{$tj4}";$rall=$db->query($sqlall);$aall=$rall->fetch_all();foreach($aallas$v){echo"<tr><td>{$v[1]}</td><td>{$v[2]}</td><td>{$v[3]}</td><td>{$v[4]}</td><td>{$v[5]}</td><td>{$v[6]}</td></tr>";}?></table><scripttype="text/javascript">//实现复选框的全选functioncheckall(a){varck=document.getElementsByClassName("qxlist");if(a.checked){for(vari=0;i<ck.length;i++){ck[i].setAttribute("checked","checked");复选框加个属性}}else{for(vari=0;i<ck.length;i++){ck[i].removeAttribute("checked");}}}</script></body></html>