In the script below, I am trying to assign
The values of:
$row["latitude_deg"]
$row["longitude_deg"]
to:
$point2_lat
$point2_lng
It does not work.
Any suggestion?
<?php
$host = "mysql1105.ixwebhosting.com";
$user = "C245051_yossi";
$pass = "D300Nikon";
$myinfo = "small_airport";
$dbname="C245051_airport";
$con=mysqli_connect($host, $user, $pass, $dbname);
// Latitude and Longitude
$point1_lat ='40.79520035';//ISP
$point1_lng ='-73.10019684';//ISP
// Destination
//$point2_lat=$row["latitude_deg"]; }
// } From Function
//$point2_lng=$row["longitude_deg"]; }
//Function call with the coordinates.
$miles = calculateDistance($point1_lat, $point1_lng, $point2_lat, $point2_lng);
echo '<br>Nautical Miles : '.$nautical_miles = $miles * 0.868976;
echo "<br>";
function calculateDistance($latitude1, $longitude1, $latitude2, $longitude2) {
$theta = $longitude1 - $longitude2;
$miles = (sin(deg2rad($latitude1)) * sin(deg2rad($latitude2))) + (cos(deg2rad($latitude1)) * cos(deg2rad($latitude2)) * cos(deg2rad($theta)));
$miles = acos($miles);
$miles = rad2deg($miles);
$miles = $miles * 60 * 1.1515;
return $miles; }
$city = $_REQUEST['city'];
$state = $_REQUEST['states'];
if (mysqli_connect_errno())
{
echo 'Could not connect to mysql';
exit;}
else
{
}
$sql = "SELECT* FROM small_airport WHERE iso_region = '$state' AND municipality = '$city' and type<>'heliport' ";
echo "<br>";
Echo $sql;
echo "<br>";
$result=mysqli_query($con,$sql) or exit( mysqli_error($con) );
$row=mysqli_fetch_assoc($result);
echo "<br>";
echo "Row: \n";
echo "<br>";
echo "<pre>";
print_r($row);
echo "</pre>";
Echo $row;
$point2_lat=$row["latitude_deg"];
$point2_lng=$row["longitude_deg"];
mysql_close();
?>
<form action="DisCalc_07.php" method="post">
Destination State:<br>
<select name = "states">
<option value="AL">Alabama</option>
<option value="US-AK">Alaska</option>
<option value="US-AZ">Arizona</option>
<option value="US-AR">Arkansas</option>
<option value="US-CA">California</option>
<option value="US-CO">Colorado</option>
<option value="US-CT">Connecticut</option>
<option value="US-DE">Delaware</option>
<option value="US-DC">District Of Columbia</option>
<option value="US-FL">Florida</option>
<option value="US-GA">Georgia</option>
<option value="US-HI">Hawaii</option>
<option value="US-ID">Idaho</option>
<option value="US-IL">Illinois</option>
<option value="US-IN">Indiana</option>
<option value="US-IA">Iowa</option>
<option value="US-KS">Kansas</option>
<option value="US-KY">Kentucky</option>
<option value="US-LA">Louisiana</option>
<option value="US-ME">Maine</option>
<option value="US-MD">Maryland</option>
<option value="US-MA">Massachusetts</option>
<option value="US-MI">Michigan</option>
<option value="US-MN">Minnesota</option>
<option value="US-MS">Mississippi</option>
<option value="US-MO">Missouri</option>
<option value="US-MT">Montana</option>
<option value="US-NE">Nebraska</option>
<option value="US-NV">Nevada</option>
<option value="US-NH">New Hampshire</option>
<option value="US-NJ">New Jersey</option>
<option value="US-NM">New Mexico</option>
<option value="US-NY">New York</option>
<option value="US-NC">North Carolina</option>
<option value="US-ND">North Dakota</option>
<option value="US-OH">Ohio</option>
<option value="US-OK">Oklahoma</option>
<option value="US-OR">Oregon</option>
<option value="US-PA">Pennsylvania</option>
<option value="US-RI">Rhode Island</option>
<option value="US-SC">South Carolina</option>
<option value="US-SD">South Dakota</option>
<option value="US-TN">Tennessee</option>
<option value="US-TX">Texas</option>
<option value="US-UT">Utah</option>
<option value="US-VT">Vermont</option>
<option value="US-VA">Virginia</option>
<option value="US-WA">Washington</option>
<option value="US-WV">West Virginia</option>
<option value="US-WI">Wisconsin</option>
<option value="US-WY">Wyoming</option>
</select>
<br>
City:<br>
<input type="text" name="city">
<br><br>
<input type="submit" value="Submit">
</form>