airspace-data.php

   1 <?php
   2 require_once('require/class.Connection.php');
   3 require_once('require/class.Language.php');
   4 require_once('require/class.NOTAM.php');
   5 ?>
   6 <div class="alldetails">
   7 <button type="button" class="close">&times;</button>
   8 <?php
   9
  10 $airspaceid = filter_input(INPUT_GET,'airspace',FILTER_SANITIZE_NUMBER_INT);
  11 //$notamref = urldecode($notamref);
  12 if ($globalDBdriver == 'mysql') {
  13         $query = "SELECT * FROM airspace WHERE ogr_fid = :id";
  14 } else {
  15         $query = "SELECT * FROM airspace WHERE ogc_fid = :id";
  16 }
  17 $Connection = new Connection();
  18 try {
  19         $sth = $Connection->db->prepare($query);
  20         $sth->execute(array(':id' => $airspaceid));
  21 } catch(PDOException $e) {
  22         echo "error";
  23 }
  24 $result=$sth->fetchAll(PDO::FETCH_ASSOC);
  25 $airspace = $result[0];
  26 date_default_timezone_set('UTC');
  27 print '<div class="top">';
  28 if (isset($airspace['name'])) $airspace['title'] = $airspace['name'];
  29 print '<div class="right"><div class="callsign-details"><div class="callsign">'.$airspace['title'].'</a></div>';
  30 print '</div>';
  31 print '<div class="details">';
  32
  33 if (isset($airspace['type'])) {
  34         print '<div>';
  35         print '<span>'._("Type").'</span>';
  36         print $airspace['type'];
  37         print '</div>';
  38 }
  39
  40 if ($airspace['class'] != '') {
  41         print '<div>';
  42         print '<span>'._("Class").'</span>';
  43         print $airspace['class'];
  44         print '</div>';
  45 }
  46
  47 if (isset($airspace['ceiling'])) $airspace['tops'] = $airspace['ceiling'];
  48 print '<div>';
  49 print '<span>'._("Tops").'</span>';
  50 print $airspace['tops'];
  51 print '</div>';
  52
  53 if (isset($airspace['floor'])) $airspace['base'] = $airspace['floor'];
  54 print '<div>';
  55 print '<span>'._("Base").'</span>';
  56 print $airspace['base'];
  57 print '</div>';
  58 print '</div>';
  59 /*
  60 print '<div class="notamtext">';
  61 print '<span>'._("Text").'</span>';
  62 print $notam['notam_text'];
  63 print '</div>';
  64 */
  65 print '</div>';
  66 ?>
  67 </div>