README

一个基于msqly的分页库

使用方法

要使用此库，请参考以下示例

要求

数据库管理库

composer require sandro/php-database-manager

composer require sandro/php-pagination

<?php

require 'vendor/autoload.php';

use SandroAmancio\DatabaseManager\Database;
use SandroAmancio\PaginationManager\Pagination;

//DATABASE CREDENTIALS
$dbHost = 'localhost';
$dbName = 'database';
$dbUser = 'root';
$dbPass = 'pass';
$dbPort = 3306;

//CONFIG DATABASE CLASS
Database::config($dbHost,$dbName,$dbUser,$dbPass,$dbPort);

//TABLE INSTANCE
$obDatabase = new Database('table_name');

//COUNT TOTAL RESULTS
$totalResults = $obDatabase->select('id > 10',null,null,'COUNT(*) as total')->fetchObject()->total;

//CURRENT PAGE
$currentPage  = $_GET['page'] ?? 1;
$itemsPerPage = 10;

//PAGINATION
$obPagination = new Pagination($totalResults,$currentPage,$itemsPerPage);

//SELECT (return a PDOStatement object)
$results = $obDatabase->select('id > 10',null,$obPagination->getLimit());

//PAGES (array)
$pages = $obPagination->getPages();

要求者

PHP >= 7.0
composer require sandro/php-database-manager

sandro / php-pagination

维护者

详细信息

README

使用方法

要求

要求者