README

一个用于简化分页的包

安装

composer require mahmoud-abdelfadeil/php-pagination

完整示例

<?php

use PhpPagination\Pagination;

include 'vendor/autoload.php';
$config_db=[
    "db_host"=>"localhost",
    "db_name"=>"pagination_test",
    "db_user"=>"root",
    "db_password"=>""
];
$pagination = new Pagination($config_db,2);

$users = $pagination->table('users')->column(['*'])->get();
echo "<pre>";
var_dump($users);
?>

<a href="<?php echo $pagination->prevPage() ?>">prev</a><br>

<a href="<?php echo $pagination->nextPage() ?>">next</a><br>

<a href="<?php echo $pagination->firstPage() ?>">first</a><br>

<a href="<?php echo $pagination->lastPage() ?>">last</a><br>

<p>page : <?php echo $pagination->currentPage()  ?> of <?php echo $pagination->countPages()  ?></p>

使用

1 - 包含 vendor 自动加载

include 'vendor/autoload.php';

2 - 使用 Pagination 类

use PhpPagination\Pagination;

3 - 数据库配置（数组键静态）

$config_db=[
    "db_host"=>"localhost",
    "db_name"=>"pagination_test",
    "db_user"=>"root",
    "db_password"=>""
];

4 - 创建 Pagination 对象（参数 1，参数 2）

// param 1 (required)=>array config database
// param 2 (optional)=>int count items [default 20]

$count_items=10; //  optional (default 20 items in 1 page)
$pagination = new Pagination($config_db , $count_item);

5 - 示例

$users = $pagination->table('users')->column(['*'])->get();
// tabel (table name)
// column (select column in table ) 
// column array | string 
// ex string
$users = $pagination->table('users')->column('*')->get();
$users = $pagination->table('users')->column('name , email')->get();

// ex array 
$users = $pagination->table('users')->column(['*'])->get();
$users = $pagination->table('users')->column(['name' , 'email'])->get();

5 - 辅助函数

prevPage() 上一页

nextPage() 下一页

firstPage() 首页

lastPage() 末页

currentPage() 当前页

countPages() 页数总数

<a href="<?php echo $pagination->prevPage() ?>">prev</a><br>

<a href="<?php echo $pagination->nextPage() ?>">next</a><br>

<a href="<?php echo $pagination->firstPage() ?>">first</a><br>

<a href="<?php echo $pagination->lastPage() ?>">last</a><br>

<p>page : <?php echo $pagination->currentPage()  ?> of <?php echo $pagination->countPages()  ?> </p> // output page : 49 of 53