Hi guys!
I have this PHP file that behaves like a XML file. It works with my web-site feeds so I was wondering… Instead using a PHP file to retrieve the data from my database, is it possible to make a XML ActionScript that attaches a *.php file, that makes the loop from my database in the shape of a XML file?
I think that using XML is a lot easier than to use the PHP way…
Look at my code:
<?php require_once(‘Connections/connKat.php’); ?>
<?php
mysql_select_db($database_connKat, $connKat);
$query_rsShowShows = “SELECT *, date_format(show_date, ‘%m/%d/%Y’) as show_date FROM shows ORDER BY show_date LIMIT 5”;
$rsShowShows = mysql_query($query_rsShowShows, $connKat) or die(mysql_error());
$row_rsShowShows = mysql_fetch_assoc($rsShowShows);
$totalRows_rsShowShows = mysql_num_rows($rsShowShows);
header(“Content-type: application/xml”);
echo “<?xml version="1.0" encoding="iso-8859-1"?” . ">
";
echo "<shows>
";
do {
echo " <newdate id="$row_rsShowShows[show_id]">
";
echo " <date>$row_rsShowShows[show_date]</date>
";
echo " <city>$row_rsShowShows[show_city]</city>
";
if (isset($row_rsShowShows[show_venue])) {
echo " <venue>$row_rsShowShows[show_venue]</venue>
";
} else {
echo " <venue />
"; }
echo " <address>$row_rsShowShows[show_address]</address>
";
if (isset($row_rsShowShows[show_website])) {
echo " <website>$row_rsShowShows[show_website]</website>
";
} else {
echo " <website />
"; }
echo " <time>$row_rsShowShows[show_time]</time>
";
if (isset($row_rsShowShows[show_contactinfo])) {
echo " <contact>$row_rsShowShows[show_contactinfo]</contact>
";
} else {
echo " <contact />
"; }
echo " <ticket>$row_rsShowShows[show_ticketprice]</ticket>
";
echo " </newdate>
";
} while ($row_rsShowShows = mysql_fetch_assoc($rsShowShows));
echo “</shows>”;
mysql_free_result($rsShowShows);
?>
THANKS!
