PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
<?php
require_once("connect.inc.php");
$db = getConnectionMySql();
$stmt = $db->query("SELECT email, name, lastlogin FROM subscriber");
$doc = new DomDocument('1.0','UTF-8');
$root = $doc->createElement('subscribers');
$root = $doc->appendChild($root);
// process all rows
while ( $obj = $stmt->fetchObject()){
// add node for each record
$email = $doc->createElement('email');
$email = $root->appendChild($email);
foreach ($row as $fieldName => $fieldValue)
{
// add a child node for each field
$child = $doc->createElement($fieldName);
$child = $email->appendChild($child);//apend to car
$value = $doc->createTextNode($fieldValue);//set text to add
$value = $child->appendChild($value);//add it to new node (child of car)
}
}
echo 'Wrote: ' . $doc->save("subscriber.xml") . ' bytes';