pagination

The codes for the class. " paginator.class.php "


class Paginator{
var $items_per_page;
var $items_total;
var $current_page;
var $num_pages;
var $mid_range;
var $low;
var $high;
var $limit;
var $return;
var $default_ipp = 10;
var $querystring;

function Paginator()
{
$this->current_page = 1;
$this->mid_range = 7;
$this->items_per_page = (!empty($_GET['ipp'])) ? $_GET['ipp']:$this->default_ipp;
}

function paginate()
{
if($_GET['ipp'] == 'All')
{
$this->num_pages = ceil($this->items_total/$this->default_ipp);
$this->items_per_page = $this->default_ipp;
}
else
{
if(!is_numeric($this->items_per_page) OR $this->items_per_page <= 0) $this->items_per_page = $this->default_ipp;
$this->num_pages = ceil($this->items_total/$this->items_per_page);
}
$this->current_page = (int) $_GET['page']; // must be numeric > 0
if($this->current_page < 1 Or !is_numeric($this->current_page)) $this->current_page = 1;
if($this->current_page > $this->num_pages) $this->current_page = $this->num_pages;
$prev_page = $this->current_page-1;
$next_page = $this->current_page+1;

if($_GET)
{
$args = explode("&",$_SERVER['QUERY_STRING']);
foreach($args as $arg)
{
$keyval = explode("=",$arg);
if($keyval[0] != "page" And $keyval[0] != "ipp") $this->querystring .= "&" . $arg;
}
}

if($_POST)
{
foreach($_POST as $key=>$val)
{
if($key != "page" And $key != "ipp") $this->querystring .= "&$key=$val";
}
}

if($this->num_pages > 10)
{
$this->return = ($this->current_page != 1 And $this->items_total >= 10) ? "items_per_page$this->querystring\">« Previous ":"« Previous ";

$this->start_range = $this->current_page - floor($this->mid_range/2);
$this->end_range = $this->current_page + floor($this->mid_range/2);

if($this->start_range <= 0)
{
$this->end_range += abs($this->start_range)+1;
$this->start_range = 1;
}
if($this->end_range > $this->num_pages)
{
$this->start_range -= $this->end_range-$this->num_pages;
$this->end_range = $this->num_pages;
}
$this->range = range($this->start_range,$this->end_range);

for($i=1;$i<=$this->num_pages;$i++)
{
if($this->range[0] > 2 And $i == $this->range[0]) $this->return .= " ... ";
// loop through all pages. if first, last, or in range, display
if($i==1 Or $i==$this->num_pages Or in_array($i,$this->range))
{
$this->return .= ($i == $this->current_page And $_GET['page'] != 'All') ? "num_pages\" class=\"current\" href=\"#\">$i ":"num_pages\" href=\"$_SERVER[PHP_SELF]?page=$i&ipp=$this->items_per_page$this->querystring\">$i ";
}
if($this->range[$this->mid_range-1] < $this->num_pages-1 And $i == $this->range[$this->mid_range-1]) $this->return .= " ... ";
}
$this->return .= (($this->current_page != $this->num_pages And $this->items_total >= 10) And ($_GET['page'] != 'All')) ? "items_per_page$this->querystring\">Next »\n":"» Next\n";
$this->return .= ($_GET['page'] == 'All') ? "All \n":"querystring\">All \n";
}
else
{
for($i=1;$i<=$this->num_pages;$i++)
{
$this->return .= ($i == $this->current_page) ? "$i ":"items_per_page$this->querystring\">$i ";
}
$this->return .= "querystring\">All \n";
}
$this->low = ($this->current_page-1) * $this->items_per_page;
$this->high = ($_GET['ipp'] == 'All') ? $this->items_total:($this->current_page * $this->items_per_page)-1;
$this->limit = ($_GET['ipp'] == 'All') ? "":" LIMIT $this->low,$this->items_per_page";
}

function display_items_per_page()
{
$items = '';
$ipp_array = array(10,20,30,40,'All');
foreach($ipp_array as $ipp_opt) $items .= ($ipp_opt == $this->items_per_page) ? "$ipp_opt\n":"$ipp_opt\n";
return "Results per page:querystring';return false\">$items\n";
}


function display_pages()
{
return $this->return;
}
}





The codes for the page i want the results to display, "pagination.php"

include("IndexHeader.php");
include("paginator.class.php");
?>

// *** Setup db connection variables.
$Database = 'test';
$Server = 'localhost';
$username = 'root';
$password = '';

// *** Make connection to target db.
$conn = mysql_connect($Server, $username, $password);
if (!$conn) {
exit("CONNECTION ERROR: " . mysql_error());
} else {
mysql_select_db ($Database);
}

$string = "SELECT * FROM govn_subscribe ORDER BY Email ASC, TIME ASC";
$query = mysql_query($string) or die (mysql_error());
$num_rows = mysql_num_rows($query);
if($num_rows>0)
{
$pages = new Paginator;
$pages->items_total = $num_rows;
$pages->paginate();
echo $pages->display_pages();
echo $pages->display_items_per_page();
}
else
{
echo "No records found";
}



echo "

";
$string = $string."$pages->limit";
$query = mysql_query($string) or die (mysql_error());
$result = mysql_fetch_array($query);
if($result==true)
{
do
{
echo("

List of Users from Government Subscribe Table

");
$tableRow = '';
while($row = mysql_fetch_assoc($query)) {
$id = $row['ID'];
$email = $row['Email'];
$time = $row['Time'];
$tableRow .= " $email$time
Delete |
Edit |
Transfer to Unsubscribe ";
}
$tableHeader = " EMAILTIMEACTION ";
echo("$tableHeader $tableRow
");

}
while($result = mysql_fetch_array($query));
}
echo "

";
if($num_rows>0)
{
echo $pages->display_pages().$pages->display_items_per_page();
}
?>