I use this script at least several times a week and it works well.
I've copied and modified it to use with another database and I'm
getting this error:
[i]Fatal error: Call to undefined function: simplexml_load_file() in /
home/hrrei0/public_html/thriftstorecentral/rungeocode.php[/i]
Same server, different database and new populated table named markers.
I'm stumped...
[code]
<?php
include 'config.php';
include 'opendb.php';
define("MAPS_HOST", "maps.google.com");
define("KEY", "ABQ#############");
// Opens a connection to a MySQL server
$conn = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)
or die
('Error connecting to mysql');
mysql_select_db(DB_NAME);
// Select all the rows in the markers table
$query = "SELECT * FROM markers WHERE lat <= '0'";
$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 address
while ($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");
[/code]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Maps API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Google-Maps-API?hl=en
-~----------~----~----~----~------~----~------~--~---
