All pastes #925907 Raw Edit

Miscellany

public php v1 · immutable
·published 2008-03-03 12:01 UTC
rendered paste body
	$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);?>