X-Git-Url: http://russells-world.com/code/?p=home-automation.git;a=blobdiff_plain;f=sqlite.php;fp=sqlite.php;h=5752d9f15eed55b66e1a05c761d7b62673e77504;hp=0000000000000000000000000000000000000000;hb=2302283047d4580aa4b97bc8987dd1525480c3ba;hpb=22502eb7a498183fada4a50994fa2bb25e4bb790

diff --git a/sqlite.php b/sqlite.php
new file mode 100644
index 0000000..5752d9f
--- /dev/null
+++ b/sqlite.php
@@ -0,0 +1,26 @@
+<?
+$handle = sqlite_open("boxee_catalog.db") or die("Could not open database"); 
+
+$query = "select * from audio_files";
+
+$result = sqlite_query($handle, $query) or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
+
+// if rows exist
+if (sqlite_num_rows($result) > 0) {
+    // get each row as an array
+    // print values
+    echo "<table cellpadding=10 border=1>";
+    while($row = sqlite_fetch_array($result)) {
+        echo "<tr>";
+        echo "<td>".$row[0]."</td>";
+        echo "<td>".$row[1]."</td>";
+        echo "<td>".$row[2]."</td>";
+        echo "</tr>";
+    }
+    echo "</table>";
+}
+
+// all done
+// close database file
+sqlite_close($handle);
+?>