Wallogit.com
2017 © Pedro Peláez
The simpliest PHP pagination class
, (*1)
composer require leoshtika/pagination
{
"require": {
"leoshtika/pagination": "~1.0"
}
}
query('SELECT count(*) FROM user')->fetch(PDO::FETCH_COLUMN);
// Instantiate the Pagination
$pagination = new Pagination($_GET['page'], $totalRecords, 10);
// Get records using the pagination
$sth = $dbh->prepare('SELECT * FROM user LIMIT :offset, :records');
$sth->bindValue(':offset', $pagination->offset(), PDO::PARAM_INT);
$sth->bindValue(':records', $pagination->getRecordsPerPage(), PDO::PARAM_INT);
$sth->execute();
$users = $sth->fetchAll(PDO::FETCH_OBJ);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Pagination</title>
<!-- Bootstrap -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css">
</head>
<body class="container-fluid">
<h1>Pagination!</h1>
<table class="table table-bordered table-hover">
<tr>
<th>ID</th>
<th>Name</th>
<th>Email</th>
<th>Address</th>
<th>Phone</th>
</tr>
<?php foreach ($users as $user) : ?>
<tr>
<td><?php echo $user->id; ?></td>
<td><?php echo $user->name; ?></td>
<td><?php echo $user->email; ?></td>
<td><?php echo $user->address; ?></td>
<td><?php echo $user->phone; ?></td>
</tr>
<?php endforeach; ?>
</table>
<?php echo $pagination->nav(); ?>
</body>
</html>
Enjoy!, (*2)
The simpliest PHP pagination class
MIT
The simpliest PHP pagination class
MIT
The simpliest PHP pagination class
MIT
The simpliest PHP pagination class
MIT
The simpliest PHP pagination class
MIT