i write a folling script for accessing data from database and show it as on xml format. but when i run a script it shows me error as 'undefined function domxml_new_doc()'.
so please check folling code and tell me where i am wrong. all sql queries are correct and shows result properly.
<?php
// Database Connection
$dbconnect = mysql_connect('localhost', 'root', '');
// Database Selection
mysql_select_db('deskaway_synage');
$outer_table = 'parent_table';
$query = "SELECT * FROM $outer_table WHERE column='value'";
$resouter = mysql_query($query);
$inner_table = 'child_table';
$query = "SELECT * FROM $inner_table WHERE column='value'";
$resinner = mysql_query($query);
// create a new XML document
echo domxml_version();
$doc = domxml_new_doc('1.0');
// add root node
$root = $doc->create_element('root');
$root = $doc->append_child($root);
// add node for parent/outer table
$outer = $doc->create_element($outer_table);
$outer = $root->append_child($outer);
// take only one row from parent/outer table
$row = mysql_fetch_assoc($resouter);
// add a child node for each parent field
foreach ($row as $fieldname => $fieldvalue) {
$child = $doc->create_element($fieldname);
$child = $outer->append_child($child);
$value = $doc->create_text_node($fieldvalue);
$value = $child->append_child($value);
} // foreach
// process all rows of the inner/many/child table
while($row = mysql_fetch_assoc($resinner)) {
// add node for each record
$inner = $doc->create_element($inner_table);
$inner = $outer->append_child($inner);
// add a child node for each field
foreach ($row as $fieldname => $fieldvalue) {
$child = $doc->create_element($fieldname);
$child = $inner->append_child($child);
$value = $doc->create_text_node($fieldvalue);
$value = $child->append_child($value);
} // foreach
} // while
// get completed xml document
$xml_string = $doc->dump_mem(true);
echo $xml_string;
?>
