Play MP3 File Through Link

[Dysan]

Hello!

I have the following code, that uploads files to a "Upload" directory on the server, and stores the files path in a database.

mysql_select_db("MP3s", $con);

if (($_FILES["file"]["type"] == "audio/mpeg"))
{
  if ($_FILES["file"]["error"] > 0)
  {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
  }
  else
  {
    echo "Upload: " . $_FILES["file"]["name"] . "<br />";
    echo "Type: " . $_FILES["file"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";

if (file_exists("upload/" . $_FILES["file"]["name"]))
{
  echo $_FILES["file"]["name"] . " already exists. ";
}
else
{
  $file = ("upload/" . $_FILES["file"]["name"]);
  move_uploaded_file($_FILES["file"]["tmp_name"],
  "upload/" . $_FILES["file"]["name"]);
  echo "Stored in: " . "upload/" . $_FILES["file"]["name"];

  mysql_query("INSERT INTO Music (Path)
  VALUES('$file')");    
}
  }
}
else
{
  echo "Invalid file";
}

How do I adapt the below code to link to the mp3 file contain in the "Upload" folder, in order to play the file.

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
  die(mysql_error());
}

mysql_select_db("MP3s", $con);

$result = mysql_query("SELECT * FROM Music");

while($row = mysql_fetch_array($result))
{
  echo '<a href="Display.php?Path='.$row['Path'].'">'.$row['Path'].'</a>';
} 

mysql_close($con);
?>

[Scooby_Doo]

This is what you should need to have the user to play the file at ease. I haven't tested it because I didn't want to go through all the work of getting it ready just for a test. If you still need help just post and I'll see what I can do.

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
  die(mysql_error());
}

mysql_select_db("MP3s", $con);

$result = mysql_query("SELECT * FROM Music");

while($row = mysql_fetch_array($result))
{
	echo "<font size=\"20pt\">";
	echo . $row['path'] . ;
	echo "</font>";
	echo "<embed src=\"";
	echo . $row['path'] . ;
	echo "\" width=\"140\" height=\"40\" autostart\"false\" loop=\"FALSE\"></embed>";
} 

mysql_close($con);
?>