Solved

php mysql lat long query

Posted on 2007-03-29
3
1,414 Views
Last Modified: 2013-12-13
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
Comment
Question by:jimfrith
  • 2
3 Comments
 
LVL 24

Expert Comment

by:glcummins
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

by:jimfrith
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

by:
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
This article will explain how to display the first page of your Microsoft Word documents (e.g. .doc, .docx, etc...) as images in a web page programatically. I have scoured the web on a way to do this unsuccessfully. The goal is to produce something …
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question