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;
    }