Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (isset($_POST['submitted'])){
- $personalDetails = array('pid' => $_POST['pid'],'fname' => $_POST['fname'],'lname' => $_POST['lname']);
- $flight_type = array(array('min' => 1.00, 'max' => 99.99), array('min' => 100.00, 'max' => 349.99), array('min' => 350.00, 'max' => 399.99), array('min' => 400.00, 'max' => 899.99), array('min' => 900.00, 'max' => 1249.99), array('min' => 1250.00, 'max' => 3000.00));
- $runway_lengths = array(array('min' => 0,'max' => 2999),array('min' => 3000,'max' => 4999),array('min' => 5000,'max' => 7999),array('min' => 8000,'max' => 30000));
- $originICAO = htmlentities(strip_tags(mysql_real_escape_string(strtoupper($_POST['originAirport']))));
- $ft = $_POST['ft'];
- $query_origin_airport = mysql_query("SELECT `icao`,`lat`,`long` FROM `latlong` WHERE `icao` = '$originICAO'") or die(mysql_error());
- $origin_query_result = mysql_fetch_assoc($query_origin_airport);
- $query_for_distance = mysql_query("SELECT `icao`,`lat`,`long` FROM `latlong`");
- $a = 0;
- while ($dest = mysql_fetch_assoc($query_for_distance)) {
- $dist = distance($origin_query_result['lat'], $origin_query_result['long'], $dest['lat'], $dest['long'], "N");
- if ($dist >= $flight_type[$ft]['min'] && $dist <= $flight_type[$ft]['max']) {
- $airport = $dest['icao']; $new_dist = round($dist, 2);
- $distance_result[$a] = array(
- 'airport' => $airport,
- 'dist' => $new_dist. 'nm'
- );
- $a++;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement