Skip to content

Instantly share code, notes, and snippets.

@angebagui
Forked from dev-hpjsolutions/Query : distance
Created December 8, 2017 09:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save angebagui/71a916ce8b0819e49fcf6b68c17db7e5 to your computer and use it in GitHub Desktop.
Save angebagui/71a916ce8b0819e49fcf6b68c17db7e5 to your computer and use it in GitHub Desktop.
Calculate distance between two points
function getDistanceBetweenPointsNew($latitude1, $longitude1, $latitude2, $longitude2) {
$theta = $longitude1 - $longitude2;
$miles = (sin(deg2rad($latitude1)) * sin(deg2rad($latitude2))) + (cos(deg2rad($latitude1)) * cos(deg2rad($latitude2)) * cos(deg2rad($theta)));
$miles = acos($miles);
$miles = rad2deg($miles);
$miles = $miles * 60 * 1.1515;
$feet = $miles * 5280;
$yards = $feet / 3;
$kilometers = $miles * 1.609344;
$meters = $kilometers * 1000;
return compact('miles','feet','yards','kilometers','meters');
}
$point1 = array('lat' => 40.770623, 'long' => -73.964367);
$point2 = array('lat' => 40.758224, 'long' => -73.917404);
$distance = getDistanceBetweenPointsNew($point1['lat'], $point1['long'], $point2['lat'], $point2['long']);
foreach ($distance as $unit => $value) {
echo $unit.': '.number_format($value,4).'<br />';
}
<?php
// Permet d'obtenir les entrés contenu dans un rayon ($within)
$latitude = 45.545421;
$longitude = -73.59288;
$within = 100;
$query = "
SELECT `zip_code`, (6371 * acos(cos(radians($latitude)) * cos(radians(`lat`)) * cos(radians(`long`) - radians($longitude)) + sin(radians($latitude)) * sin(radians(`lat`))))
AS `distance`
FROM `places`
HAVING `distance` < $within
ORDER BY `distance` ASC
LIMIT 10;";
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment