diff options
| -rw-r--r-- | www/createfolder.php | 6 | ||||
| -rw-r--r-- | www/select.php | 9 |
2 files changed, 9 insertions, 6 deletions
diff --git a/www/createfolder.php b/www/createfolder.php index f1bca21..c559691 100644 --- a/www/createfolder.php +++ b/www/createfolder.php @@ -36,7 +36,7 @@ if($_SERVER['REQUEST_METHOD'] == 'POST'){ $db = new SQLite3("../database/sqlite.db"); - $id_db = $db->query("SELECT id FROM user WHERE name=$sname;") + $id_db = $db->query("SELECT id FROM user WHERE name='$sname';"); $id_ar = $id_db->fetchArray(SQLITE3_NUM); $id = $id_ar[0]; @@ -86,8 +86,8 @@ if($_SERVER['REQUEST_METHOD'] == 'POST'){ <p> Public? <input type='text' name='public'></p> <p> pwd: <input type='text' name='pwd'></p> <input type='hidden' name='username' value='$_SESSION[username]'> - <input type='hidden' name='type' value='FOLDER'> - <input type='submit' name='submit' value='invite'> + <input type='hidden' name='type' value='DIRECTORY'> + <input type='submit' name='submit' value='create'> </form>"; echo "END"; diff --git a/www/select.php b/www/select.php index c609dbe..eb9ce8c 100644 --- a/www/select.php +++ b/www/select.php @@ -6,10 +6,10 @@ $db = new SQLite3("../database/sqlite.db"); $user=2; $parent=0; +function select_db ($parentdir, $owner, $db){ + $result_db = $db->query("SELECT id, parent, name, share FROM files WHERE parent=$parentdir AND owner=$owner AND folder='DIRECTORY' AND share='PUBLIC';"); -function select_db ($parentdir, $owner){ - $result_db = $db->query("SELECT id, folder, name, public FROM files WHERE parent=$parentdir AND owner=$owner AND type='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++; @@ -17,3 +17,6 @@ function select_db ($parentdir, $owner){ return $array; } + +$row = select_db($parent, $user, $db); +var_dump($row); |