<?php
$ip_db='localhost';
$db_name='nazwa';
$db_user='user';
$db_pass='haslo';
$api_key = 'klucz google';
$conn = mysql_connect($ip_db, $db_user, $db_pass);
if (!$conn) {
	die("Could not connect: ". mysql_error());
}
if (!mysql_select_db($db_name, $conn)) {
	die("Could select db: ". mysql_error());
}

$query = "SELECT id,location FROM `nodes` WHERE `longitude` IS NULL AND `latitude` IS NULL AND location IS NOT NULL AND location_house IS NOT NULL AND location !='' AND location_house !=''";
mysql_query("SET character_set_results = 'utf8'");
$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {

	$address = urlencode($row["location"]." Poland");

	$link = "http://maps.google.com/maps/geo?q=".$address."&key=".$api_key."&sensor=false&output=csv&oe=utf8";
	$page = file_get_contents($link);

	list($status, $accuracy, $latitude, $longitude) = explode(",", $page);


	if (($status == 200) and ($accuracy>=4)) {
		$query_edit = "update nodes set latitude = '".$latitude."', longitude = '".$longitude."' where id = '".$row["id"]."'";
		$result_edit = mysql_query($query_edit);
		echo $row["id"]." - OK<br />";
	} else {
		echo $row["id"]." - ERROR<br />";
	}
	sleep(3);
}

mysql_close($conn);
?>