练习之租房

最新推荐文章于 2025-09-05 16:58:34 发布

转载最新推荐文章于 2025-09-05 16:58:34 发布 · 119 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/nannan-0305/p/5474192.html

文章标签：

#php #xhtml #javascript #ViewUI

创建表

create table House
( Id int(20) auto_increment not null primary key ,//自增长，主键类型必须为int
KeyWord varchar(50) not null,
Area varchar(50) not null ,
SquareMeter int(20) not null,
Rent varchar(50) not null,
RentType varchar(50) not null,
HouseType varchar(50) not null
);
insert into House values(null,"中关村1居2300/月","中关村",30,"￥2300","整租","1室1厅");
insert into House values(null,"天安门四合院1w/月","天安门东",240,"￥10000","合租","平房");
insert into House values(null,"上上城3居便宜","上上城",100,"￥1500","整租","3室2厅");
insert into House values(null,"人民大学附近好房","三义庙",100,"￥1500","合租","2室1厅");
insert into House values(null,"世纪金源垂虹园4居","坂井",120,"￥9000","整租","4室2厅");
insert into House values(null,"人大学生公寓","三义庙",8,"￥800","床位","筒子楼");

<!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" onclick="QuYucheck()"  />全选</div>
<?php
include("./ChaXun.class.php");//加载类
$db=new ChaXun();
$sql="select distinct Area from House";//去重查询关键字distinct
$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" onclick="ZuLinCheck()"  />全选</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" onclick="FangWuCheck()"  />全选</div>
<?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

$value="";
$tj1="1=1";$tj2="1=1";$tj3="1=1";$tj4="1=1";//将满足的条件赋值为恒成立的

if(!empty($_POST["qy"]))//判断是否为空

{    $attr1=$_POST["qy"];//取"name"数组
    $str = implode("','",$attr1);//用','隔开数组
    $tj1= " Area in ('{$str}')";
    
}
if(!empty($_POST["zulin"]))
{    $attr2=$_POST["zulin"];
    $strzu=implode("','",$attr2);
    $tj2=" RentType in ('{$strzu}')";
}
if(!empty($_POST["fangwu"]))
{   $attr3=$_POST["fangwu"];
    $strfw=implode("','",$attr3);
    $tj3=" HouseType in('{$strfw}')";
}

if(!empty($_POST["guanjianzi"]))
{
    $tj4="KeyWord like '%{$_POST['guanjianzi']}%'";
    $name=$_POST["guanjianzi"];
    $value=$name;
}
if(!empty($_POST["qy"])||!empty($_POST["zulin"])||!empty($_POST["fangwu"])||!empty($_POST["guanjianzi"]))//一项不为空即可向下执行
{
$sqlall="select * from House where {$tj1} and {$tj2} and {$tj3} and {$tj4}";
//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">//js方法点击全选全部选中
function QuYucheck()
{
    var qx=document.getElementById("qy").checked;
    var xx=document.getElementsByClassName("qy");
    for(i=0;i<=xx.length;i++)
    {
        xx[i].checked=qx;
    }
}
function ZuLinCheck()
{
    var qx=document.getElementById("zulin").checked;
    var xx=document.getElementsByClassName("zulin");
    for(i=0;i<=xx.length;i++)
    {
        xx[i].checked=qx;
    }
}
function FangWuCheck()
{
    var qx=document.getElementById("fangwu").checked;
    var xx=document.getElementsByClassName("fangwu");
    for(i=0;i<=xx.length;i++)
    {
        xx[i].checked=qx;
    }
}
</script>
</html>