ezdotcom Posted September 18, 2006 Share Posted September 18, 2006 I am making a playlist for my website, what i want it to do is read from the database table a list of songs that a certain user may of uploaded. At present i can get the script to read from the directory but there is no definition as to what songs are played. E.g. all songs are played to all users. I want the songs for each user inserted into the playlist.here's the code:<?php# Script 13.1 - header.html// This page begins the HTML header for the site.// Start output buffering.ob_start();// Initialize a session.session_start();?><?php$ti = $_SESSION['first_name'];include "../includes/mysql_connect.php";$sql = "SELECT file_name from uploads where user_id = blah@blah.blah";$query = mysql_query($sql) or mysql_error();$rowsee=mysql_fetch_array($query); $moo = $rowsee['imgstatus'];$playlist[]= "mp3/".$moo;// setting the directory to search for mp3 files//$dir = "mp3/".$moo;// reading the directory and inserting the mp3 files in the playlist array//$playlist = array();//$fdir = opendir($dir);//while($i = readdir($fdir)) { // if a .mp3 string is found, add the file to the array //if (strpos(strtolower($i),".mp3") !== false) // $playlist[] = $i.$moo;//}// close the directory//closedir($fdir);sort($playlist);// make an alphabetical ordered list (if you don't want an ordered list, just comment this line)shuffle($playlist);// make a randomized list (if you don't want a randomized list, just comment this line)header("Content-type: text/xml");// echoing the playlist to flashecho "<player showDisplay=\"yes\" showPlaylist=\"yes\" autoStart=\"yes\">\n";for ($i=0; $i<sizeof($playlist); $i++) { // for the title it filters the directory and the .mp3 extension out $title = str_replace(".mp3","",$playlist[$i]); // clean filename (convert "_" into " ") $title = str_replace("_", " ", $title); echo " <song path=\"$dir{$playlist[$i]}\" title=\"$title\" />"; echo "$moo";}echo "</player>";?>this has been driving me mad for over a week now, sleepless nights are a result!!Anyone who can help it would be much much appreciated.Thanks!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.