static function _loadAirportRecords()
{
// load airport descriptors in memory
try {
self::$airports = AirportDBAPI::loadAirportCodes();
if (self::$airports == null || count(self::$airports) == 0) {
throw new Exception(__CLASS__ . " : " . __METHOD__ . " : Empty arport codes");
}
} catch (Exception $e) {
echo $e->getMessage();
die;
}
}
// create db query
$tbl = _DBTableNames::$_airportCodes;
$sqlstmt = "SELECT * FROM {$tbl}";
$rs = null;
// fetch the data
if (!($rs = $db->query($sqlstmt))) {
Logger::logMsg(__FILE__, __FUNCTION__, "Error executing query - " + $sqlstmt);
// trigger_error(mysql_error(), E_USER_ERROR);
return NULL;
}
$airportName = $code = null;
for ($airportCodes = null; $row = mysqli_fetch_assoc($rs);) {
// print_r($row);
foreach ($row as $key => $val) {
if (strcmp($key, "code") == 0) {
$code = $val;
} else {
if (strcmp($key, "airport") == 0) {
$airportName = $val;
}
}
}
//$rowEntry = "Code - $code; Name - $airportName";
//Logger::logTxt($rowEntry);
$airportCodes[$code] = $airportName;
}
return $airportCodes;
}
}
$test = new AirportDBAPI();
$test->loadAirportCodes();
