From f15927102d020139c31befeee2ed58e3d662ff34 Mon Sep 17 00:00:00 2001 From: root Date: Thu, 20 Feb 2014 15:41:55 +0100 Subject: select --- www/select.php | 19 ++++++++++++++----- 1 file changed, 14 insertions(+), 5 deletions(-) diff --git a/www/select.php b/www/select.php index eb9ce8c..8ad111e 100644 --- a/www/select.php +++ b/www/select.php @@ -4,9 +4,9 @@ $db = new SQLite3("../database/sqlite.db"); $user=2; -$parent=0; +$parent=1; -function select_db ($parentdir, $owner, $db){ +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; @@ -14,9 +14,18 @@ function select_db ($parentdir, $owner, $db){ $array[$count]=$result; /*2D Array, an Stelle $count ist das $result Array mit Ergebnissen des SELECTs abgelegt*/ $count++; } - return $array; } -$row = select_db($parent, $user, $db); -var_dump($row); +$row = select_db($db, $user, $parent); +$dimension = count($row); +echo "dimension: " . $dimension . "
"; + +for($i=0;$i<$dimension;$i++){ + echo "length [$i]: " . count($row[$i]) . "
"; + + for($j=0;$j<4;$j++){ + print_r($row[$i][$j]); + echo "
"; + } +} -- cgit v1.2.3