$sql="select b.EstateName,b.mapX,b.mapY from zh_Estate b left join zh_Estate_Pic p on b.EstateId=p.estateID where 1 and (b.mapX is not null and b.mapX !='' )"; if($price) { $price = addslashes(trim($price)); $price = explode(",", $price); $smallPrice = $price[0]; $largePrice = $price[1]; $sql.=' AND b.curAve BETWEEN '.$smallPrice.' AND '.$largePrice; }
if($area) { $sql.=" AND b.districtName='".$area."'"; } $sql.=' group by b.EstateId limit 2 '; $objDB = dblink(); $objDB->execute($sql); while($rs_f=$objDB->fetch_array()) { //iconv('gbk','utf-8',$rs_f['EstateName']); //$rs_f['EstateName']=urlencode(iconv('gb2312', 'utf-8',$rs_f['EstateName'])); $data_f[]=$rs_f; } echo json_encode($data_f); // return $data_f;
?>
Jquery+asp.net 后台数据传到前台js进行解析的办法说明 - 项目实战 - IT工作生活这点事。Just Such So! http://www.suchso.com/projecteactual/jquery-aspnet-back-js-parse-object-list.html
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn