Advertisement
cyberairman2013

result.php

Aug 21st, 2013
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.40 KB | None | 0 0
  1. if (isset($_POST['submitted'])){
  2.     $personalDetails = array('pid' => $_POST['pid'],'fname' => $_POST['fname'],'lname' => $_POST['lname']);
  3.     $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));
  4.     $runway_lengths = array(array('min' => 0,'max' => 2999),array('min' => 3000,'max' => 4999),array('min' => 5000,'max' => 7999),array('min' => 8000,'max' => 30000));
  5.     $originICAO = htmlentities(strip_tags(mysql_real_escape_string(strtoupper($_POST['originAirport']))));
  6.     $ft = $_POST['ft'];
  7.     $query_origin_airport = mysql_query("SELECT `icao`,`lat`,`long` FROM `latlong` WHERE `icao` = '$originICAO'") or die(mysql_error());
  8.     $origin_query_result = mysql_fetch_assoc($query_origin_airport);
  9.     $query_for_distance = mysql_query("SELECT `icao`,`lat`,`long` FROM `latlong`");
  10.     $a = 0;
  11.     while ($dest = mysql_fetch_assoc($query_for_distance)) {
  12.         $dist = distance($origin_query_result['lat'], $origin_query_result['long'], $dest['lat'], $dest['long'], "N");
  13.         if ($dist >= $flight_type[$ft]['min'] && $dist <= $flight_type[$ft]['max']) {
  14.             $airport = $dest['icao']; $new_dist = round($dist, 2);  
  15.        
  16.         $distance_result[$a] = array(
  17.             'airport'   => $airport,
  18.             'dist'      => $new_dist. 'nm'
  19.         );
  20.         $a++;
  21.         }
  22.     }  
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement