Solved

# php mysql lat long query

Posted on 2007-03-29
1,416 Views
I would like to search for records within a given distance like 10km.  i have a table called users with username, userid, lat and lon as fields.

I would like to return all the users within 10km from say user number 15 and then order the records from nearest to farthest.  I would like to do this in the most economic way possible so I believe that means doing all the calculations within the mysql query.

does anyone know how to accomplish this this?
0
Question by:jimfrith
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 24

Expert Comment

ID: 18819930
Here is a PHP method to calculate distance based on latitude and longitude. There may be a MySQL way to do this, but I'm not sure:

Takes two sets of coordinates in decimal longitude and latitude format and returns the distance in kilometers.
<?php

\$lat1 = 46.2341938036161;
\$lon1 = -63.124778021257015;

\$lat2 = 46.4141938036161;
\$lon2 = -63.118571124705284;

\$distance = (3958*3.1415926*sqrt((\$lat2-\$lat1)*(\$lat2-\$lat1) + cos(\$lat2/57.29578)*cos(\$lat1/57.29578)*(\$lon2-\$lon1)*(\$lon2-\$lon1))/180);

print(\$distance);

?>
0

Author Comment

ID: 18820773
Thats not what I'm looking for.  already know the distance in kilometers I need an mysql query to return all users within that distance.
0

Accepted Solution

jimfrith earned 0 total points
ID: 18822517
I found a tutorial here that solved my problem:

http://www.phparch.com/sample.php?disc_show=316&mid=9
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and tâ€¦
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
###### Suggested Courses
Course of the Month4 days, 7 hours left to enroll