www/select.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

<?

//session_start();

$db = new SQLite$("../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';");
	$result_ar = $result_db->fetchArray(SQLITE3_NUM);
//	$folder=$result_ar[1];
	
	echo "result_ar[1]: $result_ar[1]; result_ar[0]: $result_ar[0]";
//}