本文整理汇总了PHP中Flight::set_FID方法的典型用法代码示例。如果您正苦于以下问题:PHP Flight::set_FID方法的具体用法?PHP Flight::set_FID怎么用?PHP Flight::set_FID使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Flight
的用法示例。
在下文中一共展示了Flight::set_FID方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getFlightInfo
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;
}