Get nearest places on Google Maps, using MySQL spatial data

by

You just need use following query.

For example, you have input latitude and longitude 37 and -122 in degrees. And you want to search for users within 25 miles from current given latitude and longitude.

SELECT item1, item2, 
    ( 3959 * acos( cos( radians(37) ) 
                   * cos( radians( lat ) ) 
                   * cos( radians( lng ) 
                       - radians(-122) ) 
                   + sin( radians(37) ) 
                   * sin( radians( lat ) ) 
                 )
   ) AS distance 
FROM geocodeTable 
HAVING distance < 25 
ORDER BY distance LIMIT 0 , 20;

If you want search distance in kms, then replace 3959 with 6371 in above query.

You can also do this like:

  1. Select all Latitude and longitude

  2. Then calculate the distance for each record.

  3. The above process can be done with multiple redirection.

For optimizing query you can use Stored Procedure.

And this can also help you.

More Related Contents:

  1. Measuring the distance between two coordinates in PHP
  2. Using PHP and google Maps Api to work out distance between 2 post codes (UK)
  3. Formulas to Calculate Geo Proximity
  4. Why doesn’t file_get_contents work?
  5. How to display only one country or a specific area in Google maps using the api?
  6. Reverse Geocoding With Google Map API And PHP To Get Nearest Location Using Lat,Long coordinates
  7. PHP / PDO echo data from database into a table
  8. Cookies vs. sessions
  9. How to remove non-alphanumeric characters?
  10. Enabling error display in PHP via htaccess only
  11. Read each line of txt file to new array element
  12. Sanitizing strings to make them URL and filename safe?
  13. Prevent sent emails treated as junk mails using php mail function
  14. Change PHP version used by Composer on Windows
  15. Using PHP substr() and strip_tags() while retaining formatting and without breaking HTML
  16. How to check that an object is empty in PHP?
  17. Start and stop a timer PHP
  18. MySQL statement takes more than minute to execute
  19. Generating XML document in PHP (escape characters)
  20. file_put_contents(meta/services.json): failed to open stream: Permission denied
  21. passing PHP objects to javascript [duplicate]
  22. How to decode a JSON string in PHP?
  23. Practical Zend_ACL + Zend_Auth implementation and best practices
  24. PHP: Get list of all filenames contained within my images directory [duplicate]
  25. Save Accents in MySQL Database
  26. Public static variable value
  27. i18n with gettext but without the locale hassle?
  28. Why cannot the PHP hide the error message thrown by the MySQL connection?
  29. Yii2 translation does not work
  30. Can a user alter the value of $_SESSION in PHP?

Leave a Comment