$table_id = 'animal'; $query = "SELECT * FROM $table_id"; $dbresult = mysql_query($query, $con); $doc = new DomDocument('1.0'); $root = $doc->createElement('root'); $root = $doc->appendChild($root); while($row = mysql_fetch_assoc($dbresult)) { $occ = $doc->createElement($table_id); $occ = $root->appendChild($occ); $subRoot = $doc->createElement($table_id); $subRoot = $root->appendChild($subRoot); foreach ($row as $fieldname => $fieldvalue) { $child = $doc->createElement($fieldname); $child = $occ->appendChild($child); $value = $doc->createTextNode($fieldvalue); $value = $child->appendChild($value); } // foreach } // while $xml_string = $doc->saveXML(); $file_handle = fopen('file.xml','a'); fwrite($file_handle,$xml_string); fclose($file_handle); ?>