<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>SQL多条件查询示例</title>
</head>
<body>
<form method="post" action="center.php">
<h1>房屋出租</h1>
房屋类型：<select name="type">
<option value="1">一居室</option>
<option value="2">二居室</option>
<option value="3">三居室</option>
</select>
面积：<input name="area" type="text"/>
地址：<input name="addr" type="text"/>
<input name="btn" type="submit" value="搜索" />
</form>
</body>
</html>
<?php
//连接数据库
header("Content-Type: text/html; charset=utf-8");
$link = @mysql_connect("localhost","root","") or die('错误'.mysql_error());//die 输出()中的内容 终止后面的程序
//echo $link;
//info 是文件名
//选库函数 mysql_select_db();
mysql_select_db("xl");
mysql_query("set names utf8");
//接收 参数
$room_type=$_POST['type'];
$area=$_POST['area'];
$addr=$_POST['addr'];
//SQL语句主题
$query="select * from cx where ";
//根据条件和传的值拼接sql语句
//判断面积不为空
if($room_type!=""){
//然后根据具体面积分情况拼接
switch($room_type){
case 1:
//一居室
$query.="room_type=1";
break;
case 2:
$query.="room_type=2";
break;
case 3:
$query.="room_type=3";
break;
}
}
//面积
if($area!=""){
$query.=" and darea >{$area} and xarea <{$area}";//select * from a where id>200 and id<500
}
//地址
if($addr!=""){
$query.=" and addr like '%{$addr}%'"; //地址
}
//执行查询
$result=mysql_query($query);
//遍历结果
echo "搜搜结果如下：<br>";
while($row=mysql_fetch_array($result)){
echo "地址：".$row['addr'];
echo ",";
echo "面积：".$row['xarea']."-".$row['darea'];
echo ",";
echo "居室：".$row['room_type'];
echo ",";
echo "价格：".$row['addr'];
echo "<br>";
//等等
}
?>
创作新主题