Jump to content


Photo

PHP arrays


  • Please log in to reply
No replies to this topic

#1 ezdotcom

ezdotcom
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 18 September 2006 - 07:17 PM

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 flash
echo "<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!!





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users