I have a xml file with name playlist.xml
<?xml version="1.0" encoding="UTF-8"?>
<xml>
<track>
<path>song.mp3</path>
<title>Track 1 - Title</title>
</track>
</xml>
I have a file with name view_katalog_detail.php
<?php
$show_query=mysql_query("select * from album where id='$id'");
$show_detail=mysql_fetch_array($show_query);
$id="$show_detail[id]";
$tanggal="$show_detail[tanggal]";
$hit_lihat="$show_detail[hit_lihat]";
$album_judul="$show_detail[album_judul]";
$album_penyanyi="$show_detail[album_penyanyi]";
$album_kategori="$show_detail[album_kategori]";
$album_produser="$show_detail[album_produser]";
$album_tglterbit="$show_detail[album_tglterbit]";
$album_jmllagu="$show_detail[album_jmllagu]";
$album_harga="$show_detail[album_harga]";
$path="$show_detail[path]"; //lokasi gambar
$hub_nama="$show_detail[hub_nama]";
$hub_hp="$show_detail[hub_hp]";
$album_harga = number_format($album_harga); //menggalihan format harga pada curency
$album_harga = str_replace(",",".",$album_harga); // mengganti koma dengan titik
// for show record lagu
$show_query2=mysql_query("select * from song where albumid='$id' order by id Desc");
$jml_lagu=mysql_num_rows($show_query2); //melihat jumlah record
$jml=0; //masukkan variabel field di mysql
while ($show_detail2=mysql_fetch_row($show_query2))
{
$lihat [$jml][0] = $show_detail2[0]; //song id
$lihat [$jml][1] = $show_detail2[1];// album id
$lihat [$jml][2] = $show_detail2[2]; //song title
$lihat [$jml][3] = $show_detail2[3]; // singer
$lihat [$jml][4] = $show_detail2[4]; // creator
$lihat [$jml][5] = $show_detail2[5]; // path
$jml++;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="adm_style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
background-image: url(images/background.gif);
}
-->
</style>
<script src="../Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>
<body>
<table width="80%" border="0" cellpadding="0" cellspacing="0" id="table_isi">
<tr>
<td><img src="images/ln_bar.gif" alt="---------" width="457" height="4" /></td>
</tr>
<tr>
<td height="40" class="title"><strong>Lihat Katalog Album</strong></td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="3" cellspacing="2" class="upload">
<tr>
<td colspan="2" class="katalog"><div align="right"><a href="home.php?page=katalog-edit.html&sesi_get=<?echo"$sesi_get";?>&id=<?echo"$id";?>">UBAH</a> <a href="home.php?page=katalog-hapus.html&sesi_get=<?echo"$sesi_get";?>&id=<?echo"$id";?>">HAPUS</a> </div></td>
</tr>
<tr>
<td height="30" colspan="2"><div align="center" class="txt-judul"><strong><?echo"$album_judul";?></strong></div></td>
</tr>
<tr>
<td colspan="2" class="katalog"><div align="center"><img src="../<?echo"$path";?>" alt="<?echo"$album_judul";?>" title="<?echo"$album_judul";?>" /></div></td>
</tr>
<tr>
<td width="32%"><div align="right"><strong>Tanggal Upload </strong></div></td>
<td width="68%"><?echo"$tanggal";?></td>
</tr>
<tr>
<td><div align="right"><strong>Dilihat</strong></div></td>
<td><?echo"$hit_lihat";?> kali</td>
</tr>
<tr>
<td><div align="right"><strong>Penyanyi</strong></div></td>
<td><?echo"$album_penyanyi";?></td>
</tr>
<tr>
<td><div align="right"><strong>Kategori</strong></div></td>
<td><?echo"$album_kategori";?></td>
</tr>
<tr>
<td><div align="right"><strong>Produser</strong></div></td>
<td><?echo"$album_produser";?></td>
</tr>
<tr>
<td><div align="right"><strong>Tahun Terbit </strong></div></td>
<td><?echo"$album_tglterbit";?></td>
</tr>
<tr>
<td><div align="right"><strong>Jumlah Lagu </strong></div></td>
<td><?echo"$album_jmllagu";?></td>
</tr>
<tr>
<td><div align="right"><strong>Harga</strong></div></td>
<td>Rp <?echo"$album_harga";?>,-</td>
</tr>
<tr>
<td><div align="right"><strong>Nama yg bisa dihubungi</strong></div></td>
<td><?echo"$hub_nama";?></td>
</tr>
<tr>
<td valign="top"><div align="right"><strong>Telepon yg bisa dihubungi</strong></div></td>
<td><?echo"$hub_hp";?></td>
</tr>
</table></td>
</tr>
<tr>
<td><div align="center">Terdapat <strong><?echo"$jml_lagu";?></strong> lagu pada album ini.</div></td>
</tr>
<?php
$l=$p+15;
if ($p=="" || !eregi("^[0-9]",$p) || $p>$jml_lagu) {
$p = 0;
}
if($jml_lagu<=$l){
$n=$jml_lagu;
}else{
$n=$l;
}
for ($i=$p;$i<$n;$i++){
echo "<tr>
<td align=\"left\" class=\"katalog\"><ul>
<li><strong>",$lihat[$i][2],"</strong> Voc. <strong>",$lihat[$i][3],"</strong> Cipt. <strong>",$lihat[$i][4],"</strong> Path. <strong>",$lihat[$i][5],"</strong> </li></ul>
</td>
</tr>";
}
?>
<tr>
<td> </td>
</tr>
<tr>
<td align="center">[COLOR="Red"]<script type="text/javascript" src="swfobject.js"></script>
<div id="flashPlayer">
Music Player
</div>
<script type="text/javascript">
var so = new SWFObject("playerMultipleList.swf", "mymovie", "295", "200", "7", "#FFFFFF");
so.addVariable("autoPlay","no")
so.addVariable("playlistPath","playlist.xml")
so.write("flashPlayer");
</script>[/COLOR]
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</body>
</html>
With this script i need to play music with flash player (name: playerMultipleList.swf) with modify playlist.xml file until the “path” is retrieve data from mysql database with table name is “song” and field name is “path”. A album have several song so we can play a song with a parameter song title.
Can anyone help me to fix that? I really appreciate it… Great thanks
