<?php
class c_query{
public function query($sqlfind,$rowsPerPage=2,$pageNum=1,$range=2,$order="ASC",$style="grey") {
if(isset($_GET['page'])){ $pageNum = $_GET['page'];}
$offset = ($pageNum - 1) * $rowsPerPage;
$sql = mysql_query("$sqlfind ORDER BY `id` $order LIMIT $offset, $rowsPerPage");
$sql1total = mysql_query("$sqlfind ORDER BY `id` $order");
$numrows = mysql_num_rows($sql1total);
$maxPage = ceil($numrows /$rowsPerPage);
$self = $_SERVER['PHP_SELF']."?";
$nav = '';if ($numrows > 0){ $first = "<span class=\"pages $style active\">Page: $pageNum of $maxPage</span>"; }
if($pageNum > $range+1){$min5 = $pageNum-$range;}else{$min5 = 1;}
if($pageNum > 1){for($page = $min5; $page < $pageNum; $page++){$nav .= " <a class=\"pages $style ahref\" href=\"$self"."page=$page\">$page</a>";}}
$max5 = $pageNum+$range; if($max5 > $maxPage){$max5 = $maxPage;}
for($page = $pageNum; $page <= $max5; $page++){
if ($page == $pageNum){ $nav .= " <span class=\"pages $style active\">$page</span>"; }else{$nav .= " <a class=\"pages $style ahref\" href=\"$self"."page=$page\">$page</a>"; }}
if($maxPage == 1){$nav = "";}
if ($pageNum > 1){$page = $pageNum - $range-1; if($page < 1){$page = 1;} $prev = " <a class=\"pages $style ahref\" href=\"$self&page=$page\"><</a> "; $first .= " <a class=\"pages $style ahref\" href=\"$self"."page=1\">First</a> ";
}else{$prev = ' ';$first .= ' '; }
if ($pageNum < $maxPage){$page = $pageNum + $range+1; if($page > $maxPage){$page = $maxPage;} $next = " <a class=\"pages $style ahref\" href=\"$self&page=$page\">></a> ";$last = " <a class=\"pages $style ahref\" href=\"$self"."page=$maxPage\">Last</a> ";}else{$next = ' ';$last = ' ';}
$this->pages = "<div id=\"pagination\">$first $prev $nav $next $last</div>";
$this->queryarr = $sql;
}
}
$query = new c_query();
$query->query("SELECT * FROM `table`",1,1,1,"ASC","blue circle");
echo "$query->pages <br>";
?>
preferences:
59.53 ms | 402 KiB | 5 Q