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);
?>