query

1 files changed, 15 insertions, 0 deletions

diff --git a/www/select.php b/www/select.php
new file mode 100644
index 0000000..b263d48
--- /dev/null
+++ b/www/select.php
@@ -0,0 +1,15 @@
+<?
+
+//session_start();
+
+$db = new SQLite$("../database/sqlite.db");
+$owner=2;
+$folder=0;
+
+//for($i=1;$i<6;$i++){
+	$result_db = $db->query("SELECT id, folder, name, public FROM files WHERE folder=$folder AND owner=$owner AND type='directory' AND public='public';");
+	$result_ar = $result_db->fetchArray(SQLITE3_NUM);
+//	$folder=$result_ar[1];
+	
+	echo "result_ar[1]: $result_ar[1]; result_ar[0]: $result_ar[0]";
+//}