Calculate distance given 2 points, latitude and longitude [duplicate]

by

You can use the formula that calculates distances between two points.
For example:

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)); 
}

You can also do something like:

$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.";

More Related Contents:

  1. What is the ideal data type to use when storing latitude / longitude in a MySQL database?
  2. Find distance between two points using latitude and longitude in mysql
  3. mySQL longitude and latitude query for other rows within x mile radius
  4. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  5. SQL split values to multiple rows
  6. How do I escape reserved words used as column names? MySQL/Create Table
  7. How to populate a table with a range of dates?
  8. What is the opposite of GROUP_CONCAT in MySQL?
  9. How to Perform an UPSERT so that I can use both new and old values in update part
  10. brew install mysql on macOS
  11. MySQL: selecting rows where a column is null
  12. How do I check to see if a value is an integer in MySQL?
  13. Convert timestamp to date in MySQL query
  14. Update a column value, replacing part of a string
  15. mysql: get record count between two date-time
  16. MySQL Insert Into from one Database in another
  17. How to remove all MySQL tables from the command-line without DROP database permissions? [duplicate]
  18. MySQL multiple columns in IN clause
  19. auto_increment by group
  20. GROUP BY – do not group NULL
  21. Composite key as foreign key (sql)
  22. Reserved word in column name – insert into MySQL [duplicate]
  23. Communications link failure , Spring Boot + MySql +Docker + Hibernate
  24. Too many auto increments with ON DUPLICATE KEY UPDATE
  25. The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread
  26. Execute INSERT if table is empty?
  27. Mysql How do you create a clustered index?
  28. Counting associated entries with Sequelize
  29. MySQL data directory location
  30. INSERT INTO fails with node-mysql

Leave a Comment