| FLIGHTPLAN DETAIL

All times and dates are UTC (Zulu) Time.
//Start of PHP code for Flight information extraction
// Set DB parameters - (no user required on localhost)
//include the time conversion functions
include $_SERVER['DOCUMENT_ROOT'].'/inc/dateconv.php';
include $_SERVER['DOCUMENT_ROOT'].'/inc/timeconv.php';
$flight=$_GET['flight'];
$flightdata=mysql_query("SELECT flight, Origin, Dest, OUTCO, DUTCO, EDD, ETD, EDA, ETA, Status, Route, ActDD, ActTD, meals, entertain, gate, Closetime, CP, FO, SO, OICAO, DICAO, IATAfrom, IATAto FROM flight WHERE flight='$flight' ORDER BY flight") or die("Error accessing Flight information $flight");
//now create the table elements
while (list($flight, $Origin, $Dest, $OUTCO, $DUTCO, $EDD, $ETD, $EDA, $ETA, $Status, $Route, $ActDD, $ActTD, $meals, $entertain, $gate, $Closetime, $CP, $FO, $SO, $OICAO, $DICAO, $IATAfrom, $IATAto) = mysql_fetch_row($flightdata))
{
echo "Flight: $flight From: $Origin ($IATAfrom) To: $Dest ($IATAto) ";
echo " ";
echo "======== ======== ======== ======== ======== ======== ======== ======== ";
echo"";
echo"";
list ($utctime, $utcdate) = timeconvert ( $ETD, $EDD, "1100");
echo "| $flight $utcdate | ";
list ($utctime, $utcdate) = timeconvert ( $ETD, $EDD, "1100");
echo "$OICAO/ STD $utctime | ";
list ($utctime, $utcdate) = timeconvert ( $ETD, $EDD, "1100");
echo "ETD $utctime | ";
list ($utctime, $utcdate) = timeconvert ( $ActTD, $ActDD, "1100");
if ($ActDD!="")
{
echo "ATD $utctime | ";
}
else
{
echo "ATD - | ";
}
echo " ";
echo "| B744 VHOJU | ";
list ($utctime, $utcdate) = timeconvert ( $ETA, $EDA, "1100");
echo "$DICAO/ STA $utctime | ";
list ($utctime, $utcdate) = timeconvert ( $ETA, $EDA, "1100");
echo "ETA $utctime | ";
list ($utctime, $utcdate) = timeconvert ( $ActTA, $ActDA, "1100");
if ($ActDA!="")
{
echo "ATA $utctime | ";
}
else
{
echo "ATA - | ";
}
echo " ";
//echo "| VIA $OICAO$DICAO | ";
echo " ";
echo " ";
echo "";
echo "======== ======== ======== ======== ======== ======== ======== ======== ";
echo " ";
echo "CP $CP ";
echo "FO $FO ";
echo "SO $SO ";
echo " ";
echo "ATS ROUTE: ";
echo "$Route ";
echo " ";
echo "INFO / ENTERTAIN: ";
echo "$entertain
";
echo "SERVICE: ";
echo "$meals ";
echo "======== ======== ======== ======== ======== ======== ======== ======== ";
echo "";
}
?>
|
|
|
|