troubleshooting Question

Calculate lat/long

Avatar of DoobyWho
DoobyWho asked on
12 Comments1 Solution2899 ViewsLast Modified:
I have a bunch of lat/longs in my database and i'd like to perform a search to find the lat/longs within a specified distance. I found the following code, but I'm not sure how to port it to do that instead of calculate the distance between two points. any ideas?

// Function takes latitude and longitude
// of two places as input and prints the
// distance in miles and KMs.
function toMiles($lat1, $lon1, $lat2, $lon2)
    // Formula for calculating distances
    // from latitude and longitude.
    $dist   = acos(sin(deg2rad($lat1))
              * sin(deg2rad($lat2))
              + cos(deg2rad($lat1))
              * cos(deg2rad($lat2))
              * cos(deg2rad($lon1 - $lon2)));

    $dist   = rad2deg($dist);
    $miles  = (float) $dist * 69;

    // To get kilometers, multiply miles by 1.61
    $km     = (float) $miles * 1.61;

    // This is all displaying functionality
    $display  = sprintf("%0.2f",$miles).' miles' ;
    $display .= ' ('.sprintf("%0.2f",$km).' kilometers)' ;

    return $display ;
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 12 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros