Find distance between two points using MYSQL

Question

i have to find distance between two points (lat and long)

SELECT *,(3959 * ACOS( COS(RADIANS(".$latitude.")) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS(".$longitude.")) + SIN(RADIANS(".$latitude.")) * SIN(RADIANS(latitude)))) as distance FROM tbl_places tp 
            LEFT JOIN tbl_categories tc 
            ON tp.category_id = tc.category_id
            WHERE tc.category_name = 'food'
            ORDER BY distance ASC

Possible duplicate of [Calculate distance given 2 points, latitude and longitude](http://stackoverflow.com/questions/8599200/calculate-distance-given-2-points-latitude-and-longitude) — Rakesh Shewale, Apr 19 '17 at 06:11

score 0 · Accepted Answer · answered Apr 19 '17 at 04:51

Try this function:

function distance($lat1, $lon1, $lat2, $lon2, $unit) {

  $theta = $lon1 - $lon2;
  $dist = sin(deg2rad($lat1)) * sin(deg2rad($lat2)) +  cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * cos(deg2rad($theta));
  $dist = acos($dist);
  $dist = rad2deg($dist);
  $miles = $dist * 60 * 1.1515;
  $unit = strtoupper($unit);

  if ($unit == "K") {
    return ($miles * 1.609344);
  } else if ($unit == "N") {
      return ($miles * 0.8684);
    } else {
        return $miles;
      }
}

echo distance(32.9697, -96.80322, 29.46786, -98.53506, "M") . " Miles<br>";
echo distance(32.9697, -96.80322, 29.46786, -98.53506, "K") . " Kilometers<br>";
echo distance(32.9697, -96.80322, 29.46786, -98.53506, "N") . " Nautical Miles<br>";

Code reference - geodatasource

Sounds great !!. Don't forget to accept the answer if it helps you :D — Mayank Pandeyz, Apr 19 '17 at 04:57

Find distance between two points using MYSQL

1 Answers1