diff options
| -rw-r--r-- | www/select.php | 12 |
1 files changed, 10 insertions, 2 deletions
diff --git a/www/select.php b/www/select.php index f0cd143..d1b6189 100644 --- a/www/select.php +++ b/www/select.php @@ -6,14 +6,22 @@ $db = new SQLite3("../database/sqlite.db"); $owner=2; $parentdir=0; $count=0; -$result_db = $db->query("SELECT id, parent, name, share FROM files WHERE parent=$parentdir AND owner=$owner AND folder='DIRECTORY' AND share='PUBLIC';"); +$result_db = $db->query("SELECT id, parent, name, share FROM files WHERE owner=$owner AND folder='DIRECTORY' AND share='PUBLIC';"); while($result[$count] = $result_db->fetchArray(SQLITE3_NUM)){ $count++; } +echo "Found " . $count . " folder. <br>"; + for($i=0;$i<$count;$i++){ - echo count($result); + + echo "name: " . $result[$i][2] . "<br>"; +/* + for($j=0;$j < count($result[$i]); $j++){ + echo "name: " . $result[$i][$j] . "<br>"; + } +*/ } /* |