<?php 
// Included file 
include("config.php") ; 
###################################################### 
## Start Paging System ############################## 
##################################################### 
// get page number 
$get = $_GET['page'] ; 
// set page to one if not set 
if (!isset($get)){ 
$get = 1 ;  }else{ 
$get = $_GET['page'] ; } 
// Query for retrieve all data 
$query = mysql_query("select * from test ") ; 
// Maximum records in page 
$max = 3 ; 
// Counting Rows Number 
$count = mysql_num_rows($query) ; 
// Get Number of pages needed 
$div = ceil($count/$max) ; 
$rem = $count % $div  ; 
// if 0 remain from the division 
if($rem == 0 ) { 
$pages = $div ;  } else { 
$pages = $div + 1  ; } 
// next and prev 
$prev = $get - 1 ; 
$next = $get + 1 ; 
// Type Firt record link 
if($get != 1){ 
echo "<a style='text-decoration: none; color: red; font-size: 12pt; font-weight: bold' 
 href='show.php?page=1'>&nbsp;[[First]]&nbsp;</a>" ; } 
// Type Prev record link 
if($get > 1) echo "<a style='text-decoration: none; color: blue; font-size: 12pt; font-weight: bold' 
 href='show.php?page=$prev'>&nbsp;[[Prev]]&nbsp;</a>" ; 
// type pages 
for ($i=1 ; $i <= $pages ; $i++){ 
if ($get == $i){ 
echo "<font size=4 color=violet><b>[$i]&nbsp;&nbsp;</b></font>" ; }else{ 
echo "<a style='text-decoration: none; color: red; font-size: 14pt; font-weight: bold' 
 href='show.php?page=$i'>$i</a>&nbsp;&nbsp;" ;}} 
// Type Next record link 
if($get < $div) echo "<a style='text-decoration: none; color: blue; font-size: 12pt; font-weight: bold' 
 href='show.php?page=$next'>&nbsp;[[Next]]&nbsp;</a>" ; 
// Type Last record link 
if($get != $pages){ 
echo  "<a style='text-decoration: none; color: red; font-size: 12pt; font-weight: bold' 
 href='show.php?page=$pages'>&nbsp;[[Last]]&nbsp;</a>" ;  } 
echo "<br>" ; 
// get limit value 
$limit = ($get * $max) - $max  ; 
// Query for retrieve data with limit 
$query2 = mysql_query("select * from test LIMIT  $limit,$max ") ; 
// Data from query 
while ($row = mysql_fetch_array($query2)){ 
####################################################### 
## End Of Paging System ############################## 
##################################################### 
echo $row['id']."&nbsp;- ".$row['test']."<br>" ; } 
  

?>