Online PHP editor | rfc for DmA0S

<?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>"; ?>

3v4l.org

Active branches

Archived branches