On 11.14.09, In Tutorials
Firstly, Let me talk about this post. If your advance level php programmer, this is a piece of cake for you. I would like to say this post for beginner level. It would be a little difficult for a beginner. You may need xml output when you want to integrate with flash and MySQL records such as photo gallery, playlist for flash mp3 player, RSS Feeds, and so on.
I would like to show you an example to create xml playlist. So you can use this in flash mp3 player like JW Player. I have created songs table in my database. songs_id, album_id, songs_title and songs_link fields are included in this table.
In PHP file :
<?php
header('Content-type: text/xml');
$db_host = "localhost" ; // MySQL Host
$db_user = "root" ; // Database Username
$db_password = "" ; // Database Password
$db_name = "music" ; // Database Name
$db_link = mysql_connect("$db_host","$db_user","$db_password");
mysql_select_db($db_name, $db_link);
?>
<playlist version="1" xmlns="http://xspf.org/ns/0/">
<trackList>
<?php
$album_id = $_GET[aid];
$songs = "SELECT * From songs WHERE album_id='$album_id' ORDER BY song_title ASC";
$songs_list = mysql_query( $songs, $db_link );
$songs_total = mysql_num_rows( $songs_list );
if( $songs_total == 0 ) { exit; }
for( $f = 0; $f < $songs_total; $f++ )
{
$each = mysql_fetch_assoc( $songs_list );
?>
<track>
<title><?=$each['song_title']?></title>
<location>http://www.yourdomain.com/<?=$each['song_link']?></location>
</track>
<?php
} // End of loop
?>
</trackList>
</playlist>
Then you can use call this file with album id like xml.php?aid=10.
Leave Your Response