6 $iniarray=parse_ini_file("config.ini");
7 $DBFILE=$iniarray["fspotdb"];
8 $usePDO=$iniarray["usePDO"];
9 $N=$iniarray["pics_per_page"];
10 /* end parse ini-file */
12 if (isset($_REQUEST["P"]))
13 $OFFSET = "".($_REQUEST["P"]*$N-$N).",";
18 $DB = new PDO("sqlite:$DBFILE");
20 $DB = new SQlite3($DBFILE);
22 $result = $DB->query("SELECT * FROM photos LIMIT $OFFSET $N");
30 /* convert results into array */
32 while($res = $result->fetchArray(SQLITE3_ASSOC)){
38 foreach ($result as $res)
45 echo json_encode($row);
47 /* close the database */