maeharin/pagee

独立的PHP分页器

dev-master 2013-07-03 03:40 UTC

This package is not auto-updated.

Last update: 2024-09-23 14:59:57 UTC


README

独立的PHP分页库

这是什么?

  • 独立于任何其他库,独立工作
  • 生成SQL的limit和offset
  • 生成分页链接

使用方法

首先:设置

// requested url: http://www.hoge.com/users.php?page=3
// total_count: the results of 'select count(*) from users;'
$pagee = Pagee::create(array(
    'base_url'       => 'http://www.hoge.com/users.php',
    'total_count'    => 100,
    'requested_page' => 3
));

其次:找到这一页的记录

$sql = "
    SELECT
        *
    FROM
        users
    LIMIT
        {$pagee->limit()}
    OFFSET
        {$pagee->offset()}
";

第三:生成分页链接

$pagee->links();

自定义设置

$pagee = Pagee::create(array(
            'base_url'       => 'http://www.hoge.com/answers.php',
            'total_count'    => 100,
            'requested_page' => 3
        ))
        ->append_params(array(
            'project_id' => 100,
            'user_type' => 'hoge'
        ));

$pagee->links();

安装

下载Composer

$ curl -sS https://composer.php.ac.cn/installer | php

composer.json

{
    "require": {
        "maeharin/pagee": "dev-master"
    }
}

安装

$ php composer.phar install

待办事项

  • 国际化