Loading XML from PHP errors: Microsoft.XMLHTTP.DocumentElement null

Question

I'm trying to place markers on a google map based on values filed in a mysql db. When loading the xml dynamically using PHP, no markers get placed on the map due to the responseXML.DocumentElement property not getting valued. It works when I load the XML from a static file, just not when dynamically loading from a db.

Here is the page that doesn't work: http://www.thirstygolfer.com/utils/maptest2.html
Here is the page that works: http://www.thirstygolfer.com/utils/maptest1.html

This is the PHP file generating the xml: www.thirstygolfer.com/utils/xmldump3.php

Here is the PHP code from thirstygolfer.com/utils/xmldump3.php (minus the db connection info):

<?php

$dom = new DOMDocument("1.0");
$node = $dom->createElement("markers");
$parnode = $dom->appendChild($node); 

$result=mysql_query("SELECT * FROM Main WHERE State='MA' and FirstLetter='A'");

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

while ($row = mysql_fetch_assoc($result)){    

$node = $dom->createElement("marker");   
$newnode = $parnode->appendChild($node);     
$newnode->setAttribute("id",$row['id']);  
$newnode->setAttribute("lat", $row['Lat']);    
$newnode->setAttribute("lng", $row['Lon']);    
} 

echo $dom->saveXML();

?>

Please help!!

IMSoP · Accepted Answer · 2013-01-11 18:36:25Z

1

Your generated XML contains blank lines at the top of the output, which will make it invalid XML. This is likely because you have empty lines in included PHP files either before the first <?php or after the last ?>

You may also need to set header('Content-Type: text/xml') so that browsers know what kind of data it is.

answered Jan 11, 2013 at 18:36

IMSoP

99.8k18 gold badges135 silver badges183 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1970475 Over a year ago

Thank you! I did not notice that because it was working in IE fine. When I tried it in Chrome and FF it did not work due to the blank lines. I've removed them and now it loads properly.

geocodezip · Accepted Answer · 2013-01-11 18:42:09Z

0

The headers on the XML are not correct (from web-sniffer.net)

HTTP Response Header
Name    Value   Delim
Status: HTTP/1.1 200 OK
Date:   Fri, 11 Jan 2013 18:38:04 GMT   
P3P:    policyref="http://info.yahoo.com/w3c/p3p.xml", CP="CAO DSP COR CUR ADM DEV TAI PSA PSD IVAi IVDi CONi TELo OTPi OUR DELi SAMi OTRi UNRi PUBi IND PHY ONL UNI PUR FIN COM NAV INT DEM CNT STA POL HEA PRE LOC GOV"   
Content-Type:   text/html   
Age:    0   
Connection: close   
Server: YTS/1.19.11:

The Content-Type needs to be "text/xml"

answered Jan 11, 2013 at 18:42

geocodezip

162k14 gold badges228 silver badges257 bronze badges

1 Comment

user1970475 Over a year ago

Thank you!! I added header("Content-type: text/xml"); and that worked.

user1970475 · Accepted Answer · 2013-01-13 15:23:33Z

0

This issue is resolved. Thank you for your help. There were 2 issues with my code:

1.) The content type was 'text/html'. I needed to add the following line to my php script:

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

2.) The xml file had blank lines at the top. IE handled it, but Chrome and FF had issues with it. I removed the extra lines at the top of the file and it now works in all browsers.

answered Jan 13, 2013 at 15:23

user1970475

31 bronze badge

1 Comment

IMSoP Over a year ago

This appears to be much what I said in my answer; is there a reason why you created a new answer rather than "accepting" mine?

Collectives™ on Stack Overflow

Loading XML from PHP errors: Microsoft.XMLHTTP.DocumentElement null

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related