Changed database schema again.

1 files changed, 17 insertions, 35 deletions

diff --git a/www/select.php b/www/select.php
index 3ee277e..f873b51 100644
--- a/www/select.php
+++ b/www/select.php
@@ -3,51 +3,33 @@
 //session_start();
 
 $db = new SQLite3("../database/sqlite.db");
-$owner=2;
-$folder=0;
+$user=2;
+$parent=0;
 
+
+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';");
+
+	while ($result = $result_db->fetchArray()){
+		$array[$count]=$result;			/*2D Array, an Stelle $count ist das $result Array mit Ergebnissen des SELECTs abgelegt*/
+		$count++;
+	}
+
+	return $array;
+}
+
+/*
 $rows = $db->query("SELECT count(*) as count FROM files WHERE owner=$owner;");
 $row = $rows->fetchArray();
 $numRows = $row["count"];
 
 for($i=0;$i<$numRows;$i++){
-	$result_db = $db->query("SELECT id, folder, name, public FROM files WHERE folder=$folder AND owner=$owner AND type='directory' AND public='share';");
-	$result_ar = $result_db->fetchArray(SQLITE3_NUM);
-	$folder=$result_ar[0];
-
-//	$laenge = $result_db->fetchArray();
-//	echo "query matches: ". count($laenge);
-
-
-	$count=0;
-//	$array[0]="";
-	while ($row = $result_db->fetchArray()) {
-// 		var_dump($row);
-//		echo "laenge row: " . count($row[name]) . " laenge result_db: " . count($result_db) . "";
-//		echo "row: " . $row["name"] . "<br>";
-//		$row_ar[$k]=$row["name"];
-//		echo "array: " . count($row_ar);
-//		print_r($row);
-		$array[$count]=$row;		/*2D Array, an Stelle $count ist das $row Array abgelegt */
-		echo $array[$count][2] . "<br>";
-//		echo "<br>";
-		$count++;
-	}
-
-//	$arraylength=count($array);
-	for($j=0;$j<$count;$j++){
-		echo $array[$j][2] . "<br>";	/*Gibt den Namen des Ordners aus dem $row Array aus*/
-	}
 
-//	echo "primary key: $result_ar[0]; parent dir: $result_ar[1]; dir name: $result_ar[2]; share stat: $result_ar[3]; length: " . count($result_ar) . "; numRows: $numRows";
-	echo "<br> dir name: $result_ar[2], $result_ar[3]; <br>";
 
-	if(!$db->exec("SELECT id FROM files WHERE folder=$folder;")){
+	if(!$db->exec("SELECT id FROM files WHERE folder=$parent;")){
 		echo "Break!";
 		exit;
 	}
 
 }
-
-
-//	SELECT id, folder, name, public FROM files WHERE folder=$folder AND owner=$owner AND type='directory' AND public='public';"
+*/