public static function get_city_list_by_zip($zip) { $records = array(); $sql = "SELECT prime_zip, city_name FROM ref_city WHERE zip='{$zip}' ORDER BY city_name, zip"; $pre_data = db()->Get_Table($sql); if (!empty($pre_data)) { foreach ($pre_data as $pre_row) { $prime_zip = $pre_row['prime_zip']; $city_name = $pre_row['city_name']; $sql = "SELECT city_id FROM ref_city WHERE zip='{$prime_zip}' AND city_name='{$city_name}'"; $data = db()->Get_Table($sql); if (!empty($data)) { foreach ($data as $row) { $record = new City($row['city_id']); $record->retrieve_record($row['city_id']); $records[] = array('key' => $record->id(), 'value' => $record->city_name(), 'county_id' => $record->county_id(), 'state_id' => $record->state_id()); } } } } return $records; }
public function getCityId() { return $this->city->id(); }