<?php
// Start XML file, create parent node
$xml = new XMLWriter();
$xml->openMemory();
$xml->startDocument('1.0', 'UTF-8');
//markers
$xml->startElement('markers');
//close markers
$xml->endElement();
//write to file
file_put_contents('markers.xml', $xml->outputMemory());
// Iterate through the rows, adding XML nodes for each
while ($row = @mysql_fetch_assoc($result)) {
// ADD TO XML DOCUMENT NODE
$node = $xml->create_element("marker");
$newnode = $parnode->append_child($node);
$newnode->set_attribute("name", $row['name']);
$newnode->set_attribute("address", $row['address']);
$newnode->set_attribute("lat", $row['lat']);
$newnode->set_attribute("lng", $row['lng']);
$newnode->set_attribute("type", $row['type']);
}
