// Starten der Session session_start($PHPSESSID); // Fehlermeldungen abschalten // error_reporting (0); // Verbindung zum internen Web-Server require ("../admin/install/connect.inc"); $db = mysql_connect("$connect_server","$connect_user","$connect_pass"); mysql_select_db("$connect_datenbank",$db); ?>
$heute=date("Y-m-d"); $subresult=mysql_query("select * FROM worps_adresse WHERE Strasse!='' AND TeufelsmoorApp='1' AND Lat='' AND cleared != '1'"); $found=mysql_num_rows($subresult); while($zeile=mysql_fetch_array($subresult)) { $id=$zeile["id"]; $ort=$zeile["Ort"]; $str=$zeile["Strasse"]; $plz=$zeile["Plz"]; $land=$zeile["Land"]; IF (!$plz) {$plz="27726";} IF (!$ort) {$ort="Worpswede";} $trans = array( "ö" => "oe", "ä" => "ae", "ü" => "ue", "Ö" => "Oe", "Ä" => "Ae", "Ü" => "Ue", " " => "+", "ß" => "ss", ); $ort=strtr("$ort", $trans); $str=strtr("$str", $trans); IF (!$land) {$land="DE";} IF ($ort OR $plz) { IF ($plz AND !$ort) {$suchstr="$str $plz,$land";} IF ($ort) {$suchstr="$str $ort,$land"; $writeLatLng="yes";} $suchstr=urlencode($suchstr); $file="http://maps.google.com/maps/api/geocode/xml?address=$suchstr&sensor=true"; $xml_parser = xml_parser_create(); if (!($fp = fopen($file, "r"))) { die("could not open XML input"); } $data = fread($fp, 4024); fclose($fp); xml_parse_into_struct($xml_parser, $data, $vals, $index); xml_parser_free($xml_parser); $params = array(); $level = array(); foreach ($vals as $xml_elem) { if ($xml_elem['type'] == 'open') { if (array_key_exists('attributes',$xml_elem)) { list($level[$xml_elem['level']],$extra) = array_values($xml_elem['attributes']); } else { $level[$xml_elem['level']] = $xml_elem['tag']; } } if ($xml_elem['type'] == 'complete') { $start_level = 1; $php_stmt = '$params'; while($start_level < $xml_elem['level']) { $php_stmt .= '[$level['.$start_level.']]'; $start_level++; } $php_stmt .= '[$xml_elem[\'tag\']] = $xml_elem[\'value\'];'; eval($php_stmt); } } // echo ""; // print_r ($params); // echo ""; $Lat=$params[GEOCODERESPONSE][RESULT][GEOMETRY][LOCATION][LAT]; $Lng=$params[GEOCODERESPONSE][RESULT][GEOMETRY][LOCATION][LNG]; $adress=$params[GEOCODERESPONSE][RESULT][FORMATTED_ADDRESS]; // ECHO "$file