WebSight Designs

function getZipCodes($search, $miles_away) {
	ini_set('memory_limit', '256M'); // set 128 MB memory limit
	$lines = file($_SERVER["DOCUMENT_ROOT"].'/demos/zipcode-proximity-search/zipcodes.csv');
	foreach($lines AS $line) {
		$parts = explode("\",\"", $line);
		$zipcode = str_replace('"', "", $parts[0]);
		$latitude = $parts[1];
		$longitude = $parts[2];
		$type = $parts[5];
		if($type != "MILITARY") {
			if($zipcode == $search) {
				$search_coords = array(
					'zipcode' => $zipcode,
					'lat' => $latitude,
					'long' => $longitude
				);
			}
			$zipcode_coords[] = array(
				'zipcode' => $zipcode,
				'lat' => $latitude,
				'long' => $longitude
			);
		}
	}
	foreach($zipcode_coords AS $coords) {
		if(calc_distance($coords, $search_coords) < $miles_away) {
			$return[] = $coords['zipcode'];
		}
	}
	return $return;
}
 
function calc_distance($point1, $point2) {
	$radius      = 3958;      // Earth's radius (miles)
	$pi          = 3.1415926;
	$deg_per_rad = 57.29578;  // Number of degrees/radian (for conversion)
	$distance = ($radius * $pi * sqrt(
				($point1['lat'] - $point2['lat'])
				* ($point1['lat'] - $point2['lat'])
				+ cos($point1['lat'] / $deg_per_rad)  // Convert these to
				* cos($point2['lat'] / $deg_per_rad)  // radians for cos()
				* ($point1['long'] - $point2['long'])
				* ($point1['long'] - $point2['long'])
				) / 180);
	return $distance;  // Returned using the units used for $radius.
}

$zipcodes = getZipCodes($_POST['search'], "5.01");

$sql = "SELECT id, zipcode FROM directory";
$total_query = mysql_query($sql) or die(mysql_error());
$total_numrows = mysql_num_rows($total_query);
if($_POST['doSearch'] && $searchby == "zipcode") {
	$zipcodes = getZipCodes($_POST['search'], "5.01");
	$i = "0";
	foreach($zipcodes AS $zipcode) {
		if($i == "0") $sql .= " WHERE "; else $sql .= " OR ";
		$sql .= "zipcode = '" . $zipcode . "'";
		$i++;
	}
} elseif($_POST['doSearch']) {
	$sql .= " WHERE " . $searchby . " LIKE '%" . $_POST['search'] . "%'";
}