# \[Flash8\] PHP as XML in Flash

**URL:** <https://forum.kirupa.com/t/flash8-php-as-xml-in-flash/210292>\
**Category:** flash\
**Created:** [December 17, 2006, 12:40pm UTC](https://forum.kirupa.com/t/flash8-php-as-xml-in-flash/210292 "2006-12-17T12:40:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![eber\_freitas](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/eber_freitas/32/3103_2.png) [@eber\_freitas](https://forum.kirupa.com/u/eber_freitas)\
**Post date:** [December 17, 2006, 12:40pm UTC](https://forum.kirupa.com/t/flash8-php-as-xml-in-flash/210292/1 "2006-12-17T12:40:45Z")

</div>

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!