Dynamic XML from PHP and MySQL
Hi,
I'm learning php and I'm trying to get to grips with dynamic xml and php coming from a database. The trouble I am having is I can't get my code to give any output. I don't get an error I message, I just can't get the xml to display. If anyone can give me any pointers as to what I'm doing wrong that would be great...
Here's the code I have.
<?php
DEFINE ('DB_USER', 'root');
DEFINE ('DB_PASSWORD', 'password');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'flashphpbible');
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$query = "SELECT * FROM dynamicxml WHERE id=1";
$result = mysqli_query($link, $query);
$xmlData .= " ";
$xmlData .= "<store>\n";
while($row = mysqli_fetch_array($result));
{
$xmlData .= " <item>\n";
$xmlData .= " <name>".$row['name']."</name>\n"; $xmlData .= " <section>".$row['section']."</section>\n"; $xmlData .= " <price>".$row['price']."</price>\n";
$xmlData .= " <inStock>".$row['instock']."</inStock>\n"; $xmlData .= " </item>\n";
}
$xmlData .= "</store>\n"; echo "response=".$xmlData; ?>
Thanks for any help offered.
Ben.
