convert mysql data to xml using php4

[nileshfarkade]

hello,
i am using php4. i have 2 tables in mysql like as task_list & tasks. i want to retrive data from these tables and show it as an xml format, for that i use php dom functions, but when i run a script. it show me an error message that "undefined function domxml_open_file()".
for running the script php4 needs any external lib or any external package. please give me reply

[bpat1434]

DOMXML in php4 requires the PECL extension.

Installation of DOM XML

[Jack_McSlay]

if you want to convert data to XML, it might be easier (and faster) to just sequentially put the XML tags on a string. for example:

<?php
$xml = '<?xml version="1.0" encoding="UTF-8"?><mydata>';
$sql = 'SELECT * FROM `table`';
$r = mysql_query ($sql);
while ($row=mysql_fetch_assoc ($r) ){
 $xml .= '<row>';
 foreach ($row as $field=>$value){
  $xml .= '<field name="'.htmlspecialchars ($field).'" value="'.htmlspecialchars ($value).'"/>';  

 }
 $xml .= '</row>';
}
$xml .= '</mydata>';

// let's output it for this example
header ('Content-type: text/xml; charset=UTF-8');
echo $xml;