folder creation is updated

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);