geocode

gistfile1.txt

	$ssss = $wpdb->get_results("select name, id from wp_cities");
	foreach($ssss as $s){
		$z = file_get_contents("http://maps.googleapis.com/maps/api/geocode/json?address={$s->name}&sensor=false");
		$a = json_decode($z, true);
		$lat = $a['results'][0]['geometry']['location']['lat'];
		$lng = $a['results'][0]['geometry']['location']['lng'];
		$wpdb->update(
			'wp_cities',
			array( 'lat' => $lat, 'lng' => $lng ),
			array( 'id' => $s->id),
			array( '%f', '%f' )
		);
	}