Error on line 2 at column 1 Extra content at the end of the document

Question

When I use the below code and parse the xml locally it works fine but when upload the same script at the server it shows error    Note  I retrieved the  lng and  lat from the query string and it works fine locally    lng   GET  lng     lat   GET  lat     conn new LoginSystem     conn- gt connect     dom   new DOMDocument  1 0      query  select catch id catch details image from mycatch where longitude   lng  AND latitude   lat     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       node    dom- gt createElement  mycatch       node    dom- gt appendChild  node   foreach   row as  fieldname   gt   fieldvalue           child    dom- gt createElement  fieldname        child    node- gt appendChild  child        value    dom- gt createTextNode  fieldvalue        value    child- gt appendChild  value           conn- gt disconnect     xml string    dom- gt saveXML    echo  xml string    On the server it throws this error  And the document is also empty          This page contains the following errors    error on line 2 at column 1  Extra content at the end of the document   Below is a rendering of the page up to the first error

User · Answer

The problem is database connection string  one of your MySQL database connection function parameter is not correct  so there is an error message in the browser output  Just right click output webpage and view html source code you will see error line followed by correct XML output data file   I had same problem and the above solution worked perfectly

User · Answer

On each loop of the result set  you re appending a new root element to the document  creating an XML document like this    lt  xml version  1 0   gt   lt mycatch gt     lt  mycatch gt   lt mycatch gt     lt  mycatch gt        An XML document can only have one root element  which is why the error is stating there is  extra content    Create a single root element and add all the mycatch elements to that    root    dom- gt createElement  root     dom- gt appendChild  root          while   row    mysql fetch assoc  result       node    dom- gt createElement  mycatch       root- gt appendChild  node

User · Answer

I think you are creating a document that looks like this    lt mycatch gt            lt  mycatch gt   lt mycatch gt            lt  mycatch gt    This is not a valid XML document as it has more than one root element   You must have a single top-level element  as in   lt mydocument gt           lt mycatch gt                lt  mycatch gt     lt mycatch gt                lt  mycatch gt          lt  mydocument gt

User · Answer

You might have output  maybe error debug output  that precedes your call to  header  Content-type  text xml      Therefore  the content being delivered to the browser is not  xml     that s what the error message is trying to tell you  at least that was the case for me and I had the same error message as you ve described

[php] Error on line 2 at column 1: Extra content at the end of the document

Examples related to php

Examples related to xml