王明昌博客如果你对该文章中的内容有疑问/不解,可以点击此处链接提问
要注明问题和此文章链接地址 点击此处跳转
|
1 2 3 4 5 6 |
$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); |
