MYSQL 计算距离(依据经度纬度)
SELECT ROUND(6378.138*2*ASIN(SQRT(POW(SIN(($ilat*PI()/180-lat*PI()/180)/2),2)+COS($ilat*PI()/180)*COS(lat*PI()/180)*POW(SIN(($ilng*PI()/180-lng*PI()/180)/2),2))),2) AS distance FROM store WHERE lat is not NULL and lng is not NULL ORDER BY distance ASC
php 计算距离(依据经度纬度)
private function getDistance($lng1,$lat1, $lng2,$lat2)
{
$earthRadius = 6367000; //approximate radius of earth in meters
$lat1 = ($lat1 * pi() ) / 180;
$lng1 = ($lng1 * pi() ) / 180;
$lat2 = ($lat2 * pi() ) / 180;
$lng2 = ($lng2 * pi() ) / 180;
$calcLongitude = $lng2 - $lng1;
$calcLatitude = $lat2 - $lat1;
$stepOne = pow(sin($calcLatitude / 2), 2) + cos($lat1) * cos($lat2) * pow(sin($calcLongitude / 2), 2);
$stepTwo = 2 * asin(min(1, sqrt($stepOne)));
$calculatedDistance = $earthRadius * $stepTwo;
$calculatedDistance /= 1000;
return round($calculatedDistance,2);
}