<?php
 
 include "paginationclass.php";
 
 
 $query="select * from table order by tablename asc";
 
 $passingparams="variable1=1&variable=2"; //extra parameters you would want to send
 
  //initializing the class
 
 $thispage=isset($_REQUEST['thispage'])?$_REQUEST['thispage']:1; //this is required
 
            $pager=new pagination($connection_link,$query,$thispage,100,$passingparams); //100 is the number of records per page
 
              $pager->type="normal"; //dropdown,normal
 
              $pager->pagingdistance="2"; //it is the distance of upper and lower part of the page number,can be 0 to show all the records
 
              $pager->prev="<"; //you can also put html tags or images instead of a character
 
              $pager->next=">";
 
              $pager->first="<<";
 
              $pager->last=">>";
 
              $pager->showifonepage=false; //if the records dont need pagination and they can be displayed in one page, by 'false' means the paging next and previous links would not be visible
 
              
 
//example usage in a loop?>
 
<?php $res=$pager->paginate(); //you can treat the result coming from pagination as a query link
 
     if(mysql_num_rows($res)==0){
 
         //some code here
 
     }
 
//values you can get from the pagination
 
$pager->first(); //will show a link that takes you to the first page, the link will be '<<' as supplied above
 
$pager->previous(); //will show a link that takes you to the previous page, the link will be '<' as supplied above
 
$pager->next(); //will show a link that takes you to the next page, the link will be '>' as supplied above
 
$pager->last(); //will show a link that takes you to the last page, the link will be '>>' as supplied above
 
 
$pager->numrecords; //will show you the total records found
 
$pager->thispage; //will show you what page are you on
 
$pager->numpages; //will show you the total number of pages?>
 
 |