Постраничная навигация

SELECT *
FROM t
ORDER BY id DESC
LIMIT ((PAGE — 1) * PER_PAGE), PER_PAGE

// Correction for statically placing items on pages when ordering them both
// descending. Just remove it and people will use google cache to discover
// what exactly search engine found on your slice action pages.
$applyCorrection = false;

if ($order == Order_DESC)
{
    $limitStart = ($totalPages - $currentPage) * $perPage;
    $applyCorrection = true;
} else {
    $limitStart = ($currentPage - 1) * $perPage;
}

$limitEnd = $perPage;

// AND HERE OUR UNUNDERSTANDABLE CODE GOES ]:->
if ($applyCorrection)
{
    // For statically placing, last page (number 1, heh) must contain $perPage
    // items. So, let's do a shift;
    $correction = $totalRows % $perPage;
    if ($correction == 0) { $correction = $perPage; }
    $limitStart -= ($perPage - $correction);
    // This should happen on first page and it happened. We've decreased too
    // much :(
    if ($limitStart < 0)
    {
        $limitEnd = $limitEnd + $limitStart;
        $limitStart = 0;
    }
}

// LIMIT {$limitStart}, {$limitEnd}

const PageNumber_Max = -1;

$currentPage = isset($_REQUEST['page']) && is_numeric($_REQUEST['page']) && $_REQUEST['page'] > 0 ? intval($_REQUEST['page']) : PageNumber_Max;

// Correction for statically placing items on pages when ordering them both
// descending. Just remove it and people will use google cache to discover
// what exactly search engine found on your slice action pages.
$applyCorrection = false;
if ($currentPage == PageNumber_Max)
{
    // First N items
    $currentPage = $totalPages;
} elseif ($order == Order_DESC) {
    // Else we should apply a correction
    $applyCorrection = true;
}

if ($order == Order_DESC)
{
    // As usual...
    $limitStart = ($totalPages - $currentPage) * $perPage;
} else {
    $limitStart = ($currentPage - 1) * $perPage;
}

$limitEnd = $perPage;

// AND HERE OUR UNUNDERSTANDABLE CODE GOES ]:->
if ($applyCorrection)
{
    // For statically placing, last page (number 1, heh) must contain $perPage
    // items. So, let's do a shift;
    $correction = $totalRows % $perPage;
    if ($correction == 0) { $correction = $perPage; }
    $limitStart -= ($perPage - $correction);
    // This should happen on first page and it happened. We've decreased too
    // much :(
    if ($limitStart < 0)
    {
        $limitEnd = $limitEnd + $limitStart;
        $limitStart = 0;
    }
}

$this->localView->assign("index", $currentPage == PageNumber_Max);
$this->localView->assign("correction", $totalRows % $perPage);
$this->localView->assign("nextPageLink", $this->_pageLink(max($totalRows / $perPage, 1)));

{foreach from=$news key=i item=item}
    {if $index and $correction and ($i eq $correction)}
        <div class="cutline" title="Все посты после этой линии будут повторены на следующей странице,  так что если вы хотите продолжать чтение, советую перейти на неё  прямо сейчас, щёлкнув мышью здесь." onclick="document.location = '{$nextPageLink}';"></div>
    {/if}

    <!-- HTML-код новости -->
{/foreach}