diff options
Diffstat (limited to 'www')
| -rw-r--r-- | www/select.php | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/www/select.php b/www/select.php index 8ad111e..1dda9cf 100644 --- a/www/select.php +++ b/www/select.php @@ -5,14 +5,26 @@ $db = new SQLite3("../database/sqlite.db"); $user=2; $parent=1; +$result_db = $db->query("SELECT id, parent, name, share FROM files WHERE parent=$parentdir AND owner=$owner AND folder='DIRECTORY' AND share='PUBLIC';"); +while(!empty($result=$result_db->fetchArray())){ + $dimension = count($result); + for($i=0;$i<$dimension;$i++){ + echo $result[$i][2]; + $parentdir=$result[$i][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=$result_db->fetchArray(); + } +} + +/* function select_db ($db, $owner, $parentdir){ $result_db = $db->query("SELECT id, parent, name, share FROM files WHERE parent=$parentdir AND owner=$owner AND folder='DIRECTORY' AND share='PUBLIC';"); $count=0; while ($result = $result_db->fetchArray()){ $array[$count]=$result; /*2D Array, an Stelle $count ist das $result Array mit Ergebnissen des SELECTs abgelegt*/ - $count++; +/* $count++; } return $array; } @@ -29,3 +41,4 @@ for($i=0;$i<$dimension;$i++){ echo "<br>"; } } +*/ |