Guest User

Untitled

a guest
Nov 22nd, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. /* PHP */
  2. //Get latitude and longitude from geo data
  3. $latitudeFrom = '11.016844';
  4. $longitudeFrom = '76.955832';
  5. $latitudeTo = '11.232103';
  6. $longitudeTo = '77.106716';
  7.  
  8. $unit = 'z';
  9.  
  10. $theta = $longitudeFrom - $longitudeTo;
  11. $dist = sin(deg2rad($latitudeFrom)) * sin(deg2rad($latitudeTo)) + cos(deg2rad($latitudeFrom)) * cos(deg2rad($latitudeTo)) * cos(deg2rad($theta));
  12. $dist = acos($dist);
  13. $dist = rad2deg($dist);
  14. $miles = $dist * 60 * 1.1515;
  15. $unit = strtoupper($unit);
  16.  
  17. if ($unit == "K") {
  18. echo ($miles * 1.609344).' km';
  19. } else if ($unit == "N") {
  20. echo ($miles * 0.8684).' nm';
  21. } else {
  22. echo $miles.' mi';
  23. }
  24.  
  25. // MySQL Query
  26. Example:
  27. (i) select 1.609344* 3956 * 2 * ASIN(SQRT( POWER(SIN((11.016844 - 11.232103) * pi()/180 / 2), 2) +COS(11.016844 * pi()/180) * COS(11.232103 * pi()/180) * POWER(SIN((76.955832 - 77.106716) * pi()/180 / 2), 2) )) AS distance
  28. (ii) Select 1.609344 * 3956 * 2 * ASIN(SQRT( POWER(SIN((" . $latitude . " - sa.shop_latitude) * pi()/180 / 2), 2) +COS(" . $latitude . " * pi()/180) * COS(sa.shop_latitude * pi()/180) * POWER(SIN((" . $longitude . " - sa.shop_longitude) * pi()/180 / 2), 2) )) AS distance
Add Comment
Please, Sign In to add comment