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; } }
$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();