From 833d72001d3df1680913759ff760708766618eb8 Mon Sep 17 00:00:00 2001 From: root Date: Mon, 10 Mar 2014 15:31:56 +0100 Subject: starting to write the interface --- www/select_function.php | 23 ++++++++++++++++++++--- 1 file changed, 20 insertions(+), 3 deletions(-) (limited to 'www/select_function.php') diff --git a/www/select_function.php b/www/select_function.php index b83fe04..6e4bc66 100644 --- a/www/select_function.php +++ b/www/select_function.php @@ -1,3 +1,4 @@ +query("SELECT id, name, folder FROM files WHERE parent=" . $parentdir . " AND owner=" . $owner . ";"); - $content_ar = $conten_db->fetchArray(SQLITE3_NUM); +// echo "parent: " . $parentdir . "
"; + $content_db = $db->query("SELECT * FROM files WHERE parent=" . $parentdir . " AND owner=" . $owner . ";"); +// $content_ar = $content_db->fetchArray(SQLITE3_NUM); - return $content_ar; + $count=0; + while($row = $content_db->fetchArray(SQLITE3_NUM)){ + $content[$count][0] = $row[0]; + $content[$count][1] = $row[1]; + $content[$count][2] = $row[2]; + $content[$count][3] = $row[3]; + $content[$count][4] = $row[4]; + $content[$count][5] = $row[5]; + $content[$count][6] = $row[6]; + $content[$count][7] = $row[7]; + $content[$count][8] = $row[8]; + //echo "" . $content[$count][3] . "
"; + $count++; + } + + return $content; } -- cgit v1.2.3