tags:

views:

43

answers:

2
+1  Q: 

How can I search based on distance with the Google Maps API?

  1. So here's the issue... I have a field where users can type in their address (which will be GeoCoded via Google Maps API).
  2. I have several addresses of widgets in my database (saved as address.. again can easily be geocoded).

What I need is for the user to type in their address and for a list of my widgets to come up based on distance from their address. I have THOUSANDS of addresses for my widgets and users have an infinite number of addresses obviously.

Any ideas?

Thanks.

A: 

http://rafeekphp.wordpress.com/2009/04/17/calculate-distance-using-google-maps-api/

ghoppe  2010-03-17 20:28:15
This is fine for 2 points, but how do I do this for ALL my addresses in real time as the user types in his/her address?
Shamoon  2010-03-17 20:33:47
Through the use of a `for .. next` loop? Your widgets will already have been geocoded and stored in the database. After you geocode the user's address through an API call, it's just a matter of mathematics. Even thousands of addresses should only take a matter of seconds.
ghoppe  2010-03-17 21:36:10
+1  A: 

If you are storing the items in a MySQL DB, then here's the basis what you need

easement  2010-03-17 21:16:38

related questions

IDE suggestions: Eclipse IDE vs. Zend Studio ( confused )
MySQL/Apache Error in PHP MySQL query
Lightweight IDE for Linux
What PHP framework would you choose for a new application and why?
Why is my ternary expression not working?
How can I get at the matches when using preg_replace in PHP?
Mechanisms for tracking DB schema changes
Wordpress theme development offline tools
Using object property as default for method property
How can I get the authenticated user name under Apache using plain HTTP authentication and PHP?
Make XAMPP/Apache serve file outside of htdocs
How do you debug PHP scripts?
PHP Variables passed by value or by reference?
Best way to implement unit testing in PHP
Connect PHP to an AS/400
Best way to access Exchange using PHP?
PHP Session Security
How do I access a remote form in php?
What's the best way to generate a tag cloud from an array? (using h1 through h6 for sizing)
Apache/PHP: error_log per Virtual Host?
How do I track file downloads with apache/PHP
How would you access Object properties from within an object method?
Flat File Databases in PHP
Best way to allow plugins for a PHP application
Latest information on PHP upcoming releases