php/mysql zip code proximity search

by

Here is the best way I have found. Of course it will require that you have all of your zipcodes lat/lon encoded in the database. 

// get all the zipcodes within the specified radius - default 20
function zipcodeRadius($lat, $lon, $radius)
{
    $radius = $radius ? $radius : 20;
    $sql="SELECT distinct(ZipCode) FROM zipcode  WHERE (3958*3.1415926*sqrt((Latitude-".$lat.')*(Latitude-'.$lat.') + cos(Latitude/57.29578)*cos('.$lat.'/57.29578)*(Longitude-'.$lon.')*(Longitude-'.$lon.'))/180) <= '.$radius.';';
    $result = $this->db->query($sql);
    // get each result
    $zipcodeList = array();
    while($row = $this->db->fetch_array($result))
    {
        array_push($zipcodeList, $row['ZipCode']);
    }
    return $zipcodeList;
}

You should be able to just drop in this function. Pass it the $lat and $lon of the zipcode you want the radius for, include the optional radius, and get a list of zipcodes back.

You could very easily modify this to get all users where zipcode IN (radius_sql) and get your list users back.

Happy Coding!

More Related Contents:

  1. Order results from two queries based on time in second query [closed]
  2. Query database then email posts from where user is subbed to
  3. Save the data into a database and return another value from database using PHP
  4. Problame with files on SQL
  5. Im trying to create some temporary tables in mysql using php
  6. How to include a PHP variable inside a MySQL statement
  7. How can I do ‘insert if not exists’ in MySQL?
  8. How to apply bindValue method in LIMIT clause?
  9. Can I parameterize the table name in a prepared statement?
  10. Getting raw SQL query string from PDO prepared statements
  11. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  12. MySQL Prepared statements with a variable size variable list
  13. PDO with INSERT INTO through prepared statements [closed]
  14. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  15. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]
  16. Comma separated values in MySQL “IN” clause
  17. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  18. Doing a while / loop to get 10 random results
  19. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  20. MYSQL Select from tables based on multiple rows
  21. How to execute raw queries with Laravel 5.1?
  22. Simple PHP SQL login troubleshooting
  23. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  24. How do you do multiple SQL statements in one mysql_query?
  25. Laravel Eloquent get results grouped by days
  26. MySQL/SQL retrieve first 40 characters of a text field?
  27. Do I have to use mysql_real_escape_string if I bind parameters?
  28. PDO and MySQL ‘between’
  29. MySQL Join Multiple Rows as Columns
  30. Aggregated query without GROUP BY

Leave a Comment