SELECT *,(round(6367000 * 2 * asin(sqrt(pow(sin(((latitude * pi()) / 180 - ({$userLatitude} * pi()) / 180) / 2), 2) + cos(({$userLatitude} * pi()) / 180) * cos((latitude * pi()) / 180) * pow(sin(((longitude * pi()) / 180 - ({$userLongitude} * pi()) / 180) / 2), 2))))) AS distance FROM `table_distance` ORDER BY distance asc LIMIT 2,10;
mysql 距离计算和分页
最新推荐文章于 2021-01-20 21:39:00 发布