zipcodes-ss

MySql City, State, Zip, Latitude, Longitude Database

Posted in MySql Tutorials, PHP Tutorials, Tutorials.
1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading ... Loading ...
Share This:
DeliciousFacebookDiggRSS FeedStumbleUponTwitter

Just recently I needed a mysql database table that contained records for city, state, zip, latitude, and longitude coordinates. I needed a complete list of locations since one of my projects involved an ajax location auto populating script. While browsing on the web to find a free solution, I finally found a complete list of US zip codes from 2006 that contained everything that I wanted. I downloaded the files and realized it was written in Pearl by R. Don Henning. I rewrote it in PHP for developers looking for a PHP solution.

Simply Download the files and place the directory wherever you would like. Make sure to edit the zip_insert.php file and change the database connection with yours.

Download php-mysql-locations.zip

One Response to MySql City, State, Zip, Latitude, Longitude Database

  1. Desire says:

    Thx Jesse, ok script.. but mysql add , update, delete how, pls help new script.
    Thx.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">