// Adam's Custom PHP MySQL Pagination Tutorial and Script
// You have to put your mysql connection data and alter the SQL queries(both queries)
// This script is in tutorial form and is accompanied by the following video:
mysql_connect("DB_Host_Here","DB_Username_Here","DB_Password_Here") or die (mysql_error());
mysql_select_db("DB_Name_Here") or die (mysql_error());
//////////////? QUERY THE MEMBER DATA INITIALLY LIKE YOU NORMALLY WOULD
$sql = mysql_query("SELECT id, firstname, country FROM myTable ORDER BY id ASC");
//////////////////////////////////// Adam's Pagination Logic ////////////////////////////////////////////////////////////////////////
$nr = mysql_num_rows($sql); // Get total of Num rows from the database query
if (isset($_GET['pn'])) { // Get pn from URL vars if it is present
??? $pn = preg_replace('#[^0-9]#i', '', $_GET['pn']); // filter everything but numbers for security(new)
??? //$pn = ereg_replace("[^0-9]", "", $_GET['pn']); // filter everything but numbers for security(deprecated)
} else { // If the pn URL variable is not present force it to be value of page number 1
??? $pn = 1;
}
//This is where we set how many database items to show on each page
$itemsPerPage = 10;
// Get the value of the last page in the pagination result set
$lastPage = ceil($nr / $itemsPerPage);
// Be sure URL variable $pn(page number) is no lower than page 1 and no higher than $lastpage
if ($pn < 1) { // If it is less than 1
??? $pn = 1; // force if to be 1
} else if ($pn > $lastPage) { // if it is greater than $lastpage
??? $pn = $lastPage; // force it to be $lastpage's value
}
// This creates the numbers to click in between the next and back buttons
// This section is explained well in the video that accompanies this script
$centerPages = "";
$sub1 = $pn - 1;
$sub2 = $pn - 2;
$add1 = $pn + 1;
$add2 = $pn + 2;
if ($pn == 1) {
??? $centerPages .= '? ' . $pn . ' ?';
??? $centerPages .= '? ' . $add1 . ' ?';
} else if ($pn == $lastPage) {
??? $centerPages .= '? ' . $sub1 . ' ?';
??? $centerPages .= '? ' . $pn . ' ?';
} else if ($pn > 2 && $pn < ($lastPage - 1)) {
??? $centerPages .= ' ' . $sub2 . ' ?';
??? $centerPages .= '? ' . $sub1 . ' ?';
??? $centerPages .= '? ' . $pn . ' ?';
??? $centerPages .= '? ' . $add1 . ' ?';
??? $centerPages .= '? ' . $add2 . ' ?';
} else if ($pn > 1 && $pn < $lastPage) {
??? $centerPages .= '? ' . $sub1 . ' ?';
??? $centerPages .= '? ' . $pn . ' ?';
??? $centerPages .= '? ' . $add1 . ' ?';
}
// This line sets the "LIMIT" range... the 2 values we place to choose a range of rows from database in our query
$limit = 'LIMIT ' .($pn - 1) * $itemsPerPage .',' .$itemsPerPage;
// Now we are going to run the same query as above but this time add $limit onto the end of the SQL syntax
// $sql2 is what we will use to fuel our while loop statement below
$sql2 = mysql_query("SELECT id, firstname, country FROM myTable ORDER BY id ASC $limit");
//////////////////////////////// END Adam's Pagination Logic ////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////// Adam's Pagination Display Setup /////////////////////////////////////////////////////////////////////
$paginationDisplay = ""; // Initialize the pagination output variable
// This code runs only if the last page variable is ot equal to 1, if it is only 1 page we require no paginated links to display
if ($lastPage != "1"){
??? // This shows the user what page they are on, and the total number of pages
??? $paginationDisplay .= 'Page ' . $pn . ' of ' . $lastPage. ' ? ? ';
??? // If we are not on page 1 we can place the Back button
??? if ($pn != 1) {
??????? $previous = $pn - 1;
??????? $paginationDisplay .=? ' ? Back ';
??? }
??? // Lay in the clickable numbers display here between the Back and Next links
??? $paginationDisplay .= '' . $centerPages . '';
??? // If we are not on the very last page we can place the Next button
??? if ($pn != $lastPage) {
??????? $nextPage = $pn + 1;
??????? $paginationDisplay .=? ' ? Next ';
??? }
}
///////////////////////////////////// END Adam's Pagination Display Setup ///////////////////////////////////////////////////////////////////////////
// Build the Output Section Here
$outputList = '';
while($row = mysql_fetch_array($sql2)){

??? $id = $row["id"];
??? $firstname = $row["firstname"];
??? $country = $row["country"];

??? $outputList .= '

' . $firstname . '

' . $country . '