王明昌博客如果你对该文章中的内容有疑问/不解,可以点击此处链接提问
要注明问题和此文章链接地址 点击此处跳转
$slat = $banner_content['jd'];
$slng = $banner_content['wd'];
$sql = "select *, ROUND(6378.138*2*ASIN(SQRT(POW(SIN(($slat*PI()/180-jd*PI()/180)/2),2)+COS($slat*PI()/180)*COS(jd*PI()/180)*POW(SIN(($slng*PI()/180-wd*PI()/180)/2),2))),5) AS juli
FROM {$this->model->pre}post where status=1 HAVING juli <= 2";
$list = $this->model->query($sql);
$this->assign('list', $list);
