Quick Links
Bible Search Christian Links
Online Bibles Link to Us
  Downloads Web Hosting  
  Domain Names  


PDA

View Full Version : Information: PHP - Simple Paging System


Master Jake
Jun 14th 2009, 12:04 AM
This is a paging system I wrote a long time ago. Keep in mind that this will generate as many links as there are pages at a time. So if you only want the last 3, current, and next 3 pages generated or something like this, don't use this code. That is a separate paging system that I wrote, but am not releasing right now because it looks too messy.




<?php
/* Paging System
Create a simple paging system which many great
websites use.

This script was created by Jake Chappell and is free to use.
Credit is not required but is always highly appreciated.

http://www.masterjakeonline.com/
skateparkceasercash@yahoo.com
*/

//-- EDITABLE --//
$PSYS_RESPP = 20; // The Number of Results Per Page
$PSYS_DEFURL = "tmtm.php"; // Default URL Paging System Is On
$PSYS_COUNT = mysql_fetch_assoc(mysql_query("SELECT COUNT(*) FROM `users`;")); // Count The Rows
//-- END EDITABLE --//

$PSYS_PAGENUM = $_GET["page"]; // Current Page Number
$PSYS_PAGENUM = mysql_real_escape_string($PSYS_PAGENUM); // MYSQL Escape It
if (!$PSYS_PAGENUM || $PSYS_PAGENUM < 1 || $PSYS_PAGENUM > ($PSYS_COUNT["COUNT(*)"] / $PSYS_RESPP) + 1)
$PSYS_PAGENUM = 1; // Error In Page Number, Set To Lowest Value (1)

// Previous Option
if (($PSYS_PAGENUM * $PSYS_RESPP) - ($PSYS_RESPP * 2) >= 0)
echo "<a href=\"" . $PSYS_DEFURL . "?page=" . ($PSYS_PAGENUM - 1) . "\">&laquo; Previous</a> |";
else
echo "&laquo; Previous |";

// Page Options
for ($PSYS_TEMP = 1; ($PSYS_TEMP * $PSYS_RESPP) - $PSYS_RESPP < $PSYS_COUNT["COUNT(*)"]; $PSYS_TEMP++)
{
if ($PSYS_TEMP == $PSYS_PAGENUM)
echo " " . $PSYS_TEMP . " |";
else
echo " <a href=\"" . $PSYS_DEFURL . "?page=" . $PSYS_TEMP . "\">" . $PSYS_TEMP . "</a> |";
}

// Next Option
if ($PSYS_PAGENUM * 20 < $PSYS_COUNT["COUNT(*)"])
echo " <a href=\"" . $PSYS_DEFURL . "?page=" . ($PSYS_PAGENUM + 1) . "\">Next &raquo;</a>";
else
echo " Next &raquo;";

// Setting Up The New Value For The Query
$PSYS_PAGENUM = ($PSYS_PAGENUM * $PSYS_RESPP) - $PSYS_RESPP;

// For Your Second Query, Add "LIMIT $PSYS_PAGENUM, $PSYS_RESPP" To The End
// Example: mysql_query("SELECT * FROM `users` LIMIT $PSYS_PAGENUM, $PSYS_RESPP;");

echo "<br /><br />";

?>

SA Topsites