navigate pages generated from the select query

Mentioned below is a PHP function , which can be used to navigate pages generated from
the select query . ie. in the form of << Previous || Next >>

<?


function PagerNextPrevious(&$sql,$pagesize,$class='txt'){

// Set Default Page Size to 20
if($pagesize=='')
$pagesize=20;
$page=get_post('page');
if($page!='NA'){
$beg=($page-1)*$pagesize;
$end=$pagesize;
}else{
$beg=0;
$end=$pagesize;
$page=1;
}
$rs=mysql_query($sql) ;
$nrows=mysql_num_rows($rs);
$sql=$sql.' limit $beg,$end';
$rs=mysql_query($sql);
$subrows=mysql_num_rows($rs);

if($nrows!=0){
$from=(int)($beg)+1;
$totalpages=(int)($nrows/$pagesize);
$frac=($nrows/$pagesize);
if(($frac-$totalpages)>0)
$totalpages+=1;
echo '( Page $page of $totalpages ) ';
if($page>1 ){
echo '<a class=$class href=''.selfq().'&page='.($page-1).''> <<Previous

</a>';
}
$next=$page+1;
if($next <=$totalpages ){

echo '<a class=$class href=''.selfq().'&page='.$next.''> Next

>> </a>';
}

}
}
// http://www.hanusoftware.com
// Assuming you have Opened connection to mysql database.

$sql=' Select * from Products ';

// Show the pager link in form of Previous||Next

PagerNextPrevious($sql,20,'text');

$rs=mysql_query($sql);
if(mysql_num_rows($rs)>0){
while($row=mysql_fetch_array($rs)){
echo $row['ProductName'].'
';

}
}




?>

Software Development India

Offshore Software Development Company India, Software Development India

Post Edited (hanusoftware) : 7/16/2007 12:03:21 PM GMT