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 */
13 $DB = new PDO("sqlite:$DBFILE");
15 $DB = new SQlite3($DBFILE);
18 /* do database query */
19 if (isset($_REQUEST["P"]))
21 $OFFSET = "".($_REQUEST["P"]*$N-$N);
23 $result = $DB->query("SELECT * FROM photos LIMIT $OFFSET, $N");
25 else if (isset($_REQUEST["T"]))
27 $result = $DB->query("SELECT count(*) as total FROM photos");
32 /* encode result as an array */
36 /* convert results into array */
37 while($res = $result->fetchArray(SQLITE3_ASSOC))
44 foreach($result as $res)
51 echo json_encode($result);
53 /* close the database */