Function Reference: geodir_city_info_by_slug
Summary
Get location city information using location slug.
Global Values
- $wpdb
- (object) (required) WordPress Database object.
- Default: None
Package
GeoDirectory_Location_Manager
Parameters
- $slug
- (string) (required) Location slug.
- Default: None
- $country_slug
- (string) (required) Country slug.
- Default: None
- $region_slug
- (string) (required) Region slug.
- Default: None
Return Values
- (mixed|null)
Change Log
Since: 1.0.0
Source File
geodir_city_info_by_slug() is located in geodir_location_manager/geodir_location_functions.php [Line: 838]
Source Code
function geodir_city_info_by_slug($slug, $country_slug='', $region_slug='') { global $wpdb; if ($slug=='') { return NULL; } $whereVal = array(); $whereField = 'city_slug=%s'; $whereVal[] = $slug; if ($country_slug!='') { $whereField .= ' AND country_slug=%s'; $whereVal[] = $country_slug; } if ($region_slug!='') { $whereField .= ' AND region_slug=%s'; $whereVal[] = $region_slug; } $row = $wpdb->get_row( $wpdb->prepare( "SELECT location_id, country_slug, region_slug, city_slug, country, region, city, city_meta, city_desc FROM ".POST_LOCATION_TABLE." WHERE ".$whereField." ORDER BY location_id LIMIT 1", $whereVal ) ); if (is_object($row)) { return $row; } return NULL; }