Databases
StackOverflow2013
Postsdbo
POIE8 and reading XML via AJAX
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIE8 and reading XML via AJAX
    primarykey
    data
    text
    <p>I have a store locator, built using Google Maps, PHP/Mysql and jQuery here: <a href="http://tinyurl.com/4w8nwwp" rel="nofollow">http://tinyurl.com/4w8nwwp</a></p> <p>Everything is dandy in FF, Safari,Chrome and Opera. IE7, 8 cannot read the XML that is dynamically generated by <code>parse_location.php</code></p> <p>The AJAX code:</p> <pre><code>function reloadMap(map, dataString) { markersArray = []; var infoWindow = new google.maps.InfoWindow({content: "loading...", maxWidth:100}); var storeListHtml = '&lt;h2&gt;Name &lt;span style="margin-left:252px;"&gt;Address&lt;/span&gt;&lt;/h2&gt;&lt;ul&gt;'; $.ajax({ type: "GET", url: "parse_location.php", data: dataString, success: function(text){ count = -1; $(text).find("list").each(function() { count++; if(count == 0) { var burnsvilleMN = new google.maps.LatLng($(this).attr("lat"),$(this).attr("lng")); map.panTo(burnsvilleMN); } var store = [$(this).attr("name"), $(this).attr("address"), $(this).attr("lat"), $(this).attr("lng"), count]; var name = $(this).attr("name"); var address = $(this).attr("address"); var point = new google.maps.LatLng($(this).attr("lat"),$(this).attr("lng")); var html = "&lt;span class='info'&gt;&lt;b&gt;" + name + "&lt;/b&gt; &lt;br/&gt;" + address + "&lt;/span&gt;"; var image = new google.maps.MarkerImage('images/icon_dot2.png'); var shadow = new google.maps.MarkerImage('images/icon_dot_shadow.png'); var marker = new google.maps.Marker({ map: map, position: point, icon: image, shadow:shadow //shadow: icon.shadow }); //markersArray.push(marker); storeListHtml += "&lt;li class='store'&gt;&lt;a href='javascript:myclick("+count+")'&gt;&lt;div class='store-name'&gt;"+name+"&lt;/div&gt;&lt;div class='store-add'&gt; "+address+"&lt;/div&gt;&lt;/a&gt;&lt;/li&gt;"; bindInfoWindow(marker, map, infoWindow, html); }); storeListHtml += '&lt;/ul&gt;'; $("#store-list").html(storeListHtml); } }); </code></pre> <p>}</p> <p>As you can see, this involves calling parse_location.php, getting the XML generated by this code: // uncommenting the following line causes ff, safari et al to not show anything. // header('Content-Type: text/xml; charset=UTF-8');</p> <pre><code>$responce = "&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?&gt;\n"; $responce .= "&lt;location&gt;\n"; $city = $_GET['city']; $category = $_GET['category']; </code></pre> <p>[SQL Query here ] </p> <pre><code>$result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $responce .= "&lt;list name=\"".$row["name"]."\" address=\"".$row["street_address"]." ".$row["city"]." ".$row["state"].", ".$row["zip"]."\" lat=\"".$row["lat"]."\" lng=\"".$row["lng"]."\" /&gt;"; } $responce .= "&lt;/location&gt;"; $responce8 = utf8_encode($responce); echo $responce8; </code></pre> <p>Any pointers???</p> <p>Rishi</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBlender
    1. USfrishi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYou should add a blank line before and after your code snippets to ensure they get properly formatted. Besides that: have you tried opening the script's URL directly through IE's address bar? It'd help a lot to know whether the issue is about the content, or the xhr request itself.
      singulars
      1. POIE8 and reading XML via AJAX
      1. USEdurne Pascual
    2. COhey herenvardo, thanks for the tips, I will definitely format code better, this is my first time posting code in a question. That said, I tried running parse_location.php directly, and I just output user agent on that page. don't really know what to make out of it.
      singulars
      1. POIE8 and reading XML via AJAX
      1. USfrishi
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload