if ($lng != null & $lat != null) { $sql = "SELECT id,face,company_name,mobile,address,type,lng,lat,view,mainpro,identification,s_id,province,city,grade,tele_person, round(6378.138*2*asin(sqrt(pow(sin( ($lat*pi()/180-lat*pi()/180)/2),2)+cos($lat*pi()/180)*cos(lat*pi()/180)* pow(sin( ($lng*pi()/180-lng*pi()/180)/2),2)))) as juli FROM wd_shangjia_around where type=$type" . $where . " ORDER BY juli asc,view desc LIMIT $start,$pagesize"; }
经纬度计算距离排序
最新推荐文章于 2022-07-15 10:42:01 发布