pear: Pager_Wrapper PDO扩展

最新推荐文章于 2021-01-19 06:03:50 发布

原创最新推荐文章于 2021-01-19 06:03:50 发布 · 2.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#wrapper #扩展 #query #numbers #function #list

PHP 专栏收录该内容

24 篇文章

订阅专栏

本文介绍了一个基于PDO的分页封装方法，该方法通过传递PDO对象、SQL语句及分页选项等参数实现数据库记录的分页展示。文章详细展示了如何计算总记录数、设置分页链接及每页显示的记录数。

/**
* PDO Database Wrapper of PEAR Pager
*
* @param resource $db The PDO object
* @param string $query SQL Statement
* @param array $pager_options Options of pager
* @param boolean $disabled Whether use pager,true will use ,or not use
* @param int $fetchMode
*/
function Pager_Wrapper_PDO(&$db, $query, $pager_options = array(), $disabled = false, $fetchMode = PDO::FETCH_ASSOC){
if (!array_key_exists('totalItems', $pager_options)) {
   if ($countQuery = rewriteCountQuery($query)) {
    $stmt = $db->prepare($countQuery);
    $stmt->execute();
    $totalItems = $stmt->fetchColumn();
   }else{
    $stmt = $db->prepare($query);
    $stmt->execute();
    $rows = $stmt->fetchAll(PDO::FETCH_COLUMN);
    $totalItems = count($rows);
   }
   $pager_options['totalItems'] = $totalItems;
}
    require_once 'Pager/Pager.php';
    $pager = Pager::factory($pager_options);

    $page = array();
    $page['links'] = $pager->links;
    $page['totalItems'] = $pager_options['totalItems'];
    $page['page_numbers'] = array(
        'current' => $pager->getCurrentPageID(),
        'total'   => $pager->numPages()
    );
    list($page['from'], $page['to']) = $pager->getOffsetByPageId();
    $page['limit'] = $page['to'] - $page['from'] +1;

    // fix offset
    // limit 1,10 can not retrive the first record of result set.
    $page['from'] = $page['from'] - 1;

    if (!$disabled) {
  $query .= 'LIMIT ' . $page['from'] . ', ' . $pager_options['perPage'];
    }
//    var_dump($query);
$stmt = $db->prepare($query);
$stmt->execute();
$page['data'] = $stmt->fetchAll($fetchMode);
    if ($disabled) {
        $page['links'] = '';
        $page['page_numbers'] = array(
            'current' => 1,
            'total'   => 1
        );
    }

//    var_dump($pager);
    return $page;
}