$itemsPerPage = 10;
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$offset = ($page - 1) * $itemsPerPage;
// Query database with LIMIT and OFFSET using $offset and $itemsPerPage
code
Paginate Database Queries with LIMIT and OFFSET
database queries
LIMIT
OFFSET
items per page
$_GET
page