DB::select("SELECT *, ACOS( COS(RADIANS('$latitude')) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS('$longitude')) + SIN(RADIANS('$latitude')) * SIN(RADIANS(latitude)) ) * 6378 as distance FROM 表 ORDER BY distance ASC limit 10");
sql根据经纬度获取到距离并进行排序
最新推荐文章于 2023-09-14 15:56:03 发布