<?

//session_start();

$db = new SQLite3("../database/sqlite.db");
$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++){


	if(!$db->exec("SELECT id FROM files WHERE folder=$parent;")){
		echo "Break!";
		exit;
	}

}
*/