title: How would I upload music using php and mysql
body: <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>