<?php
include("../0507jia/db.class.php"); 封装好的类
$db=new db1();
$sqla="1=1";
if(!empty($_POST["qy"]))
{
$shuzu1=$_POST["qy"];
$str1 = implode("','",$shuzu1);
$sqla=" area in('{$str1}') ";
}
$sqlb="2=2";
if(!empty($_POST["zp"]))
{
$shuzu2=$_POST["zp"];
$str2 = implode("','",$shuzu2);
$sqlb=" renttype in ('{$str2}')";
}
$sqlc="3=3";
if(!empty($_POST["fw"]))
{
$shuzu3=$_POST["fw"];
$str3 = implode("','",$shuzu3);
$sqlc=" hosetype in ('{$str3}')";
}
$value4="";
$sqld="1=1";
if(!empty($_POST["name"]))
{
$shuzu4=$_POST["name"];
$sqld=" keyword like '%{$shuzu4}%'";
$value4="{$shuzu4}";
}
?>
<form action="Untitled-1.php" method="post">
<span>区 域：</span> <input type="checkbox" id="qyqx" onclick="chuli1()" />全选</br>
<?php
$sql="select distinct area from fz";
$jieguo=$db->hanshu($sql);
foreach($jieguo as $v1)
{
echo"<input type='checkbox' name='qy[]' class='qy' value='{$v1[0]}'/>{$v1[0]} ";
}
?></br></br></br>
<span>租聘类型：</span> <input type="checkbox" id="zpqx" onclick="chuli2()" />全选</br>
<?php
$sql1="select distinct renttype from fz";
$jieguo1=$db->hanshu($sql1);
foreach($jieguo1 as $v2)
{
echo"<input type='checkbox' name='zp[]' class='zp' value='{$v2[0]}'/>{$v2[0]} ";
}
?></br></br></br>
<span>房屋类型：</span> <input type="checkbox" id="fwqx" onclick="chuli3()" />全选</br>
<?php
$sql2="select distinct hosetype from fz";
$jieguo2=$db->hanshu($sql2);
foreach($jieguo2 as $v3)
{
echo"<input type='checkbox' name='fw[]' class='fw' value='{$v3[0]}'/>{$v3[0]} ";
}
?></br></br></br>
<span>关键字：</span> <input type="text" name="name" value="<?php echo $value4 ?>" />
<input type="submit" value="提交" />
</form>
</br></br></br></br></br></br>
<?php
$sqlz="select * from fz where $sqla and $sqlb and $sqlc and $sqld";
$zjg=$db->hanshu($sqlz);
echo"<table border='1' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr>
<td>关键字</td>
<td>区域</td>
<td>建筑面积</td>
<td>租金</td>
<td>租聘类型</td>
<td>房屋类型</td>
</tr>";
foreach($zjg as $v4)
{
echo "<tr>
<td>{$v4[1]}</td>
<td>{$v4[2]}</td>
<td>{$v4[3]}</td>
<td>{$v4[4]}</td>
<td>{$v4[5]}</td>
<td>{$v4[6]}</td>
</tr>";
}
echo"</table>";
?>
</body>
<script type="text/javascript">
function chuli1()
{
var qx1=document.getElementById("qyqx").checked;
var qy1=document.getElementsByClassName("qy");
for(var i=0;i<qy1.length;i++)
{
qy1[i].checked=qx1;
}
}
function chuli2()
{
var qx2=document.getElementById("zpqx").checked;
var qy2=document.getElementsByClassName("zp");
for(var i=0;i<qy2.length;i++)
{
qy2[i].checked=qx2;
}
}
function chuli3()
{
var qx3=document.getElementById("fwqx").checked;
var qy3=document.getElementsByClassName("fw");
for(var i=0;i<qy3.length;i++)
{
qy3[i].checked=qx3;
}
}
</script>
效果:
