atom feed8 messages in com.googlegroups.google-ajax-search-apiRe: Generating multiple geocodes to
FromSent OnAttachments
Gino RoccaMar 23, 2009 5:20 am 
Jeremy GeerdesMar 23, 2009 5:33 am 
Gino RoccaMar 23, 2009 2:00 pm 
Jeremy GeerdesMar 23, 2009 2:03 pm 
webmasterMar 23, 2009 2:18 pm 
Jeremy GeerdesMar 23, 2009 2:24 pm 
webmasterMar 23, 2009 2:32 pm 
webmasterMar 23, 2009 4:28 pm 
Subject:Re: Generating multiple geocodes to
From:webmaster (webm@serate-italiane.dk)
Date:Mar 23, 2009 2:32:17 pm
List:com.googlegroups.google-ajax-search-api

Perfect!

It works now :-)

On 23/03/2009, at 22.24, Jeremy Geerdes wrote:

The last line of your php code is a problem. Specifically, footer.php is throwing your xml off by adding a bunch of closing tags that were never opened.

Jeremy R. Geerdes Effective website design & development Des Moines, IA

For more information or a project quote: http://jgeerdes.home.mchsi.com http://jgeerdes.blogspot.com http://jgeerdes.wordpress.com jgee@mchsi.com

Unless otherwise noted, any price quotes contained within this communication are given in US dollars.

If you're in the Des Moines, IA, area, check out Debra Heights Wesleyan Church!

And check out my blog, Adventures in Web Development, at
http://jgeerdes.blogspot.com !

On Mar 23, 2009, at 4:18 PM, webmaster wrote:

Hello again

you have been very kind to answer my request again. In case you have some time to look at the issue, I am reporting the two files I have intended to reuse from the webpage you suggested to me

http://code.google.com/support/bin/answer.py?answer=65622&topic=11369

Here they are

1) phpsqlajax_map.htm

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd "> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"/> <title>Google Maps AJAX + MySQL/PHP Example</title> <script
src="http://maps.google.com/maps?file=api&v=2&key=ABQIAAAA0swsyppeo4WAJSi_mEUUgBQvZHi5Z2qeqRnpT_zuEAl2yvinaRS4LuhfTCbt1N_bkeKL5EBk04oRsw "

type="text/javascript"></script> <script type="text/javascript"> //<![CDATA[

var iconBlue = new GIcon(); iconBlue.image = 'http://labs.google.com/ridefinder/images/mm_20_blue.png' ; iconBlue.shadow =
'http://labs.google.com/ridefinder/images/mm_20_shadow.png' ; iconBlue.iconSize = new GSize(12, 20); iconBlue.shadowSize = new GSize(22, 20); iconBlue.iconAnchor = new GPoint(6, 20); iconBlue.infoWindowAnchor = new GPoint(5, 1);

var iconRed = new GIcon(); iconRed.image = 'http://labs.google.com/ridefinder/images/mm_20_red.png' ; iconRed.shadow = 'http://labs.google.com/ridefinder/images/mm_20_shadow.png' ; iconRed.iconSize = new GSize(12, 20); iconRed.shadowSize = new GSize(22, 20); iconRed.iconAnchor = new GPoint(6, 20); iconRed.infoWindowAnchor = new GPoint(5, 1);

var customIcons = []; customIcons["restaurant"] = iconBlue; customIcons["bar"] = iconRed;

function load() { if (GBrowserIsCompatible()) { var map = new GMap2(document.getElementById("map")); map.addControl(new GSmallMapControl()); map.addControl(new GMapTypeControl()); map.setCenter(new GLatLng(47.614495, -122.341861), 13);

GDownloadUrl("phpsqlajax_genxml2.php", function(data) { var xml = GXml.parse(data); var markers = xml.documentElement.getElementsByTagName("marker"); for (var i = 0; i < markers.length; i++) { var name = markers[i].getAttribute("name"); var address = markers[i].getAttribute("address"); var type = markers[i].getAttribute("type"); var point = new GLatLng(parseFloat(markers[i].getAttribute("lat")),

parseFloat(markers[i].getAttribute("lng"))); var marker = createMarker(point, name, address, type); map.addOverlay(marker); } }); } }

function createMarker(point, name, address, type) { var marker = new GMarker(point, customIcons[type]); var html = "<b>" + name + "</b> <br/>" + address; GEvent.addListener(marker, 'click', function() { marker.openInfoWindowHtml(html); }); return marker; } //]]> </script> </head>

<body onload="load()" onunload="GUnload()"> <div id="map" style="width: 500px; height: 300px"></div> </body> </html>

2) phpsqlajax_genxml2.php

<? include("connessione.php"); ?>

<? function parseToXML($htmlStr) { $xmlStr=str_replace('<','&lt;',$htmlStr); $xmlStr=str_replace('>','&gt;',$xmlStr); $xmlStr=str_replace('"','&quot;',$xmlStr); $xmlStr=str_replace("'",'&#39;',$xmlStr); $xmlStr=str_replace("&",'&amp;',$xmlStr); return $xmlStr; }

// Select all the rows in the markers table $query = "SELECT * FROM maps_markers WHERE 1"; $result = mysql_query($query); if (!$result) { die('Invalid query: ' . mysql_error()); }

//header("Content-type: text/xml");

// Start XML file, echo parent node echo '<markers>';

// Iterate through the rows, printing XML nodes for each while ($row = @mysql_fetch_assoc($result)){ // ADD TO XML DOCUMENT NODE echo '<marker '; echo 'name="' . parseToXML($row['name']) . '" '; echo 'address="' . parseToXML($row['address']) . '" '; echo 'lat="' . $row['lat'] . '" '; echo 'lng="' . $row['lng'] . '" '; echo 'type="' . $row['type'] . '" '; echo '/>'; }

// End XML file echo '</markers>';

?> <? include ("footer.php"); ?>

You can see the result here:

http://serate-italiane.dk/phpsqlajax_map.htm

On 23/03/2009, at 22.03, Jeremy Geerdes wrote:

Unfortunately, it's impossible to tell what the problem may be judging solely by the description you have provided. At the very least, I will need to see a link to the script so I can see it's output; it is also quite possible that I'll need to see actual code.

Jeremy R. Geerdes Effective website design & development Des Moines, IA

For more information or a project quote: http://jgeerdes.home.mchsi.com http://jgeerdes.blogspot.com http://jgeerdes.wordpress.com jgee@mchsi.com

Unless otherwise noted, any price quotes contained within this communication are given in US dollars.

If you're in the Des Moines, IA, area, check out Debra Heights Wesleyan Church!

And check out my blog, Adventures in Web Development, at
http://jgeerdes.blogspot.com !

On Mar 23, 2009, at 4:00 PM, Gino Rocca wrote:

Hello jeremy,

I had a look at the very informative tutorial below http://code.google.com/support/bin/answer.py?answer=65622&topic=11369#outputxml

Howver I am blocked at the step "Checking that XML output works"

I cannot output the xml file, even though data are present in my database and I do not seem to get errors.

Any hints on how I could proceed or debug?

Thanks for the help

On Mar 23, 1:33 pm, Jeremy Geerdes <jrge@gmail.com> wrote:

Check out this page on the Google Maps Group:

http://groups.google.com/group/Google-Maps-API/web/using- databases- wi...

Jeremy R. Geerdes Effective website design & development Des Moines, IA

For more information or a project quote:http://jgeerdes.home.mchsi.comhttp ://jgeerdes.blogspot.comhttp://jgeerdes.wordpress.com jgee@mchsi.com

Unless otherwise noted, any price quotes contained within this communication are given in US dollars.

If you're in the Des Moines, IA, area, check out Debra Heights Wesleyan Church!

And check out my blog, Adventures in Web Development,
athttp://jgeerdes.blogspot.com !

On Mar 23, 2009, at 7:20 AM, Gino Rocca wrote:

For my no-profit community webpage

I would like to generate gocodes and visualize an overaly of markers on a google map, based on some data (adress: street, br, city name) on my database.

Any hints on how to do that?

example:

starting from following data whcih I can retrieve through php/ mysql interaction

copenhagen, Saxogade 5 Odense, Vestergade 3

etc.

I would like to generate a googlemap with a 2 markers corrsponding to the two locations.

As second task, I would lilke to be able to click on the markers and open a window with more detailed information about the events in Copenhagen and Odense.