i want numbers for pagination between previous and next
Posted: Fri Feb 19, 2010 4:52 am
hello dear coders i want numbers between prevous and next pls help me my code is below
Code: Select all
$perPage = 10;
$currentPage = isset($_GET['page']) && is_numeric($_GET['page']) ? (int) $_GET['page'] : 1;
if (!$result = mysql_query("SELECT id FROM items ORDER BY id DESC")) {
// Change to logging before going live
trigger_error('MYSQL ERROR: ' . mysql_error(), E_USER_ERROR);
exit;
}
$totalItems = mysql_num_rows($result);
// The items on the current page.
$offset = ($currentPage - 1) * $perPage;
$firstItem = $offset + 1;
$lastItem = $offset + $perPage < $totalItems ? $offset + $perPage : $totalItems;
// Some useful variables for making links.
$firstPage = 1;
$lastPage = ceil($totalItems / $perPage);
$prevPage = $currentPage - 1 > 0 ? $currentPage - 1 : 1;
$nextPage = $currentPage + 1 > $lastPage ? $lastPage : $currentPage + 1;
// Get the items for the current page
$sql = "SELECT * FROM items ORDER BY id DESC LIMIT $offset, $perPage";
if (!$result = mysql_query($sql)) {
// Change to logging before going live
trigger_error('MYSQL ERROR: ' . mysql_error(), E_USER_ERROR);
exit;
}
$items = array();
while ($row = mysql_fetch_assoc($result)) {
$items[] = $row;
}
foreach ($items as $item):
//table contents
endforeach: