满意答案
grainy.wang
推荐于 2017.10.13
采纳率:45% 等级:11
已帮助:8850人
PHP+Mysql多条件多值查询示例代码:
index.html代码:html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
SQL多条件查询示例房屋出租
房屋类型:
一居室
二居室
三居室
面积:
地址:
deal.php文件:<?php
//连接数据库
$conn=mysql_connect("localhost","root","");
//选择数据库
$db=mysql_select_db("数据库名");
//接收 参数
$type=$_POST['type'];
$area=$_POST['area'];
$addr=$_POST['addr'];
//SQL语句主题
$query="select * from room where ";
//根据条件和传的值拼接sql语句
//判断面积不为空
if($type!=""){
//然后根据具体面积分情况拼接
switch($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 area ={$area}";
}
//地址
if($addr!=""){
$query.=" and addr like '%{$addr}%'"; //地址
}
//执行查询
$result=mysql_query($query);
//遍历结果
echo "搜搜结果如下:";
while($row=mysql_fetch_array($result)){
echo "地址:".$row['addr'];
echo "
";
echo "面积:".$row['area'];
echo "
";
echo "居室:".$row['type'];
echo "
";
echo "价格:".$row['addr'];
echo "
";
//等等
}
?>
20分享举报