Dit is het script van sampsonresume.com:
<?php
// Pagination
// database configuratie
$dbname = "****"; // database naam
$user = "****"; // gebruikersnaam van mysql
$pass = "****"; // wachtwoord van mysql
$host = "****"; // host naar mysql
$conn = mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db($dbname, $conn) or die(mysql_error());
// Get pageNumber
$pageNumber = (isset($_GET['page']) && is_numeric($_GET['page'])) ? $_GET['page'] : 1;
// Number of results per page
$perPage = 5;
// Padding value
$padding = 5;
// Get start index of results
$startIndex = (($pageNumber * $perPage) - $perPage);
// Get total number of database entries
$totalCount = "SELECT COUNT(*) as 'Total' FROM rs_arrest";
$rsCount = mysql_query($totalCount, $conn) or die(mysql_error());
$rowCount = mysql_fetch_array($rsCount);
// Show Page Listings
print '<div align="center">';
// Get our total number of pages
$numOfPages = ceil($rowCount['Total'] / $perPage);
// Print link to first page
print '<a href="pagination.php?page=1">FIRST</a> ';
// If our current page minus our padding is greater than 1
if(($pageNumber - $padding) > 0 ) {
print '... ';
// Set our lower limit
$lowerLimit = $pageNumber - $padding;
// Print all padded numbers between lowerLimit and current page
for($i = $lowerLimit; $i < $pageNumber; $i++) {
print '<a href="pagination.php?page='.$i.'">'.$i.'</a> ';
}
} else {
// Print all numbers between current page and first page
for($i = 2; $i < $pageNumber; $i++) {
print '<a href="pagination.php?page='.$i.'">'.$i.'</a> ';
}
}
// If we're not on the first or last page print current page
if(($pageNumber != 0) && ($pageNumber != 1) && ($pageNumber != $numOfPages)) {
print '<b> - ' . $pageNumber . ' - </b>';
}
// If current page plus padding is less than the total number of pages
if(($pageNumber + $padding) < $numOfPages) {
// Set upper limit
$upperLimit = $pageNumber + $padding;
// Print all numbers from padded page above current page
for($i = ($pageNumber + 1); $i <= $upperLimit; $i++) {
print '<a href="pagination.php?page='.$i.'">'.$i.'</a> ';
}
print '... ';
} else {
// Print all number of pages between number of pages and current page
for($i = ($pageNumber + 1); $i < $numOfPages; $i++) {
print '<a href="pagination.php?page='.$i.'">'.$i.'</a> ';
}
}
// Print link to last page
print '<a href="pagination.php?page='.$numOfPages.'">LAST</a> ';
print '</div>';
// Get page results
$sql = "SELECT id,titel
FROM rs_arrest
ORDER BY id
LIMIT $startIndex, $perPage";
// Get result set
$rs = mysql_query($sql, $conn) or die(mysql_error());
// Do we have results?
if(mysql_num_rows($rs) > 0) {
// Show the results
while($row = mysql_fetch_array($rs)) {
print '<div>';
print $row['id'];
print ': ';
print $row['titel'];
print '</div>';
}
} else {
print 'No results';
}
// Close our database connection
mysql_close($conn);
?>
