I tried that. It still didnt work. Still get the same error On Aug 26, 5:37 pm, Grok Lobster <[email protected]> wrote: > This file -http://www.rith.ca/LABS/maps/phpsqlajax_genxml.php- that > you call in downloadUrl > > returns data of the form > > connected to db > db selected > 1 | Pan Africa Market | 1521 1st Ave, Seattle, WA | 47.608940 | > -122.340141 | restaurant > 2 | Buddha Thai & Bar | 2222 2nd Ave, Seattle, WA | 47.613590 | > -122.344391 | bar > 3 | The Melting Pot | 14 Mercer St, Seattle, WA | 47.624561 | > -122.356445 | restaurant > 4 | Ipanema Grill | 1225 1st Ave, Seattle, WA | 47.606365 | > -122.337654 | restaurant > 5 | Sake House | 2230 1st Ave, Seattle, WA | 47.612823 | -122.345673 | > bar > 6 | Crab Pot | 1301 Alaskan Way, Seattle, WA | 47.605961 | -122.340363 > | restaurant > 7 | Mama's Mexican Kitchen | 2234 2nd Ave, Seattle, WA | 47.613976 | > -122.345467 | bar > 8 | Wingdome | 1416 E Olive Way, Seattle, WA | 47.617214 | -122.326584 > | bar > 9 | Piroshky Piroshky | 1908 Pike pl, Seattle, WA | 47.610126 | > -122.342834 | restaurant > > which won't work with the rest of the script. > Change the above referenced file to the xml file that you created > manually. > > On Aug 26, 12:42 pm, Charith <[email protected]> wrote: > > > > > > > > > I am trying to get google maps working with markers from an xml file. > > I found this website (http://code.google.com/apis/maps/articles/ > > phpsqlajax_v3.html) and i followed it to the dot. I got an error > > saying that "request" is not defined so moved the request object > > declaration to the top instead of where it is in that website posted > > above. > > Now i get documentElement is null or not an object error. Anyone have > > any idea what is going on? everything seems to be good. well, looks > > good for me at least. What is it that I am missing and doing wrong? > > > Demo:http://www.rith.ca/LABS/maps/map.html > > > --------------------------------------------------------------------------- > > -------------------------- > > map.html code > > --------------------------------------------------------------------------- > > -------------------------- > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> > > <html> > > <head> > > <meta name="viewport" content="initial-scale=1.0, user- > > scalable=no" /> > > <meta http-equiv="content-type" content="text/html; charset=UTF-8"/ > > > <title>PHP/MySQL & Google Maps Example</title> > > <script type="text/javascript" src="http://maps.google.com/maps/ > > api/js?sensor=false"></script> > > <script type="text/javascript"> > > //<![CDATA[ > > > var request = window.ActiveXObject ? > > new ActiveXObject('Microsoft.XMLHTTP') : > > new XMLHttpRequest; > > > var customIcons = { > > restaurant: { > > icon: 'http://labs.google.com/ridefinder/images/ > > mm_20_blue.png', > > shadow: 'http://labs.google.com/ridefinder/images/ > > mm_20_shadow.png' > > }, > > bar: { > > icon: 'http://labs.google.com/ridefinder/images/ > > mm_20_red.png', > > shadow: 'http://labs.google.com/ridefinder/images/ > > mm_20_shadow.png' > > } > > }; > > > function load() { > > var map = new google.maps.Map(document.getElementById('map'), { > > center: new google.maps.LatLng(47.6145, -122.3418), > > zoom: 13, > > mapTypeId: 'roadmap' > > }); > > var infoWindow = new google.maps.InfoWindow; > > if(null == infoWindow) { alert("Object InfoWindow Null"); } > > > // Change this depending on the name of your PHP file > > downloadUrl("phpsqlajax_genxml.php", function(data) { > > var xml = request.responseXML; > > if(null == xml) { alert("Object xml Null"); } > > > 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 google.maps.LatLng( > > parseFloat(markers[i].getAttribute('lat')), > > parseFloat(markers[i].getAttribute('lng'))); > > var html = "" + name + " " + address; > > var icon = customIcons[type] || {}; > > var marker = new google.maps.Marker({ > > map: map, > > position: point, > > icon: icon.icon, > > shadow: icon.shadow > > }); > > bindInfoWindow(marker, map, infoWindow, html); > > } > > }); > > } > > > function bindInfoWindow(marker, map, infoWindow, html) { > > google.maps.event.addListener(marker, 'click', function() { > > infoWindow.setContent(html); > > infoWindow.open(map, marker); > > }); > > } > > > function downloadUrl(url, callback) { > > request.onreadystatechange = function() { > > if (request.readyState == 4) { > > request.onreadystatechange = doNothing; > > callback(request, request.status); > > } > > }; > > > request.open('GET', url, true); > > request.send(null); > > } > > > function doNothing() {} > > > //]]> > > > </script> > > > </head> > > > <body onload="load()"> > > <div id="map" style="width: 500px; height: 300px"></div> > > </body> > > > </html> > > > --------------------------------------------------------------------------- > > -------------------------- > > phpsqlajax_genxml.php code > > --------------------------------------------------------------------------- > > -------------------------- > > <?php > > $username="root"; > > $password="**********"; // I use the actual password instead of the > > stars here > > $database="google"; > > > // Start XML file, create parent node > > > $dom = new DOMDocument('1.0', 'iso-8859-1'); > > $node = $dom->createElement("markers"); > > $parnode = $dom->appendChild($node); > > > // Opens a connection to a MySQL server > > > $connection=mysql_connect (localhost, $username, $password); > > if (!$connection) { die('Not connected : ' . mysql_error());} else > > { echo "connected to db<br />"; } > > > // Set the active MySQL database > > > $db_selected = mysql_select_db($database, $connection); > > if (!$db_selected) { > > die ('Can\'t use db : ' . mysql_error());} > > > else { echo "db selected<br />"; } > > > // Select all the rows in the markers table > > > $query = "SELECT * FROM markers"; > > $result = mysql_query($query); > > if (!$result) { > > die('Invalid query: ' . mysql_error()); > > > } > > > //header("Content-type: text/xml"); > > > // Iterate through the rows, adding XML nodes for each > > > while ($row = @mysql_fetch_assoc($result)){ > > echo $row[id] . " | " . $row[name] . " | " . $row[address] . " | " . > > $row[lat] . " | " . $row[lng] . " | " . $row[type] . "<br />"; > > // ADD TO XML DOCUMENT NODE > > $node = $dom->createElement("marker"); > > $newnode = $parnode->appendChild($node); > > $newnode->setAttribute("name",$row['name']); > > $newnode->setAttribute("address", $row['address']); > > $newnode->setAttribute("lat", $row['lat']); > > $newnode->setAttribute("lng", $row['lng']); > > $newnode->setAttribute("type", $row['type']); > > > } > > > echo $dom->saveXML(); > > > ?> > > > --------------------------------------------------------------------------- > > -------------------------- > > phpsqlajax_expectedoutput.xml code > > Above script didnt create the xml file. I manually put in the data > > into this xml file > > --------------------------------------------------------------------------- > > -------------------------- > > <?xml version="1.0" encoding="iso-8859-1"?> > > <markers> > > <marker name="Pan Africa Market" address="1521 1st Ave, Seattle, WA" > > lat="47.608940" lng="-122.340141" type="restaurant"/> > > <marker name="Buddha Thai & Bar" address="2222 2nd Ave, Seattle, WA" > > lat="47.613590" lng="-122.344391" type="bar"/> > > <marker name="The Melting Pot" address="14 Mercer St, Seattle, WA" > > lat="47.624561" lng="-122.356445" type="restaurant"/> > > <marker name="Ipanema Grill" address="1225 1st Ave, Seattle, WA" > > lat="47.606365" lng="-122.337654" type="restaurant"/> > > <marker name="Sake House" address="2230 1st Ave, Seattle, WA" > > lat="47.612823" lng="-122.345673" type="bar"/> > > <marker name="Crab Pot" address="1301 Alaskan Way, Seattle, WA" > > lat="47.605961" lng="-122.340363" type="restaurant"/> > > <marker name="Mama's Mexican Kitchen" address="2234 2nd Ave, Seattle, > > WA" lat="47.613976" lng="-122.345467" type="bar"/> > > <marker name="Wingdome" address="1416 E Olive Way, Seattle, WA" > > lat="47.617214" lng="-122.326584" type="bar"/> > > <marker name="Piroshky Piroshky" address="1908 Pike pl, Seattle, WA" > > lat="47.610126" lng="-122.342834" type="restaurant"/> > > </markers> > > > Thanks everyone for your time
-- You received this message because you are subscribed to the Google Groups "Google Maps JavaScript API v3" 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-js-api-v3?hl=en.
