//獲取搜索結(jié)果
$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']){//區(qū)域
$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);
分享標(biāo)題:tp3.2原生sql拼接查詢
本文URL:http://muchs.cn/article8/ghjsop.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供電子商務(wù)、外貿(mào)建站、網(wǎng)站制作、用戶體驗、網(wǎng)站策劃、品牌網(wǎng)站制作
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)