PHP Pagination::showPageNumbers Examples

Example #1

File: sorting.php Project: AnisYnov/PPE

    return '<a href="?' . $orderquery . '&' . $sortquery . '">' . $text . '</a> ' . $sortarrow;
}
//---------------------------------------------------------------------------
//Counting Total Number of Rows
$totalrows = mysql_fetch_array(mysql_query("SELECT count(*) as total FROM `" . TABLE . "`"));
//Setting Item Limit Per Page
$limit = RECORDPERPAGE;
if (isset($_GET['page']) && is_numeric(trim($_GET['page']))) {
    $page = mysql_real_escape_string($_GET['page']);
} else {
    $page = 1;
}
$startrow = $Pagination->getStartRow($page, $limit);
//Create Page Links
if (SHOWPAGENUMBERS == true) {
    $pagination_links = $Pagination->showPageNumbers($totalrows['total'], $page, $limit);
} else {
    $pagination_links = null;
}
if (SHOWPREVNEXT == true) {
    $prev_link = $Pagination->showPrev($totalrows['total'], $page, $limit);
    $next_link = $Pagination->showNext($totalrows['total'], $page, $limit);
} else {
    $prev_link = null;
    $next_link = null;
}
//If OrderBy Not Set Or Invalid, Set Default
if ($totalrows['total'] > 0) {
    if (!isset($_GET['orderby']) or trim($_GET['orderby']) == "") {
        $sql = "SELECT * FROM `" . TABLE . "` LIMIT 1";
        $result = mysql_query($sql) or die(mysql_error());