PHP Code - Generate XML from database

Below is PHP code to generate XML from database.

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

header("Content-type: text/xml");   mysql_connect('hostname','user','password'); mysql_select_db('database_name'); $query = mysql_query("select * from table_name");            $domtree = new DOMDocument('1.0', 'UTF-8');   $xmlRoot = $domtree->createElement("xml");   $xmlRoot = $domtree->appendChild($xmlRoot);   $currentTrack = $domtree->createElement("itemset");   $currentTrack = $xmlRoot->appendChild($currentTrack);     while($row = mysql_fetch_assoc($query))     {         $currentTrack1 = $currentTrack->appendChild($domtree->createElement("item"));         foreach($row as $index=>$val)             {                 $currentTrack1->appendChild($domtree->createElement($index,$val));               }     }     echo $domtree->saveXML();