Rudiger Posted March 17, 2012 Share Posted March 17, 2012 I have a script to find a User’s nearest store depending on their postcode. The postcodes being used here are American zip codes. Would it be possible to alter this script so that it returns the Users’ nearest store depending on the UK postcode they have entered? I have tried to do this by changing a few things such as changing 'int' to 'string' and 'is_numeric' to 'is_string' but cant seem to crack it. Here is the working script for finding a Users' nearest store - store_locator.php. <?php // Create page variables $r = NULL; $z = NULL; $stores = NULL; $Errors = NULL; $conn=mysqli_connect('localhost', 'username', 'password') or die ("No connection"); mysqli_select_db($conn, 'username') or die ("test will not open"); // Declare page functions function Dist ($lat1, $lon1, $lat2, $lon2) { $distance = sin(deg2rad($lat1)) * sin(deg2rad($lat2)) + cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * cos(deg2rad($lon1 - $lon2)); $distance = (rad2deg(acos($distance))) * 69.09; return $distance; } ### Handle form if submitted if (isset ($_POST['submitted'])) { // Validate Postcode code field if (!empty ($_POST['zip']) && is_numeric ($_POST['zip'])) { $z = (int)$_POST['zip']; // Verify Postcode code exists $query = "SELECT lat, lon FROM zip_codes WHERE zip = '$z'"; //$result = mysql_query ($query); $result=mysqli_query($conn, $query) or die ('Invalid query.'); if (mysqli_num_rows ($result) == 1) { $zip = mysqli_fetch_assoc ($result); } else { $Errors = '<p>The postcode code you entered was not found!</p>'; $z=NULL; } } // Validate radius field if (isset ($_POST['radius']) && is_numeric ($_POST['radius'])) { $r = (int)$_POST['radius']; } // Proceed if no errors were found if ($r && $z) { // Retrieve coordinates of the locations $stores = array(); $query = "SELECT name, address, town, state, postal, phone, hours, lat, lon FROM stores INNER JOIN zip_codes ON stores.postal = zip_codes.zip"; $result = mysqli_query ($conn, $query); // Go through and check all locations while ($row = mysqli_fetch_assoc ($result)) { // Separate closest locations $distance = Dist ($row['lat'], $row['lon'], $zip['lat'], $zip['lon']); // Check if store is in radius if ($distance <= $r) { $stores[] = array ( 'name' => $row['name'], 'address' => $row['address'], 'state' => $row['state'], 'town' => $row['town'], 'postal' => $row['postal'], 'phone' => $row['phone'], 'hours' => $row['hours'] ); } } } else { $Errors = ($Errors) ? $Errors : '<p>Errors were found please try again!</p>'; } } ?><html> <head> <title>Store Locator</title> </head> <body> <form action="" method="post"> <p>Enter your zip code below to find locations near you.</p> <?php echo ($Errors) ? $Errors : ''; ?> <div> <label>Zip:</label> <input name="zip" type="text" size="10" maxlength="5" /> </div> <div> <label>Search Area:</label> <select name="radius" id="radius"> <option value="5">5 mi.</option> <option value="10">10 mi.</option> <option value="15">15 mi.</option> <option value="20">20 mi.</option> </select> </div> <div> <input type="hidden" name="submitted" value="submitted" /> <input type="submit" value="Submit" /> </div> </form> <?php if (isset ($stores)) { if (!empty ($stores)) { echo '<p><strong>' . count ($stores) . ' results were found.</strong></p>'; foreach ($stores as $value) { echo '<p><strong>' . $value['name'] . '</strong><br />'; echo $value['address'] . '<br />'; echo $value['town'] . ', ' . $value['state'] . ' ' . $value['postal']; echo ' <a target="_blank" href="http://maps.google.com/maps?q=', $value['address'], ' ', $value['town'], ', ', $value['state'], ' ', $value['postal'], '">Map this location</a><br />'; echo 'Phone: ' . $value['phone'] . '<br />'; echo 'Hours: ' . $value['hours']; echo '</p>'; } } else { echo '<p><strong>No results found</strong></p>'; } } ?> </body> </html> The SQL used to create the tables is as follows: CREATE TABLE `stores` ( `store_id` INT(11) unsigned NOT NULL AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, `address` VARCHAR(50) NOT NULL, `town` VARCHAR(25) NOT NULL, `state` VARCHAR(50) NOT NULL, `postal` VARCHAR(5) NOT NULL, `phone` VARCHAR(20) DEFAULT NULL, `hours` VARCHAR(100) DEFAULT NULL, PRIMARY KEY (`store_id`), KEY `postal` (`postal`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `stores` */ INSERT INTO `stores`(`store_id`,`name`,`address`,`town`,`state`,`postal`,`phone`,`hours`) VALUES (1,'Main Shop','123 Church Street.','New York','New York','10007','(212) 992-3399','Mon-Fri: 9-5, Sat: 8-6, Sun: Closed'), (2,'Park Avenue Store','410 Park Avenue','New York','New York','10006','(212) 480-4400','Mon-Fri: 9-5, Sat: 8-6, Sun: Closed'), (3,'Central Park Store','50 Central Park West','New York','New York','10023','(212) 537-3294','Mon-Fri: 9-5, Sat: 8-6, Sun: Closed'), (4,'SOHO Store','311 East Houston Street','New York','New York','10005','(212) 545-5540','Mon-Fri: 9-5, Sat: 8-6, Sun: Closed'), (5,'Wall Street Store','110 Wall Street.','New York','New York','10014','(212) 210-0000','Mon-Fri: 9-5, Sat: 8-6, Sun: Closed'), (6,'Times Square Store','53 West 42nd Street','New York','New York','10036','(212) 646-1000','Mon-Fri: 9-5, Sat: 8-6, Sun: Closed'); CREATE TABLE IF NOT EXISTS `zip_codes` ( `zip_id` int(11) NOT NULL AUTO_INCREMENT, `zip` varchar(5) NOT NULL DEFAULT '', `abbr_state` char(2) NOT NULL DEFAULT '', `lat` varchar(10) NOT NULL DEFAULT '', `lon` varchar(10) NOT NULL DEFAULT '', `city` varchar(50) DEFAULT NULL, `full_state` varchar(50) DEFAULT NULL, PRIMARY KEY (`zip_id`), UNIQUE KEY `zip` (`zip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `zip_codes` -- INSERT INTO `zip_codes` (`zip_id`, `zip`, `abbr_state`, `lat`, `lon`, `city`, `full_state`) VALUES (1, '10007', 'NY', '40.714754', '-74.00721', 'New York', 'New York'), (2, '10006', 'NY', '40.707904', '-74.01342', 'New York', 'New York'), (3, '10023', 'NY', '40.776099', '-73.98285', 'New York', 'New York'), (4, '10005', 'NY', '40.706019', '-74.00858', 'New York', 'New York'), (5, '10014', 'NY', '40.734718', '-74.00532', 'New York', 'New York'), (6, '10036', 'NY', '40.759511', '-73.99019', 'New York', 'New York'); Any help is much appreciated! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.