Function Reference: geodir_get_region_on_map

Summary

Get region on map.

Global Values

$wpdb
(object) (required) WordPress Database object.

Default: None

Package

GeoDirectory_Location_Manager

Change Log

Since: 1.0.0

Source File

geodir_get_region_on_map() is located in geodir_location_manager/geodir_location_functions.php [Line: 876]

Source Code

function geodir_get_region_on_map()
{

	global $wpdb;

	if(isset($_REQUEST['country']) && $_REQUEST['country'] != '' && isset($_REQUEST['city']) && $_REQUEST['city'] != ''){

		$region = $wpdb->get_var(
			$wpdb->prepare(
				"SELECT region FROM ".POST_LOCATION_TABLE." WHERE country=%s AND city=%s",
				array($_REQUEST['country'],$_REQUEST['city'])
			)
		);

		if(!$region)
			$region = $_REQUEST['state'];

		echo $region;
	}
	exit;
}