Generating XML Dynamically in PHP - Parsing Error

Question

I am generating xml file dynamically and getting error when i include newstext. Error: XML Parsing Error: undefined entity ! ERROR
By remove newstext xml generates perfectly. Here is the code i am using.

$sqlNews    =   "SELECT * FROM news";

$runSqlNews =   mysql_query($sqlNews);

while ($rowSqlNews  =   mysql_fetch_array($runSqlNews)) 
    $arrSqlNews[]   =   $rowSqlNews;


    header('Content-type: text/xml');
    header('Pragma: public');
    header('Cache-control: private');
    header('Expires: -1');
    echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>";

    echo '<xml>';

for($i=0;$i<count($arrSqlNews);$i++) 
{
    echo "<news>";
        echo "<newsId>".$arrSqlNews[$i][id]."</newsId>";
        echo "<newsAuthor>".$arrSqlNews[$i][news_author]."</newsAuthor>";
        echo "<newsText>".$arrSqlNews[$i][news_text]."</newsText>";
        echo "<description>".$arrSqlNews[$i][news_description]."</description>";
        echo "<image>".$arrSqlNews[$i][news_image]."</image>";
    echo "</news>";       
}
    echo '</xml>';

Hope my question is clear. Thanks in Advance !!

PHP has a couple of extensions to generate XML that take care of generating valid syntax... — Álvaro González
– Álvaro González, Commented Dec 12, 2012 at 11:42

Dave Hart · Accepted Answer · 2012-12-12 11:39:15Z

2

Consider adding CDATA tags whenever you work with strings, as special characters can break your XML parse.

echo "<newsText><![CDATA[".$arrSqlNews[$i][news_text]."]]></newsText>";

answered Dec 12, 2012 at 11:39

Dave Hart

3471 silver badge9 bronze badges

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

Comments

MarcinJuraszek · Accepted Answer · 2012-12-12 11:40:27Z

1

Try this:

echo "<newsText><![CDATA[".$arrSqlNews[$i][news_text]."]]></newsText>";

It will prevent the browser from parsing tags from that field content.

answered Dec 12, 2012 at 11:40

MarcinJuraszek

126k15 gold badges199 silver badges267 bronze badges

1 Comment

Vignesh Gopalakrishnan Over a year ago

This thing working fine on my local server. When i upload to my site i got this error (XML Parsing Error: no element found). What might be the reason

Collectives™ on Stack Overflow

Generating XML Dynamically in PHP - Parsing Error

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related