1. Go to this page and download the library: Download sandro/php-pagination library. Choose the download type require.
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
sandro / php-pagination example snippets
androAmancio\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();
Shell
composer uire sandro/php-pagination
Loading please wait ...
Before you can download the PHP files, the dependencies should be resolved. This can take some minutes. Please be patient.