[Resolved] Mysql to XML problem

[coxy]

Hi all,

The following code works fine to convert mysql to xml but one of my databases contains html tags e.g. I get an error when trying to put a </p> tag in the xml. My code is:

<?
header("Content-type: text/xml");
$db_name = "Dynamic"; //This is your database Name
$link = mysql_connect("localhost", "root", "") or die("Could not connect to server!");
//This is your table name. This is a one table config to do more table you will need to rework the code.
$table_name = 'Dynamic';

$select_db = mysql_select_db($db_name, $link); // mysql_select_db -- Select a MySQL database
$query = "SELECT * FROM " . $table_name;
$result = mysql_query($query, $link) or die("Could not complete database query");

$fcount = mysql_num_fields($result);

print "<result>";

while($row = mysql_fetch_array( $result ) ){
print "<row>";
for($i=0; $i< $fcount; $i++){
$tag = mysql_field_name( $result, $i );
print "<$tag>". $row[$i]. "</$tag>";
}
print "</row>";
}

?>

Is there a way of either ignoring the html tags or parsing them to be accepted ?

Thanks in advance 🙂

[phil_j_poore]

you can use....

$text = "<p>hello</p>";
$without_html = strip_tags($text);
echo $without_html;
// Will output "hello" without the quotes

find out more here ------> strip_tags ();
i hope that helps, i am not sure with xml but i will have a think about it in physics next lesson and if i think of anything i will post after school...
p.s. i am not sure whether it will strip your xml tags aswell it depends on how you are using the data.

also put your php code in [PHP ] and [/PHP ] tags without the spaces after the PHP... it makes it easier to understand what you want to do

[mtmosier]

If you want to keep your html tags in the xml you create, you can convert the < and > to html entities, or you can include the data in a cdata section.

For example, you could use

print "<$tag><![CDATA[". $row[$i]. "]]></$tag>";