package paginate

hadi/paginate

Simple pagination class

Installation

composer require hadi/paginate

Usage

require_once __DIR__ . '/../vendor/autoload.php';

$config = [
    'host' => 'localhost',
    'name' => 'abworkout',
    'username' => 'root',
    'password' => '',
];

$db = new \Hadi\Database();                                             // https://github.com/im4aLL/pdo-mysql-driver
$db->connect($config);

$total = $db->query("SELECT id FROM orders")->get();

$paginate = new \Hadi\Paginate([
    'per_page' => 1,
    'page_param' => 'page',
    'page_url' => 'http://localhost/paginate/test/',
    'total_record' => count($total),
]);

$orders = $db->query("SELECT * FROM orders ".$paginate->limit())->get();

echo $paginate->limit().' <br><br>';

foreach($orders as $order) {
    echo $order->id.' - ';
    echo $order->order_number;
    echo '<br>';
}

$db->disconnect();

More usage

<br><br>
Total records: = $paginate->totalRecord() ?>





Page = $paginate->currentPage() ?> of = $paginate->totalPage() ?>






<a href="<?= $paginate->previousPageUrl() ?>">Previous page</a>
<a href="<?= $paginate->nextPageUrl() ?>">Next page</a>







<a href="<?= $paginate->firstPageUrl() ?>">First page</a>
<a href="<?= $paginate->lastPageUrl() ?>">Last page</a>







<?php
foreach($paginate->pages() as $page) {
    if($page['number']) {
        echo ' <a href="'.$page['url'].'">'.$page['number'].'</a> ';
    }
    else {
        echo ' ... ';
    }
}