Google geocode via json, save result in mysql database?

[Sovettub]

How can I geocode an address and save that result in a mysql database using json?As of March 8th I can no longer find the Google documentation on how to do this.This is what I had previously but I've now been forced to update. All it was doing was inserting some data from Wordpress, inserting that into a new table then the geocoder would look for any addresses that haven't been geocoded and update the table.How can I do the same but with json?\[code\]<?php require("database.php");// Opens a connection to a MySQL server$con = mysql_connect("localhost", $username, $password);if (!$con){ die('Could not connect: ' . mysql_error());}mysql_select_db("medicom_wp", $con); $company = get_the_title(); $address = get_field('address_line_1'); $city = get_field('town_/_city'); $post_code = get_field('post_code'); $link = get_permalink(); $type = get_field('kind_of_organisation'); $sql = sprintf("select count('x') as cnt from markers where `name` = '%s'", mysql_real_escape_string($company)); $row_dup = mysql_fetch_assoc(mysql_query($sql,$con)); if ($row_dup['cnt'] == 0) { mysql_query("INSERT INTO markers (`name`, `address`, `lat`, `lng`, `type`, `link`) VALUES ('".$company."', '".$address.", ".$city.", ".$post_code."', '0.0', '0.0', '".$type."', '".$link."')");}wp_reset_query();define("MAPS_HOST", "maps.google.com");define("KEY", "(my key)");// Opens a connection to a MySQL server$connection = mysql_connect("localhost", $username, $password);if (!$connection) { die("Not connected : " . mysql_error());}// Set the active MySQL database$db_selected = mysql_select_db($database, $connection);if (!$db_selected) { die("Can\'t use db : " . mysql_error());}// Select all the rows in the markers table$query = "SELECT * FROM markers WHERE 1";$result = mysql_query($query);if (!$result) { die("Invalid query: " . mysql_error());}// Initialize delay in geocode speed$delay = 0;$base_url = "http://" . MAPS_HOST . "/maps/geo?output=xml" . "&Key=" . KEY;// Iterate through the rows, geocoding each addresswhile ($row = @mysql_fetch_assoc($result)) { $geocode_pending = true; while ($geocode_pending) { $address = $row["address"]; $id = $row["id"]; $request_url = $base_url . "&q=" . urlencode($address); $xml = simplexml_load_file($request_url) or die("url not loading"); $status = $xml->Response->Status->code; if (strcmp($status, "200") == 0) { // Successful geocode $geocode_pending = false; $coordinates = $xml->Response->Placemark->Point->coordinates; $coordinatesSplit = split(",", $coordinates); // Format: Longitude, Latitude, Altitude $lat = $coordinatesSplit[1]; $lng = $coordinatesSplit[0]; $query = sprintf("UPDATE markers " . " SET lat = '%s', lng = '%s' " . " WHERE id = '%s' LIMIT 1;", mysql_real_escape_string($lat), mysql_real_escape_string($lng), mysql_real_escape_string($id)); $update_result = mysql_query($query); if (!$update_result) { die("Invalid query: " . mysql_error()); } } else if (strcmp($status, "620") == 0) { // sent geocodes too fast $delay += 1000; } else { // failure to geocode $geocode_pending = false; echo "Address " . $address . " failed to geocoded. "; echo "Received status " . $status . "\n"; } usleep($delay); }}?>\[/code\]