X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=photo-tags.git;a=blobdiff_plain;f=getjson.php;fp=getjson.php;h=24a913f2977084a472e1e83b1a2d7243e17ab88e;hp=cbb9feea559cc144bf756dfb1a89e021e92dd65f;hb=01394769937f108ee0f3a8077b34bb5fc9bffe24;hpb=78ab005390d15e706f68d2beabfa0a4ad79e0703

diff --git a/getjson.php b/getjson.php
index cbb9fee..24a913f 100644
--- a/getjson.php
+++ b/getjson.php
@@ -1,27 +1,25 @@
 <?php
 
+$N=30;
+
 /* parse ini -file */
 $iniarray=parse_ini_file("config.ini");
 $DBFILE=$iniarray["fspotdb"];
 $usePDO=$iniarray["usePDO"];
+$N=$iniarray["pics_per_page"];
 /* end parse ini-file */
 
-if (isset($_REQUEST["O"]))
-  $O = "".$_REQUEST["O"].",";
-else
-  $O="";
-
-if (isset($_REQUEST["N"]))
-  $N = "".$_REQUEST["N"];
+if (isset($_REQUEST["P"]))
+  $OFFSET = "".($_REQUEST["P"]*$N).",";
 else
-  $N= 25;
+  $OFFSET = "";
 
 if($usePDO)
   $DB = new PDO("sqlite:$DBFILE");
 else
   $DB = new SQlite3($DBFILE);
 
-$result = $DB->query("SELECT * FROM photos LIMIT $O $N");
+$result = $DB->query("SELECT * FROM photos LIMIT $OFFSET $N");
 
 $row = array();
 
@@ -37,13 +35,11 @@ if(!$usePDO)
     $result=$tmp;
   }
 
-foreach ($result as $res){
-
+foreach ($result as $res)
+{
   $row[$i] = $res;
- 
   $i++;
-  
- }
+}
 
 
 echo json_encode($row);