function location_get_postalcode_data_ca in Location 7.4

Same name and namespace in other branches

1. 5.3 supported/location.ca.inc \location_get_postalcode_data_ca()
2. 5 supported/location.ca.inc \location_get_postalcode_data_ca()
3. 6.3 supported/location.ca.inc \location_get_postalcode_data_ca()
4. 7.5 supported/location.ca.inc \location_get_postalcode_data_ca()
5. 7.3 supported/location.ca.inc \location_get_postalcode_data_ca()

Returns a lat/lon pair of the approximate center of the given postal code in the given country

Parameters

$location: An associative array $location where only postal code and country are necessary, but can have the keys: 'street' => the street portion of the location 'supplemental' => additional street portion of the location 'province' => the province, state, or territory 'country' => lower-cased two-letter ISO code (REQUIRED) 'postal_code' => the international postal code for this location (REQUIRED)

Return value

An associative array where 'lat' => approximate latitude of the center of the postal code's area 'lon' => approximate longitude of the center of the postal code's area 'city' => the city 'province' => the province, state, or territory 'country' => lower-cased two-letter ISO code

File

supported/location.ca.inc, line 93

Code

function location_get_postalcode_data_ca($location = array()) {

  // Now we pad the thing and query.
  $result = db_query("SELECT * FROM {zipcodes} where country = :country AND zip = :zip", array(
    ':country' => $location['country'],
    ':zip' => $location['postal_code'],
  ));
  if (($row = $result
    ->fetchObject()) !== FALSE) {
    return array(
      'lat' => $row->latitude,
      'lon' => $row->longitude,
      'city' => $row->city,
      'province' => $row->state,
      'country' => $row->country,
    );
  }
  else {
    return NULL;
  }
}