<?php



require("include/db_login.php");



// Start XML file, create parent node



$dom = new DOMDocument("1.0");

$node = $dom->createElement("markers");

$parnode = $dom->appendChild($node);



// Opens a connection to a MySQL server



$connection=mysql_connect (DATABASE_HOST, DATABASE_USERNAME , DATABASE_PASSWORD);

if (!$connection) {  die('Not connected : ' . mysql_error());}



// Set the active MySQL database



$db_selected = mysql_select_db(DATABASE_NAME, $connection);

if (!$db_selected) {

  die ('Can\'t use db : ' . mysql_error());

}



// Select all the rows in the markers table



$query = "SELECT * FROM markers WHERE 1";

$result = mysql_query($query);

if (!$result) {

  die('Invalid query: ' . mysql_error());

}



header("Content-type: text/xml");



// Iterate through the rows, adding XML nodes for each



while ($row = @mysql_fetch_assoc($result)){

  // Add to XML document node

  $node = $dom->createElement("marker");

  $newnode = $parnode->appendChild($node);

  $newnode->setAttribute("id",$row['id']);

  $newnode->setAttribute("name",$row['name']);

  $newnode->setAttribute("address", $row['address']);

  $newnode->setAttribute("lat", $row['lat']);

  $newnode->setAttribute("lng", $row['lng']);

  $newnode->setAttribute("type", $row['type']);

}



echo $dom->saveXML();



?>