How would I upload music using php and mysql
<p>I have created a table which contains my music information and album art. I've been using Mysql and PHP to create the table and implement the images. I don't understand how I would upload my music onto this table as well though? Could someone help? </p>

<p>I need my music to show and play in the play column.</p>

<p><a href="http://i.stack.imgur.com/pmFoG.png" rel="nofollow">As you can see, on the far right is the play column and the names of the mp3 files are in the play column as well </a></p>

<p><a href="http://i.stack.imgur.com/NtC0g.png" rel="nofollow">And this is where my audio files are</a></p>

<p>And here is my coding:</p>

<pre><code>&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
&lt;style&gt;
table, th, td {
     border: 1px solid black;
}
&lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;

&lt;?php

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "jukebox";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn-&gt;connect_error) {
     die("Connection failed: " . $conn-&gt;connect_error);
} 


$sql = "SELECT * FROM Music";
$result = $conn-&gt;query($sql);

if ($result-&gt;num_rows &gt; 0) {
     echo "&lt;table&gt;

     &lt;tr&gt;

     &lt;th&gt;Artist&lt;/th&gt;
     &lt;th&gt;Title&lt;/th&gt;
     &lt;th&gt;Album&lt;/th&gt;
     &lt;th&gt;Albumcover&lt;/th&gt;
     &lt;th&gt;Play&lt;/th&gt;
     &lt;/tr&gt;";


// output data of each row
     while($row = $result-&gt;fetch_assoc()) {

         echo 

         "&lt;tr&gt;

         &lt;td&gt;" . $row["Artist"]. "&lt;/td&gt;
         &lt;td&gt;" . $row["Title"]. "&lt;/td&gt;
         &lt;td&gt;" . $row["Album"]. "&lt;/td&gt;
         &lt;td&gt;&lt;img src='/jukebox/img/" . $row["Albumcover"] ."' alt=".$row["Albumcover"]."&gt;&lt;/td&gt;
         &lt;td&gt;" . $row["Play"]  . "&gt;&lt;/td&gt;



         &lt;/tr&gt;";
     }
     echo "&lt;/table&gt;";



} else {
     echo "0 results";
}



?&gt;  


&lt;/body&gt;
&lt;/html&gt;
</code></pre>