Error when writing data into a xml file using php

programming
1

This page contains the following errors:

error on line 1 at column 1: Document is empty

Below is a rendering of the page up to the first error.

<?php
$username = "root";
$password = "";
$dbName = "Test";
$dbHost = "127.0.0.1";
header("Content-type: text/xml"); 

// Start XML file, create parent node

$dom = new DomDocument('1.0');
$dom->Load('C:/xampp/htdocs/Code2/query.xml');
//$node = $dom->createElement('markers');
//$parnode = $dom->appendChild($node); 

// Opens a connection to a MySQL server
$chandle = mysql_connect("localhost", $username, $password) 
    or die("Connection Failure to Database".mysql_error());
echo "Connected to database server<br>";

mysql_select_db($dbName, $chandle) or die ($dbname . " Database not found." . $username);
echo "Database " .  $dbName . " is selected";

$query = "SELECT * FROM test_1 WHERE street = 'sun'";
$result = mysql_query($query)
	or die('Invalid query: ' .mysql_error());
echo "<br>Table successfuly retrieved<br>";

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

while ($row = @mysql_fetch_assoc($result)){  
  // ADD TO XML DOCUMENT NODE
	$candidate = $dom->getElementsByTagName('markers')->item(0);
	$newElement = $dom ->createElement('marker');
	$nodeB = $candidate ->appendChild($newElement);
	$nodeB->setAttribute("street",$row['street']);
	$nodeB->setAttribute("suburb", $row['suburb']);
	$test = $dom->save("C:/php/xml_files/query.xml");  
  /*$node = $dom->createElement("marker");  
  $newnode = $parnode->appendChild($node);   
  $newnode->setAttribute("street",$row['street']);
  $newnode->setAttribute("suburb", $row['suburb']); 
*/  
} 
//echo $dom->saveXML('C:/xampp/htdocs/Code2/query.xml');
?>

This page contains the following errors:

error on line 2 at column 1: Extra content at the end of the document

Below is a rendering of the page up to the first error.

<?php 

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

$host = "localhost"; 
$user = "root"; 
$pass = ""; 
$database = "test"; 

$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host."); 
mysql_select_db($database, $linkID) or die("Could not find database."); 

$query = "SELECT * FROM test_1"; 
$resultID = mysql_query($query, $linkID) or die("Data not found."); 

$xml_output = "<?xml version=\"1.0\"?>
"; 
$xml_output .= "<entries>
"; 

for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){ 
    $row = mysql_fetch_assoc($resultID); 
    $xml_output .= "	<entry>
";  
        // Escaping illegal characters 
        $row['text'] = str_replace("&", "&", $row['text']); 
        $row['text'] = str_replace("<", "<", $row['text']); 
        $row['text'] = str_replace(">", "&gt;", $row['text']); 
        $row['text'] = str_replace("\"", "&quot;", $row['text']); 
    $xml_output .= "		<street>" . $row['street'] . "</street>
";
    $xml_output .= "		<suburb>" . $row['suburb'] . "</suburb>
";	
    $xml_output .= "	</entry>
"; 
} 

$xml_output .= "</entries>"; 

echo $xml_output; 

?>

A little info, I am running apache 2.x and php 5.x and mysql server v5.x.

A little desperate as I don’t usually post on forums because the question I am likely to ask has been answered a thousand times over.