Write a large XML file
I'm using PHP to Convert mySQL (more than a million records)to XML. I'm use DOMDocument to this work. But I can't write a large XML file. How to write a large XML file. Can you help me!?
My code:
<?php
include("includes/database.inc");

$table_id = 'RoutePlan';
$query = "SELECT * FROM $table_id";

$result = db_query($query);
if (!$result){
echo "Cannot connect to database CallPlans'";
exit;
}

$encoding = 'utf-8';

// create a new XML document
$doc = new DomDocument('1.0',$encoding);
$doc->formatOutput = true;

// create root node
$root = $doc->createElement('CallPlans');
$root = $doc->appendChild($root);

// process one row at a time
while($row = db_fetch_object($result)) {
// add node for each row
$occ = $doc->createElement($table_id);
$occ = $root->appendChild($occ);

// add a child node for each field
foreach ($row as $fieldname => $fieldvalue) {
$child = $doc->createElement($fieldname);
$child = $occ->appendChild($child);
$value = $doc->createTextNode($fieldvalue);
$value = $child->appendChild($value);
} // foreach

} // while
// get completed xml document

echo 'Wrote: ' . $doc->save("CallPlans.xml") . ' bytes';
?>