$sql ="SELECT *, round(( ACOS( SIN(($lat * 3.1415) / 180) * SIN((latitude * 3.1415) / 180) + COS(($lat * 3.1415) / 180) * COS((latitude * 3.1415) / 180) * COS( ($lon * 3.1415) / 180 -(longitude * 3.1415) / 180 ) ) * 6370.996 ),2) as distance FROM `yoshop_store_shop` order by distance asc";
*$lon = $_GET['lon'];// 经度
$lat = $_GET['lat'];//纬度*
根据经纬度全国范围最近查找
最新推荐文章于 2023-08-21 16:45:14 发布