3 replies to this topic

[musicmee]

Right so i have a flash mp3 player now that plays ALL the music on the site via playlist.xml... however would it be possible to filter the playlist...?

because i have band profiles and it would be great to do something like...

playlist.php?band=$profile[username]

and would flash be able to get the username of the currently viewed profile "$profile[username]"?

and it would create a playlist where he bands name is username?

Anyone get me? or got any ideas?

So far i ahve the playlist xml (well php with a bit of htaccess magic) as...

<?php
header('Content-type: text/xml'); 
?>
<?xml version='1.0' encoding='utf-8'?>
<songs>
<?
$result = mysql_query("SELECT * FROM bandmusic ORDER BY date DESC where owner = $profile[username]"); 
while($row = mysql_fetch_assoc($result)){ 
?>
<song name="<?=$row['tracktitle']; ?>" file="<?=$row['urlloc']; ?>" />
<? } ?>
</songs>

But i dont think thats right?

Edited by musicmee, 18 February 2008 - 05:36 PM.

[musicmee]

anyone able to help ?

[Ben]

Just add a row in your XML:

<?php
header('Content-type: text/xml');
?>
<?xml version='1.0' encoding='utf-8'?>
<songs>
<?
$result = mysql_query("SELECT * FROM bandmusic ORDER BY date DESC where owner = $profile[username]");
while($row = mysql_fetch_assoc($result)){?>
<song name="<?=$row['tracktitle']; ?>" file="<?=$row['urlloc']; ?>" />
<? } ?>
</songs>

<username value="<? echo $_GET['band']; ?>" />

And output it into Flash:

trace(XMLNAME.childNodes[1].attributes["value"]);

Replace XMLNAME ofcourse

[bezz]

Check out my flash mp3 player. You can specify a .php file for the playlist, so you don't need to mess around with .htaccess.
Mp3 Player with XML Playlist