频道导航

PHP实现多条件查询实例代码

2018-12-30 PHP 前端之家

前端之家收集整理的这篇文章主要介绍了PHP实现多条件查询实例代码，前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。

一、生成 查询语句：

<div class="codetitle"><a style="CURSOR: pointer" data="55076" class="copybut" id="copybut55076" onclick="doCopy('code55076')"> 代码如下:

<div class="codebody" id="code55076"> @H_4040@<? @H404_0@$conn=MysqLconnect("localhost","root",""); @H404_0@$db=MysqL_selectdb("lingyun"); @H4040@$query="select * from message where tradetype='".$tradetype."'"; //交易类型，如出租，出售 @H404_0@$sql=$sql . "wuye='" . $wuye . "'"; @H_4040@if($housetype!="不限"){ @H4040@$query.=" && housetype='".$housetype."'"; //房屋类型，如二室一厅，三室二厅 @H4040@} @H4040@if($degree!="不限"){ @H4040@$query.=" && degree='".$degree."'"; //新旧程度 @H4040@} @H4040@if($wuye!="不限"){ @H4040@$query.=" && wuye='".$wuye."'"; //物业类型如住房，商铺 @H4040@} @H4040@if($price2!=""){ @H4040@switch($price1){ @H4040@case "大于": @H4040@$query.=" && price>'".$price2."'"; //价格 @H4040@break; @H4040@case "等于": @H4040@$query.=" && price='".$price2."'"; @H4040@break; @H4040@case "小于": @H4040@$query.=" && price<'".$price2."'"; @H4040@break; @H4040@} @H4040@} @H4040@if($area2!=""){ @H4040@switch($area1){ @H4040@case "大于": @H4040@$query.=" && area>'".$area2."'"; //面积 @H4040@break; @H4040@case "等于": @H4040@$query.=" && area='".$area2."'"; @H4040@break; @H4040@case "小于": @H4040@$query.=" && area<'".$area2."'"; @H4040@break; @H4040@} @H4040@} @H4040@switch($pubdate){ //发布日期 @H4040@case "本星期内": @H404_0@$query.=" && TO_DAYS(NOW()) - TODAYS(date)<=7"; @H4040@break; @H4040@case "一个月内": @H404_0@$query.=" && TO_DAYS(NOW()) - TODAYS(date)<=30"; @H4040@break; @H4040@case "三个月内": @H404_0@$query.=" && TO_DAYS(NOW()) - TODAYS(date)<=91"; @H4040@break; @H4040@case "六个月内": @H404_0@$query.=" && TO_DAYS(NOW()) - TODAYS(date)<=183"; @H4040@break; @H4040@} @H4040@if($address!=""){ @H4040@$query.=" && address like '%$address%'"; //地址 @H4040@} @H4040@if(!$page){ @H4040@$page=1; @H4040@} @H4040@?> @H404_0@

二、输出 查询结果：

@H_404_0@<div class="codetitle"><a style="CURSOR: pointer" data="46790" class="copybut" id="copybut46790" onclick="doCopy('code46790')"> 代码如下:

<div class="codebody" id="code46790"> @H_404_0@<?PHP @H_4040@if ($page){ @H404_0@$pagesize=20; @H404_0@$result=MysqLquery($query); @H404_0@#$message_count=MysqLresult($result,"total"); @H404_0@$messagecount=10; @H404_0@$page_count=ceil($message_count/$pagesize); @H404_0@$offset=($page-1)*$pagesize; @H404_0@$query=$query." order by date desc limit $offset,$pagesize"; @H404_0@$result=MysqLquery($query); @H4040@if($result){ @H404_0@$rows=MysqL_numrows($result); @H4040@if($rows!=0){ @H404_0@while($myrow=MysqL_fetcharray($result)){ @H4040@echo "<tr>"; @H4040@echo "</td>"; @H4040@echo "$myrow[id] $myrow[tradetype] $myrow[address] $myrowwuye[$myrow[date]]"; @H4040@echo "</td>"; @H404_0@echo "详细内容</td>"; @H_4040@echo "</tr>"; @H4040@} @H4040@} @H4040@else echo "<tr><td>

没有找到满足你条件的记录
& lt;/td></tr>"; @H4040@} @H404_0@$prevpage=$page-1; @H404_0@$nextpage=$page 1; @H4040@echo "

"; @H404_0@echo " 第".$page."/".$pagecount."页&nbsp"; @H4040@if ($page<=1){ @H4040@echo "|第一页|"; @H4040@} @H4040@else{ @H404_0@echo "|第一页|"; @H_4040@} @H4040@echo " "; @H404_0@if ($prevpage<1){ @H404_0@echo "|上一页|"; @H_4040@} @H4040@else{ @H404_0@echo "|上一页|"; @H_4040@} @H4040@echo " "; @H404_0@if ($next_page>$pagecount){ @H404_0@echo "|下一页|"; @H_4040@} @H4040@else{ @H404_0@echo "|下一页|"; @H_4040@} @H4040@echo " "; @H404_0@if ($page>=$pagecount){ @H4040@echo "|最后一页|"; @H4040@} @H4040@else{ @H404_0@echo "|最后一页|"; @H_4040@} @H4040@echo "

"; @H4040@} @H4040@else{ @H4040@echo "
现在还没有房屋租赁信息!
"; @H4040@} @H4040@echo "<hr width="100%" size="1">"; @H4040@?> @H4040@</table> @H404_0@

PHP 多条件查询