blob: f873b51f14d75c5d2172e20ea8653b763fdead8e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
<?
//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;
}
}
*/
|
