Let me Google that for you. http://letmegooglethatforyou.com/?q=php+pagination+class -- Joe On Jan 28, 2009, at 4:31 AM, kashi kashan wrote: > thanks for reply but i need pagenination through classes/ > function.reply > > --- On Wed, 1/28/09, Suman Rai <sumanraic001@xxxxxxxxx> wrote: > From: Suman Rai <sumanraic001@xxxxxxxxx> > Subject: Re: i need ur help about pagenation > To: php-objects@xxxxxxxxxxxxxxx > Date: Wednesday, January 28, 2009, 10:13 AM > > Hello Kashi, > > Check out this > > Just put > > #----------- --------- from here--- > > <?php > > $page="yourpage. php"; > > $PageNo=$_REQUEST[ 'PageNo'] ; > > if(!isset($PageNo) ) { > > $PageNo = 0; > > } > > $eu = ($PageNo - 0); > > $limit = 15; > > $this1 = $eu + $limit; > > $back = $eu - $limit; > > $next = $eu + $limit; > > $sql="SELECT * FROM tablename"; > > $result=mysql_ query($sql) or die(mysql_error( )); > > $total=mysql_ num_rows( $result); > > $sql2="SELECT * FROM tablename limit $eu, $limit"; > > $result2=mysql_ query($sql2) or die(mysql_error( )); > > $count2=mysql_ num_rows( $result2) ; > > if($count2>= 1){ > > ?> > > #----------- --------- ------- to here in the top of the table > where your data will displayed > > Display Table Data here Like > > Name | Address | Phone > > > > wihile loop { > > etc. > > } > > <?php > > } > > ?> > > //Paging goes here > > Put below code for page navigation anywhere of your page but not > before the above code. > > //Anchor for previous link > > <?php > > if($back >=0) { > > echo"<a href=$page?PageNo= ".$back." >Previous< /a>"; > > } ?> > > //Anchor for page numbers > > <?php > > $i=0; > > $l=1; > > for($i=0;$i < $total;$i=$i+ $limit){ > > if($i <> $eu){ > > echo "<a href=$page?PageNo= ".$i.">$l< /a> "; > > } > > else { echo "$l";} > > $l=$l+1; > > } > > ?> > > //Anchor for Next > > <?php > > if($this1 < $total) { > > echo "<a href=$page?PageNo= ".$next." >Next</a> "; > > } > > ?> > > Regards & Thank You, > > Suman K. Rai > > Cell: +977 98040 25616 > > rai.suman@yahoo. com | sumanrai1980@ gmail.com > > www.raisuman. myplace.com > > --- On Mon, 1/26/09, kashi kashan <ksncool@yahoo. com> wrote: > > From: kashi kashan <ksncool@yahoo. com> > > Subject: i need ur help about pagenation > > To: php-objects@ yahoogroups. com > > Date: Monday, January 26, 2009, 10:55 PM > > I m beginner in php so didn¢t know the right syntax of php > > and now I have a problem that I want to do pagination in my display > page with using class and function. So > > can any one of you help me?? rep as soon as possible. > > > > [Non-text portions of this message have been removed] > > ------------ --------- --------- ------ > > Are you looking for a PHP job? Join the PHP Professionals directory > Now! > > http://www.phpclass es.org/professio nals/Yahoo! Groups Links > > [Non-text portions of this message have been removed] > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
