Jump to content


This topic is now archived and is closed to further replies.


creating a XML file from MYSQL with PHP

Recommended Posts

I have the code below , and when I run it on my website , it returns a XML Parsing Error: not well-formed error , which says it has a problem reading the & i think


please see http://www.jamesflowersreports.com/php/xml2.php


I think it has something to wiht the str_replace as when I change the $row['customerName'] . "</Name>\n"; to $row['customerNumber'] . "</Name>\n"; as a test it works fine , I understand XML cant handle special characters , how would prevent this happening?


code as below




$query = "SELECT * FROM customers";
$resultID = mysql_query($query, $linkID) or die("Data not found.");

$xml_output = "<?xml version=\"1.0\"?>\n";
$xml_output .= "<entries>\n";

for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){
    $row = mysql_fetch_assoc($resultID);
    $xml_output .= "\t<entry>\n";
    $xml_output .= "\t\t<Name>" . $row['customerName'] . "</Name>\n";
        // Escaping illegal characters
        $row['text'] = str_replace("&", "&", $row['text']);
        $row['text'] = str_replace("<", "&lt", $row['text']);
        $row['text'] = str_replace(">", ">", $row['text']);
        $row['text'] = str_replace("\"", """, $row['text']);
    $xml_output.= "\t\t<Number>" . $row['customerNumber'] . "</Number>\n";
    $xml_output.= "\t</entry>\n";

$xml_output .= "</entries>";

echo $xml_output;






Share this post

Link to post
Share on other sites

You could always use CDATA elements



<?xml version="1.0" encoding="utf-8" ?>
    <Name><![CDATA[<i>Proctor & Gample</i>]]></Name>
    <Text><![CDATA[<strong>Soap Manufacturers</strong>]]></Text>
    <Name><![CDATA[<i>Fleecem & Runn</i>]]></Name>
    <Text><![CDATA[<strong>Financial Advisors</strong>]]></Text>


$xml = simplexml_load_file('cust.xml');
foreach ($xml->Customer as $c) {
    echo $c->Number . '<br>';
    echo $c->Name . '<br>';
    echo $c->Text . '<br><br>';




Share this post

Link to post
Share on other sites


Yes, I know.


I am suggesting you create it using CDATA.


The above is an example of what it will look like, in an effort to assist you, and also to demonstrate that it can hold special characters.

Share this post

Link to post
Share on other sites

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.