need to restrict this still to not show all, e.g. add first and last button to next and prev and only show a few page links
$N=$iniarray["pics_per_page"];
/* end parse ini-file */
$N=$iniarray["pics_per_page"];
/* end parse ini-file */
-if (isset($_REQUEST["P"]))
- $OFFSET = "".($_REQUEST["P"]*$N-$N).",";
-else
- $OFFSET = "";
-
if($usePDO)
$DB = new PDO("sqlite:$DBFILE");
else
$DB = new SQlite3($DBFILE);
if($usePDO)
$DB = new PDO("sqlite:$DBFILE");
else
$DB = new SQlite3($DBFILE);
-$result = $DB->query("SELECT * FROM photos LIMIT $OFFSET $N");
+/* do database query */
+if (isset($_REQUEST["P"]))
+ {
+ $OFFSET = "".($_REQUEST["P"]*$N-$N);
+ $result = $DB->query("SELECT * FROM photos LIMIT $OFFSET, $N");
+ }
+else if (isset($_REQUEST["T"]))
+ {
+ $result = $DB->query("SELECT count(*) as total FROM photos");
+ }
+else
+ $result=null;
+/* encode result as an array */
+$tmp=array();
if(!$usePDO)
{
/* convert results into array */
if(!$usePDO)
{
/* convert results into array */
- $tmp=array();
- while($res = $result->fetchArray(SQLITE3_ASSOC)){
- $tmp[]=$res;
- }
- $result=$tmp;
+ while($res = $result->fetchArray(SQLITE3_ASSOC))
+ {
+ $tmp[]=$res;
+ }
+else
+ {
+ foreach($result as $res)
+ {
+ $tmp[]=$res;
+ }
+ }
+$result=$tmp;
-foreach ($result as $res)
-{
- $row[$i] = $res;
- $i++;
-}
-
-
-echo json_encode($row);
+echo json_encode($result);
/* close the database */
if($usePDO)
/* close the database */
if($usePDO)
<button class="next" onclick="right()">next </button>
<div class="permalink"></div>
<button class="next" onclick="right()">next </button>
<div class="permalink"></div>
+<div class="index"></div>
<div class="pics"> </div>
<footer>
<div class="pics"> </div>
<footer>
var count=0;
function myreload(a) {
var count=0;
function myreload(a) {
+ d3.json("<?php echo $webbase?>/getjson.php?T=1", function(json) {
+ s="page ";
+ n = json[0].total/N;
+ for(i=1;i<=n+1;i++)
+ {
+ s+=" <a href=\"<?php echo $webbase?>/page/"+i+"\">"+i+"</a>";
+ }
+ d3.select(".index").html(s);
+ });
d3.json("<?php echo $webbase?>/getjson.php?P="+a, function(json) {
count=0;
pics.selectAll("li").remove();
d3.json("<?php echo $webbase?>/getjson.php?P="+a, function(json) {
count=0;
pics.selectAll("li").remove();
permalink="<?php echo $webbase ?>/page/"+page;
d3.select(".permalink").html("Permalink: <a href=\""+permalink+"\">"+permalink+"</a>");
permalink="<?php echo $webbase ?>/page/"+page;
d3.select(".permalink").html("Permalink: <a href=\""+permalink+"\">"+permalink+"</a>");
- d3.select(".debug").text("P, count= "+a+" "+count);
+ d3.select(".debug").text("P,N ="+a+" "+N);
-body {background-color: black}
+body {
+ background-color: black;
+ color: #eee;
+}
.permalink {
float:right;
.permalink {
float:right;
a[visited]{ color: #aaa;}
a[visited]{ color: #aaa;}
+.index {
+ margin: 0 auto;
+ width:70%;
+}
+
.pics li {
display: inline;
list-style: none;
.pics li {
display: inline;
list-style: none;
color: #999;
float:right;
}
color: #999;
float:right;
}
+
+
+.debug { position: absolute; top:0; left:0}
\ No newline at end of file