<?php
/**
 * Import zip code database into a simple MySQL table.
 * @author Aaron Collegeman http://aaroncollegeman.com
 * 
 * Copyright (C)2009 Collegeman.net, LLC.
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License along
 * with this program; if not, write to the Free Software Foundation, Inc.,
 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. 
 */

error_reporting(E_ALL);
ini_set('display_errors', true);

$content = file_get_contents('ZIP_CODES.txt');
mysql_connect(':/tmp/mysql.sock', 'root', 'password') or die('Failed to connect!');
mysql_select_db('zips');

mysql_query('DELETE FROM `zips`');

$buffer = array();
foreach(split("\n", $content) as $line) {
	$data = split(",", preg_replace('/"/', '', $line));
	if (count($data) >= 3) {
		$lat = trim(preg_replace('/^(\+)?(\-)?0*(.*)/', "$2$3", $data[1])); 
		$long = trim(preg_replace('/^(\+)?(\-)?0*(.*)/', "$2$3", $data[2]));
		$city = mysql_escape_string(trim(isset($data[3]) ? $data[3] : ''));
		$state = mysql_escape_string(trim(isset($data[4]) ? $data[4] : ''));
		
		if ($lat && $long) {
			$buffer[] = "('$data[0]', $lat, $long, '$city', '$state')";
			if (count($buffer) == 100) {
				$sql = "INSERT INTO `zips` (`zip`, `lat`, `long`, `city`, `state`) VALUES ".join(",", $buffer);
				mysql_query($sql) or die(mysql_error().": ".$sql);
				$buffer = array();
			}
		}
	}
}

if (count($buffer) > 0) {
	$sql = "INSERT INTO `zips` (`zip`, `lat`, `long`, `city`, `state`) VALUES ".join(",", $buffer);
	mysql_query($sql) or die(mysql_error().": ".$sql);
}