Added basic DB for song entries.

kevinmcdonagh · Sep 5, 2010 · a9d8205 · a9d8205
1 parent 300ed96
commit a9d8205
Show file tree

Hide file tree

Showing 2 changed files with 10 additions and 12 deletions.
diff --git a/code/mashbox1.php b/code/mashbox1.php
@@ -67,18 +67,16 @@
                     </tr>
                 </thead>
                 <tbody>
-                    <tr>
-                        <td><span>Wu Tang</span> <b>+</b> <span>Fisher Band</span></td>
-                        <td><span>Kevin</span> <b>&amp;</b> <span>Yves</span></td>
-                    </tr>
-                    <tr>
-                        <td><span>Wu Tang</span> <b>+</b> <span>Fisher Band</span></td>
-                        <td><span>Kevin</span> <b>&amp;</b> <span>Yves</span></td>
-                    </tr>
-                    <tr>
-                        <td><span>Wu Tang</span> <b>+</b> <span>Fisher Band</span></td>
-                        <td><span>Kevin</span> <b>&amp;</b> <span>Yves</span></td>
-                    </tr>
+					<?php
+						$dbh = new PDO('sqlite:mashbox2.sqlite');
+						foreach($dbh->query('SELECT * FROM tracks') as $row){
+							echo ("<tr>\n");
+							echo ("<td><span>" . $row['title'] . "</span> <b>+</b> <span>" . $row['artist'] . "</span></td>\n");
+							echo ("<td><span>". $row['addedby1'] . "</span> <b>&amp;</b> <span>". $row['addedby2'] . "</span></td>\n");		                        
+							echo ("<tr>\n");
+					  	}
+						$dbh = null;
+					?>
                 </tbody>
             </table>
         </div>

diff --git a/code/mashbox2.sqlite b/code/mashbox2.sqlite