PHPBuilder - better pagination



RSS Twitter
Snippets Databases

better pagination

by: Michael Ross
|
September 10, 2007

Version: 1.0

Type: Full Script

Category: Databases

License: GNU General Public License

Description: I found a tutorial that did basic pagination, but wound up with 3 lines of page numbers at the top & bottom of the page. (yikes!) This pagination script is similar to google's.



<html>
<head>
<title>Pagination playground</title>
<script type="text/javascript" language="javascript">
function submit_it()
<!--
{
document.limit.submit()
}
-->
</script>
<style type="text/css" language="css">
<!--
/* it's just style... use your own; mine sucks. */
a:visited { color:blue; text-decoration:none; }
a:hover { color:blue; text-decoration:underline; }
a:link { color:blue; text-decoration:none; }
.button { padding:0px 3px 3px 5px; border:solid 1px black; margin-left:2px; }
-->
</style>
</head>
<body>

<?php
#########################
# set config & defaults #
#########################
require_once("inc/db_vars.inc");        // Or wherever you keep your db connection config
$set_limit_min = 5;                     // This is the minimum number of records you want displayed on your results page
$set_limit_max = 30;                    // This is the maximum number of records you want displayed on your results page
$set_mark_min  = 3;                     // This is the minimum width for the pagination widget
$set_mark_max  = 9;                     // This is the maximum width for the pagination widget

$table = '';                            // The name of your mysql table
$fields = '';                           // What fields are you selecting? eg. $fields = 'fname, lname, email';
########################

// The information is passed via the url. If you'd rather use session or cookie vars, it 
// shouldn't be that hard to convert the script. The hrefs are at the bottom of the page.

$limit = (isset($_REQUEST['limit']))? $_REQUEST['limit'] : 'UNDEF';
$page  = (isset($_REQUEST['page']))? $_REQUEST['page'] : '1' ;
$mark  = (isset($_REQUEST['mark']))? $_REQUEST['mark'] : 'UNDEF';
$query = "SELECT COUNT(*) FROM $table";
$result = mysql_query($query);
$total_items = mysql_result($result, 0);


if((is_numeric($limit) == false) || ($limit < $set_limit_min) || ($limit > $set_limit_max)) {
       $limit = $set_limit_min;
}
if((!$page) || (is_numeric($page) == false) || ($page < 0) || ($page > $total_items)) {
        $page = 1;
}
if((!$mark) || (is_numeric($mark) == false) || ($mark < $set_mark_min) || ($mark > $set_mark_max)) {
        $mark = $set_mark_min;
}

// These two form inputs I used for development. Feel free to get rid of these if you don't like them.
// If you do, you can get rid of the trivial submit script in the <head> section as well.
echo "<form name=\"limit\" method=\"get\" action=\"index.php\">\n
        <p>Maximum results per page? <select name=\"limit\" onChange=\"submit_it()\">\n";
for($x = $set_limit_min; $x <= $set_limit_max; $x += 5) {
        $s = ($x == "$limit")? ' selected' : '';
        echo "<option$s>$x</option>\n";
}
echo "</select></p>\n";
echo "<p>Maximum width for pagination? <select name=\"mark\" onChange=\"submit_it()\">\n";
for($x = $set_mark_min; $x <= $set_mark_max; $x += 3) {
        $m = ($x == $mark)? ' selected' : '';
        echo "<option$m>$x</option>\n";
}

echo "</select></p>\n";



echo "</form>\n<br /><br />";

// $ff; as in fast forward. this var also does rewind. since $mark
// can change, we also want the $ff var to change with it.
$ff = $mark + 2;
$total_pages = ceil($total_items / $limit);
$set_limit   = $page * $limit - ($limit);
$query = "SELECT $fields FROM $table LIMIT $set_limit, $limit";
$result = mysql_query($query)or die(mysql_error());
if(!$result) {
        die(mysql_error());
}
$err = mysql_num_rows($result);
if($err == 0) {
        die("No matches.");
}
while($results = mysql_fetch_assoc($log_res)) {
        // This is where you grab your results from the query and
        // and format them. This next line is just an example of what
        // that might look like.
        echo("item: ".$results['id']."<br />\n");
}

// begin truncated pagination -->

// noearly and nolate just decide wheather or not to display the buttons "|< << >> >|"
// instead of page numbers. I did this because it doesn't make sense to display something
// like "|< << 3 4..." when "1 2 3 4..." takes up the same amount of room, and is visually
// and mathematically reasonable.
$noearly = ($page <= ($mark + 1))? 'true':'false';
$nolate  = ($page >= ($total_pages - $mark))? 'true':'false';
if($noearly == "true") {
        for($i = 1; $i < $page; $i++) {
                echo "<a href=\"index.php?limit=$limit&page=$i&mark=$mark\">$i </a>\n";
        }
}else{
        echo "<a href=\"index.php?mark=$mark&page=1&limit=$limit\" class=\"button\">|< </a>"; 
        $pagerw = (($page -$ff) < 1)? '1': ($page - $ff);
        echo "<a class=\"button\" href=\"index.php?mark=$mark&page=$pagerw\"><<</a>\n";
        for($i = $page - $mark +2; $i < $page; $i++) {
                echo "<a href=\"index.php?mark=$mark&page=$i&limit=$limit\"> $i </a>";
        }
}

// This just puts a bold number in the middle of the pagination bar
// indicating the current page number.
echo "<b>$page</b>\n ";

if($nolate == "true") {
        for($i = $page + 1; $i <= $total_pages; $i++) {
                echo "<a href=\"index.php?page=$i&mark=$mark&limit=$limit\">$i </a>\n";
        }
}else{
        for($i = $page + 1; $i <= $page + $mark -2; $i++) {
                echo "<a href=\"index.php?mark=$mark&page=$i&limit=$limit\"> $i </a>";
        }
        $ffmark = (($page + $ff) > $total_pages)? $total_pages : ($page + $ff);
        echo "<a class=\"button\" href=\"index.php?limit=$limit&mark=$mark&page=$ffmark\">>></a>\n 
        <a href=\"index.php?mark=$mark&page=$total_pages&limit=$limit\" class=\"button\"> >| </a>";
}
?>
</body>
</html>

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
Michael Ross

Comment:



Comment:

(Maximum characters: 1200). You have characters left.