Jump to content

Distance


yrstruly
 Share

Recommended Posts

I have the following code(last) that display's distance. I would like to know if it is giving the correct output. It displays:Nearest stores to 64154:An invalid zip code was entered.I also need to change the code with the following code to call the stored procedure.When i modify the code it displays:Parse error: parse error in C:\xampp\htdocs\exercise\distance.php on line 42SELECT name, CONCAT_WS('<br />', address1, address2), city, state, stores.zip_code, phone, ROUND(return_distance($lat, $long, latitude, longitude)) AS distance FROM stores LEFT JOIN zip_codes USING (zip_code) ORDER BY distance ASC LIMIT 3 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> <title>Distance Calculator</title> <style type="text/css" title="text/css" media="all"> .error { color: #F30; } h3 { color: #00F; } </style> </head> <body> <?php # Script 3.3 - distance.php /* This page uses the zips database to * calculate the distance between a given * point and some stores. * The three closest stores are returned. */ $zip = 64154; //User's zip code. // Print a caption: echo "<h2>Nearest stores to $zip:</h2>\n";// Connect to the database: $dbc = @mysqli_connect ('localhost', 'root', 'musica', 'zips') OR die ('<pclass="error">Cannot connect to the database.</body></html>'); // Get the origination latitude and longitude: $q = "SELECT latitude, longitude FROM zip_codes WHERE zip_code='$zip' AND latitude IS NOT NULL"; $r = mysqli_query($dbc, $q); // Retrieve the results: if (mysqli_num_rows($r) == 1) { list($lat, $long) = mysqli_fetch_array($r, MYSQLI_NUM); // Big, main, complex, wordy query:$q = "SELECT name, CONCAT_WS('<br />', address1, address2), city, state, stores.zip_code,phone, ROUND(DEGREES(ACOS(SIN(RADIANS($lat)) * SIN(RADIANS(latitude)) + COS(RADIANS($lat)) * COS(RADIANS(latitude)) * COS(RADIANS($long - longitude))))) * 69.09 AS distance FROM stores LEFT JOIN zip_codes USING(zip_code) ORDER BY distance ASC LIMIT 3"; $r = mysqli_query($dbc, $q); if (mysqli_num_rows($r) > 0) { // Display the stores: while ($row = mysqli_fetch_array($r, MYSQLI_NUM)) { echo "<h3>$row[0]</h3> <p>$row[1]<br />" . ucfirst(strtolower($row[2])) . ", $row[3] $row[4]<br /> $row[5] <br /> (approximately $row[6] miles)</p>\n"; } // End of WHILE loop. } else { // No stores returned. echo '<p class="error">No stores matched the search.</p>'; } } else { // Invalid zip code. echo '<p class="error">An invalid zip code was entered.</p>'; } // Close the connection: mysqli_close($dbc); ?> </body> </html>

Link to comment
Share on other sites

Look at the code:

// Get the origination latitude and longitude:$q = "SELECT latitude, longitude FROM zip_codes WHERE zip_code='$zip' AND latitude IS NOT NULL";$r = mysqli_query($dbc, $q);// Retrieve the results:if (mysqli_num_rows($r) == 1) {... stuff stuff stuff} else { // Invalid zip code.echo '<p class="error">An invalid zip code was entered.</p>';}

It will print that message if the database query above didn't match any records.A parse error means that the code is not formed correctly, you might be missing a quote or semicolon somewhere.

Link to comment
Share on other sites

Look at the code:
// Get the origination latitude and longitude:$q = "SELECT latitude, longitude FROM zip_codes WHERE zip_code='$zip' AND latitude IS NOT NULL";$r = mysqli_query($dbc, $q);// Retrieve the results:if (mysqli_num_rows($r) == 1) {... stuff stuff stuff} else { // Invalid zip code.echo '<p class="error">An invalid zip code was entered.</p>';}

It will print that message if the database query above didn't match any records.A parse error means that the code is not formed correctly, you might be missing a quote or semicolon somewhere.

Thank you!
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...