Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)归海一刀published in(发表于) 2014/2/17 7:33:39 PHP实例:用PHP简单实现多条件查询_[PHP教程]
在我们的网站设计过程中,经常会用到多条件查询,本文的源码是一个二手房屋查询的例子。在本例中,我们要实现能够通过地理位置,物业类型,房屋价格,房屋面积及信息发布日期等多个条件查询到客户所需的资料。
查询文件(search.php)
一、生成查询语句:
conn=mysql_connect("localhost","root",""); db=mysql_select_db("lingyun"); query="select * from message where tradetype='".tradetype."'"; //交易类型,如出租,出售 SQL=SQL . "wuye='" . wuye . "'"; if(housetype!="不限"){ query.=" && housetype='".housetype."'"; //房屋类型,如二室一厅,三室二厅 } if(degree!="不限"){ query.=" && degree='".degree."'"; //新旧程度 } if(wuye!="不限"){ query.=" && wuye='".wuye."'"; //物业类型 如住房,商铺 } if(price2!=""){ switch(price1){ case "大于": query.=" && price>'".price2."'"; //价格 break; case "等于": query.=" && price='".price2."'"; break; case "小于": query.=" && price<'".price2."'"; break; } } if(area2!=""){ switch(area1){ case "大于": query.=" && area>'".area2."'"; //面积 break; case "等于": query.=" && area='".area2."'"; break; case "小于": query.=" && area<'".area2."'"; break; } } switch(pubdate){ //发布日期 case "本星期内": query.=" && TO_DAYS(NOW()) - TO_DAYS(date)<=7"; break; case "一个月内": query.=" && TO_DAYS(NOW()) - TO_DAYS(date)<=30"; break; case "三个月内": query.=" && TO_DAYS(NOW()) - TO_DAYS(date)<=91"; break; case "六个月内": query.=" && TO_DAYS(NOW()) - TO_DAYS(date)<=183"; break; } if(address!=""){ query.=" && address like '%address%'"; //地址 } if(!page){ page=1; } ?>
二、输出查询结果:
if (page){ page_size=20; result=mysql_query(query); #message_count=mysql_result(result,0,"total"); message_count=10; page_count=ceil(message_count/page_size); offset=(page-1)*page_size; query=query." order by date desc limit offset, page_size"; result=mysql_query(query); if(result){ rows=mysql_num_rows(result); if(rows!=0){ while(myrow=mysql_fetch_array(result)){ echo ""; echo ""; echo "myrow[id] myrow[tradetype] myrow[address] myrow[wuye](myrow[housetype])[myrow[date]]"; echo ""; echo "详细内容"; echo ""; } } else echo "
现在还没有房屋租赁信息!
赞