PHP Pager::getPagerData Examples

Example #1

File: display_top_latest_news_more.php Project: eyumay/ju.ejhs

        $page = min($page, $numPages);
        $offset = ($page - 1) * $limit;
        $ret = new stdClass();
        $ret->offset = $offset;
        $ret->limit = $limit;
        $ret->numPages = $numPages;
        $ret->page = $page;
        return $ret;
    }
}
$page = $_GET['page'];
$limit = 7;
$result = mysql_query("select count(*) from news");
$total = mysql_result($result, 0, 0);
// work out the pager values
$pager = Pager::getPagerData($total, $limit, $page);
$offset = $pager->offset;
$limit = $pager->limit;
$page = $pager->page;
// use pager values to fetch data
$is_published = "1";
$query = "select * from news WHERE is_published = '{$is_published}' order by id desc limit {$offset}, {$limit}";
$result = mysql_query($query);
//check if the id is set
if ($result == "") {
    ?>
	       <p> No News </p>
	      <?php 
} else {
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
        ?>

Example #2

File: general.php Project: Entellus/System

function showPaging($query, $res_set, $PageURL)
{
    global $db;
    $page = $_REQUEST['page'];
    $limit = 20;
    $sql = $query;
    $totalcom = count($res_set);
    $total = $totalcom;
    $pager = Pager::getPagerData($total, $limit, $page);
    $offset = $pager->offset;
    $limit = $pager->limit;
    $page = $pager->page;
    $sql .= " limit {$offset},{$limit}";
    $res_page = $db->select_data($sql);
    $total_com = count($res_page);
    Pager::getPaging_pagenum($PageURL, $page, $pager->numPages, $pager->limit);
    return $res_page;
}