PHP Pagination::showPrev Examples

Example #1

File: sorting.php Project: AnisYnov/PPE

//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());
        $array = mysql_fetch_assoc($result);
        $i = 0;
        foreach ($array as $key => $value) {
            if ($i > 0) {
                break;