phpcmsv9教程联动搜索在房地产网站开发中的应用

1、开发简述：使用phpcms v9系统，修改源文件 5个，创建模型：楼盘、出售、出租、中 介、小区，增加联动菜单：楼盘，增加用户组：房产中介。实现功能：游客发布信息、会员申请中介、楼盘全方位展示、报名团购、看房功能，发布信息时可根据登陆后的会员资料自动填好联系信息，中介有自己的店铺，可给中介留言，联动筛选搜索、排序，房源对比功能。联动筛选搜索功能的实现方法及代码： 要修改的文件就是list.html模板 核心代码：<?php$theurl = app_path.index.php?m=content&c=index&a=lists&catid=$catid; $wh

2、ere = status=99;$orderby =;foreach ($_get as $field => $r) if($r) if(!in_array($field,array(m,c,a,page) if(strrpos($field,_) $arr=explode(-,$r);$field = str_replace(_,$field);$where .= and $field >= $arr0 and $field <= $arr1;else if($field = title)$where .= and $field like .%.$r.%;else if($

3、field = orderby)$orderby = str_replace(_, ,$r);else$where .= and $field=$r;/if($where)$where = substr($where,5);if(!$orderby)$orderby = id desc;?>用这段代码来构造查询条件和排序方式，有了这段代码之后，要把 list.htm获得列表的 pc语句改造成这样原来的pc:content action=lists catid=$catid num=25 order=id desc page=$page 改造后的pc:content action=list

4、s where=$where catid=$catid num=25 order=$orderby page=$page 使用的时候就比较麻烦了<p><span> 状 态 ： </span><span><a href=url_par(price_=$_getprice_&hstatus=&typeid=$_gettypeid&address=$_getaddress,$theurl)> gt;</span><span if $_gethstatus = href=url_par(price_=

5、$_getprice_&hstatus=1& typeid=$_gettypeid&address=$_getaddress,$theurl)> gt;</span> <span if $_gethstatus = href=url_par(price_=$_getprice_&hstatus=2& typeid=$_gettypeid&address=$_getaddress,$theurl)> gt;</span> <span if $_gethstatus = href=url_par(pri

6、ce_=$_getprice_&hstatus=3&typeid=$_gettypeid&address=$_getaddress,$theurl)> gt;</span><span if $_gethstatus =href=url_par(price_=$_getprice_&hstatus=4&typeid=$_gettypeid&address=$_getaddress,$theurl)> gt;</span></p><p><span> 均 价 ： href=u

7、rl_par(price_=&hstatus=$_gethstatus& typeid=$_gettypeid&address=$_getaddress,$theurl)>全部 </a& amp;1class=shaixuan/if><a新盘 </a&amp;2class=shaixuan/if><a在售 </a&amp;3class=shaixuan/if><a尾 盘 </a& amp;4class=shaixuan/if><a售 完 </a&a

8、mp;</span><span><a全部 </a&amp;gt;</span><span if $_getprice_ = 0-4000class=shaixuan/if><ahref=url_par(price_=0-4000&hstatus=$_gethstatus&typeid=$_gettypeid&address=$_getaddress,$theurl)>4000 以下 & amp; lt;/a></span><span if $_getprice

9、_ =4000-5000class=shaixuan/if><ahref=url_par(price_=4000-5000&typeid=$_gettypeid&hstatus=$_gethstatus&address=$_getaddress,$theurl)>4000-5000</a></span><span if $_getprice_ =5000-6000class=shaixuan/if><ahref=url_par(price_=5000-6000&hstatus=$_gethstatus&

10、amp;typeid=$_gettypeid& address=$_getaddress,$theurl)>5000-6000</a></span><span if $_getprice_ =6000-7000class=shaixuan/if><ahref=url_par(price_=6000-7000&hstatus=$_gethstatus&typeid=$_gettypeid& address=$_getaddress,$theurl)>6000-7000</a></span>

11、;<span if $_getprice_ =7000-8000class=shaixuan/if><ahref=url_par(price_=7000-8000&hstatus=$_gethstatus&typeid=$_gettypeid&address=$_getaddress,$theurl)>7000-8000</a></span><span if $_getprice_ =8000-9000class=shaixuan/if><ahref=url_par(price_=8000-9000&am

12、p;hstatus=$_gethstatus&typeid=$_gettypeid& address=$_getaddress,$theurl)>8000-9000</a></span><span if $_getprice_ =9000-10000class=shaixuan/if><ahref=url_par(price_=9000-10000&hstatus=$_gethstatus&typeid=$_gettypeid& ;address=$_getaddress,$theurl)>9000-1

13、0000</a></span><span if$_getprice=10000-100000class=shaixuan/if><ahref=url_par(price_=10000-100000&hstatus=$_gethstatus&typeid=$_gettypeid&address=$_getaddress,$theurl)>10000 以上 & amp; lt;/a></span></p><p><span> 类 型 ： </span>&l

14、t;span><ahref=url_par(price_=$_getprice_&hstatus=$_gethstatus&typeid=&address=$_getaddress,$theurl)> 全部 </a></span& amp; gt;pc:get sql=select * from、v9house_type、where、module、=contentloop $data $key $val<span if $_gettypeid = $valtypeidclass=shaixuan/if><a

15、href=url_par(price_=$_getprice_&hstatus=$_gethstatus&typeid=$valtypeid& ;address=$_getaddress,$theurl)>$valname</a></span>/loop/pc</p><p><span>地区：</span><span><a href=url_par(price_=$_getprice_&hstatus=$_gethstatus& typeid=$_gettypei

16、d&address=,$theurl)>全部 </a></span& amp; gt;pc:get sql=select linkageid,name from、v9house_linkage、where parentid=(select linkageid from、v9house_linkage、where name=淄博市)loop $data $key $val<span if $_getaddress = $vallinkageidclass=shaixuan/if> <a href=url_par(price_=$_getp

17、rice_&hstatus=$_gethstatus&typeid=$_gettypeid&am p;address=$vallinkageid,$theurl)>$valname</a></span>/loop/pc</p>没办法，要想联动，就得每次都传递出所有需要联动的参数，所以 url的参数部分就很 多，容易晕掉获取搜索结果的代码是共返回php echo count($data); 个结果放在pc:content action=lists where=$where catid=$catid num=25 order=$orderb

18、y page=$page下面loop的上面共返回php echo count($data); 个结果排序的参数也很麻烦<a href=url_par(price_=$_getprice_&area_=$_getarea_&shi=$_getshi&typeid=$_gettypeid&address=$_getaddress&orderby=area_desc,$theurl)>面积 </a>基本就这样了，希望有人能看懂搜索表单也可以直接用在这里给个例子<form name=myform1 method=get action

19、=><input type=hidden name=m value=content><input type=hidden name=c value=index><input type=hidden name=a value=lists><span><select name=catid><option value=6>出售 </option><option value=12>求购 </option></select></span><span><select name=area_><option value=>面积不限 </option><option value=0-50>小于 50<