Xml from mysql with php

1

I’m trying to get the output mysql as xml using php tutorial to work, but I’m having one problem with it.

since a php file starts off as <?php…and ends as ?> when ever I’m declaring that the output is gonna be xml, like this:


$xml_output = &quot;<?xml version=\&quot;1.0\&quot; encoding=\&quot;iso-8859-1\&quot;?>
&quot;;

it misunderstands the "?>" in the end of the xml declaration as the closing php tag.

here’s all of php code:


<?php

header(&quot;Content-type: text/xml&quot;);

$host = &quot;localhost&quot;;
$user = &quot;root&quot;;
$pass = &quot;pass&quot;;
$database = &quot;wgshop&quot;;

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

$query  = &quot;SELECT * FROM shopproducts ORDER BY id DESC&quot;;
$resultID = mysql_query($query, $linkID) or die(&quot;Data not found.&quot;);

$xml_output  = &quot;<?xml version=\&quot;1.0\&quot;?>
&quot;;
$xml_output .= &quot;<store>
&quot;;

for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++) {
   $row = mysql_fetch_assoc($resultID);
   $xml_output .= &quot;	<products>
&quot;;
	  //Escaping illegal characters
	  $row['prodName'] = str_replace(&quot;&, &quot;&amp;&quot;, $row['prodName']);
	  $row['prodName'] = str_replace(&quot;<&quot;, &quot;&lt;&quot;. $row['prodName']);
	  $row['prodName'] = str_replace(&quot;>&quot;, &quot;&gt;&quot;, $row['prodName']);
	  $row['prodName'] = str_replace(&quot;\&quot;&quot;, &quot;&quot;&quot;, $row['prodName']);
   $xml_output  .=  &quot;		<prodName>&quot; .  $row['prodName'] . &quot;</prodName>
&quot;;

	  //Escaping illegal characters
	  $row['price'] = str_replace(&quot;&, &quot;&amp;&quot;, $row['price']);
	  $row['price'] = str_replace(&quot;<&quot;, &quot;&lt;&quot;. $row['price']);
	  $row['price'] = str_replace(&quot;>&quot;, &quot;&gt;&quot;, $row['price']);
	  $row['price'] = str_replace(&quot;\&quot;&quot;, &quot;&quot;&quot;, $row['price']);
   $xml_output .= &quot;		<price>&quot; . $row['price'] . &quot;</price>
&quot;;

   $xml_output .= &quot;		<section>&quot; . $row['section'] . &quot;</section>
&quot;;

   $xml_output .= &quot;		<prodImage>&quot; . $row['prodImage'] . &quot;</prodImage>
&quot;;

	  //Escaping illegal characters
	  $row['description'] = str_replace(&quot;&, &quot;&amp;&quot;, $row['description']);
	  $row['description'] = str_replace(&quot;<&quot;, &quot;&lt;&quot;. $row['description']);
	  $row['description'] = str_replace(&quot;>&quot;, &quot;&gt;&quot;, $row['description']);
	  $row['description'] = str_replace(&quot;\&quot;&quot;, &quot;&quot;&quot;, $row['description']);
   $xml_output .= &quot;		<description>&quot; . $row['description'] . &quot;</description>
&quot;;
   $xml_output .= &quot;	</products>
&quot;;
}

$xml_output .= &quot;</store>&quot;;

echo $xml_output;

?>

I know that it’s that “?>” in the xml declaration that messing it all up, but I’m a php novice so I have no clue what to do about it.

I’ve searched the boards and noone else seems to be having this problem.