/* parse ini -file */
$iniarray=parse_ini_file("config.ini");
$DBFILE=$iniarray["fspotdb"];
+$usePDO=$iniarray["usePDO"];
/* end parse ini-file */
if (isset($_REQUEST["O"]))
else
$N= 25;
-$DB = new SQlite3($DBFILE);
+if($usePDO)
+ $DB = new PDO("sqlite:$DBFILE");
+else
+ $DB = new SQlite3($DBFILE);
$result = $DB->query("SELECT * FROM photos LIMIT $O $N");
-sqlite_close(DB);
-
$row = array();
$i = 0;
-while($res = $result->fetchArray(SQLITE3_ASSOC)){
-
+if(!$usePDO)
+ {
+ /* convert results into array */
+ $tmp=array();
+ while($res = $result->fetchArray(SQLITE3_ASSOC)){
+ $tmp[]=$res;
+ }
+ $result=$tmp;
+ }
+
+foreach ($result as $res){
+
$row[$i] = $res;
$i++;
echo json_encode($row);
+/* close the database */
+if($usePDO)
+ $DB=null;
+else
+ sqlite_close($DB);
+
?>