Ejemplo n.º 1
0
function getFlightInfo($FID)
{
    $connection = initDB();
    $query;
    if ($FID == 0) {
        $query = "SELECT * FROM Flights";
    } else {
        $query = "SELECT * FROM Flights WHERE FID='" . $FID . "'";
    }
    $result = mysql_query($query);
    // or die ("Query Failed ".mysql_error());
    $flightData;
    $flightID = 0;
    while ($row = mysql_fetch_array($result)) {
        $FID = $row['FID'];
        $FName = $row['FName'];
        $SourceSID = $row['SourceSID'];
        $DestSID = $row['DestSID'];
        $query2 = "SELECT * FROM Sectors WHERE SID='" . $SourceSID . "'";
        $result2 = mysql_query($query2);
        //or die ("Query Failed ".mysql_error());
        $row2 = mysql_fetch_array($result2);
        $source = $row2['Sector'];
        $query3 = "SELECT * FROM Sectors WHERE SID='" . $DestSID . "'";
        $result3 = mysql_query($query3);
        //or die ("Query Failed ".mysql_error());
        $row3 = mysql_fetch_array($result3);
        $dest = $row3['Sector'];
        //Build the Flight object
        $flight = new Flight();
        $flight->set_FID($FID);
        $flight->set_FName($FName);
        $flight->set_source($source);
        $flight->set_dest($dest);
        //Build the Flight object array
        $flightData[$flightID] = $flight;
        $flightID = $flightID + 1;
    }
    closeDB($connection);
    return $flightData;
}