Hey Folks!
So I have a php setup to echo an XML document. I’ve tested it and it looks great!
<?xml version ="1.0"?>
<MUSIC>
<ARTIST>Luther Vandross</ARTIST>
<SONGTITLE>Never Let Me Go</SONGTITLE>
<ARTIST>Luther Vandross</ARTIST>
<SONGTITLE>Never Too Much</SONGTITLE>
<ARTIST>Luther Vandross</ARTIST>
<SONGTITLE>Forever And Always For Love</SONGTITLE>
</MUSIC>
In actionscript, I’m trying to send the artist’s name to PHP, PHP will pull the artist info from SQL and echo out in XML for flash. Flash receives it, but it receives it like this:
“%3C%3Fxml%20version%20=%221%2E0%22%3F%3E%0A%3CMUSIC%3E%0A%3CARTIST%3ELuther%20Vandross%3C%2FARTIST%3E%0A%3C”
Is there something wrong with my Flash Script? The artistName variable will contain a string with an artist’s name…just an FYI, but like I said, it returns back with information, but not in XML format.
var myArtistXML:XML = new XML();
var variables:URLVariables = new URLVariables();
var varSend:URLRequest = new URLRequest("http://localhost:8888/artistSongs.php");
varSend.method = URLRequestMethod.POST;
varSend.data = variables;
var varLoader:URLLoader = new URLLoader;
varLoader.dataFormat = URLLoaderDataFormat.VARIABLES;
varLoader.addEventListener(Event.COMPLETE, processMusicDB);
variables.artistSongs = artistSongs;
varLoader.load(varSend);
function processMusicDB(e:Event):void
{
myArtistXML = new XML(e.target.data);
trace(myArtistXML);
}
and here’s my PHP:
<?php
$link = mysql_connect("localhost:8888", "root", "password");
mysql_select_db("test");
$artistName = $_POST['artistSongs'];
$query = 'SELECT * FROM Music WHERE ArtistName LIKE \''.$artistName.'\'';
$results = mysql_query($query);
echo "<?xml version =\"1.0\"?>
";
echo "<MUSIC>
";
while($line = mysql_fetch_assoc($results)){
$ucArtistName = ucwords($line["ArtistName"]);
$ucSongTitle = ucwords($line["SongTitle"]);
echo "<ARTIST>" . $ucArtistName . "</ARTIST>
";
echo "<SONGTITLE>" . $ucSongTitle . "</SONGTITLE>
";
}
echo "</MUSIC>
";
mysql_close($link);
?>
Thank you so much for your help!