tp3.2原生sql拼接查询
//获取搜索结果
$sql="SELECT* FROM `br_esf_village_price` p,(SELECT villageId,MAX(updateTime) max_time FROM br_esf_village_price GROUP BY villageId) as b,br_esf_village v WHERE p.villageId= b.villageId AND p.updateTime=b.max_time AND v.villageId = p.villageId ";
if($condition['qy']){//区域
$sql.="and fangAreaId = ".$condition['qy']." ";
}
if($condition['qy']){//商圈
$sql.="and fangTradingId = ".$condition['sq']." ";
}
if($condition['jg'] ||$condition['zdyjg']){//价格
$temp=array();
$temp=$condition['zdyjg'] ? explode(",",$condition['zdyjg']) : explode(",",$condition['jg']);
if(count($temp) ==2){
$sql.="and p.price >=".$temp[0]." and p.price <=".$temp[1]." ";
}
}
if($condition['ll']){
$temp=array();
$temp= explode(",",$condition['ll']);
if(count($temp) ==2){
$temp[0] = date("Y",strtotime("-".$temp[1]." years"));//这里大的反而小,小的反而大
$temp[1] = date("Y",strtotime("-".$temp[0]." years"));
$sql.="and buildingYears >= ".$temp[0]."";
}
}
if($condition['dt'] =='Y'){//地铁
$sql.=" and hasMetro = 1";
}
if($order=='default'){
$sql.= "ORDER BY orderBy desc";
}
if($order=='pricedesc'){
$sql.= "ORDER BY p.price desc";
}
if($order=='priceasc'){
$sql.= "ORDER BY p.price asc";
}
$sql.=" limit$PageClass->firstRow,$PageClass->listRows";
$data=$this->query($sql);
名称栏目:tp3.2原生sql拼接查询
转载来源:http://pwwzsj.com/article/ghjsop.html