Hello!
I have the following code, that uploads files to a "Upload" directory on the server, and stores the files path in a database.
How do I adapt the below code to link to the mp3 file contain in the "Upload" folder, in order to play the file.Code: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"; }
Code:<?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); ?>


Reply With Quote
Bookmarks