计算给定2点的距离，即纬度和经度[重复]

您可以使用公式来计算两点之间的距离。例如：

function get_distance($latitude1, $longitude1, $latitude2, $longitude2, $unit = 'Mi') {     $theta = $longitude1 - $longitude2;     $distance = (sin(deg2rad($latitude1)) * sin(deg2rad($latitude2))) +      (cos(deg2rad($latitude1)) * cos(deg2rad($latitude2)) *      cos(deg2rad($theta)));     $distance = acos($distance);     $distance = rad2deg($distance);     $distance = $distance * 60 * 1.1515;     switch($unit) {         case 'Mi':  break;         case 'Km' :  $distance = $distance * 1.609344;     }     return (round($distance,2)); }

您还可以执行以下 *** 作：

$query = "SELECt *,(((acos(sin((".$latitude."*pi()/180)) *  sin((`Latitude`*pi()/180))+cos((".$latitude."*pi()/180)) *  cos((`Latitude`*pi()/180)) * cos(((".$longitude."- `Longitude`)*  pi()/180))))*180/pi())*60*1.1515        ) as distance         FROM `MyTable`         HAVINg distance >= ".$distance.";