4 $iniarray=parse_ini_file("config.ini");
5 $DBFILE=$iniarray["fspotdb"];
6 $usePDO=$iniarray["usePDO"];
7 /* end parse ini-file */
9 if (isset($_REQUEST["O"]))
10 $O = "".$_REQUEST["O"].",";
14 if (isset($_REQUEST["N"]))
15 $N = "".$_REQUEST["N"];
20 $DB = new PDO("sqlite:$DBFILE");
22 $DB = new SQlite3($DBFILE);
24 $result = $DB->query("SELECT * FROM photos LIMIT $O $N");
32 /* convert results into array */
34 while($res = $result->fetchArray(SQLITE3_ASSOC)){
40 foreach ($result as $res){
49 echo json_encode($row);
51 /* close the database */