From 56a9e2810315757f200b904c56694319a69fd321 Mon Sep 17 00:00:00 2001
From: root
Date: Wed, 19 Feb 2014 00:53:30 +0100
Subject: nothing works yet

---
 www/select.php | 52 +++++++++++++++++++++++++++++++++++++++++++++-------
 1 file changed, 45 insertions(+), 7 deletions(-)

(limited to 'www')

diff --git a/www/select.php b/www/select.php
index b263d48..3ee277e 100644
--- a/www/select.php
+++ b/www/select.php
@@ -2,14 +2,52 @@
 
 //session_start();
 
-$db = new SQLite$("../database/sqlite.db");
+$db = new SQLite3("../database/sqlite.db");
 $owner=2;
 $folder=0;
 
-//for($i=1;$i<6;$i++){
-	$result_db = $db->query("SELECT id, folder, name, public FROM files WHERE folder=$folder AND owner=$owner AND type='directory' AND public='public';");
+$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[1];
-	
-	echo "result_ar[1]: $result_ar[1]; result_ar[0]: $result_ar[0]";
-//}
+	$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;")){
+		echo "Break!";
+		exit;
+	}
+
+}
+
+
+//	SELECT id, folder, name, public FROM files WHERE folder=$folder AND owner=$owner AND type='directory' AND public='public';"
-- 
cgit v1.2.3