Re: google style paginating
| From: | John Ryan | Date: | Thu, 21 Aug 2003 22:52:30 +0000 |
| Subject: | Re: google style paginating | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-160364@lists.php.net to get a copy of this message | ||
just split up your total number of results ($num_rows) by the results per
page (10, i think) and create a for loop to loop from page1 to pagex,
creating a link with offset for each one.
simple.
"Ted Conn" <tedc@scinet.com.mx> wrote in message
news:20030821210209.25304.qmail@pb1.pair.com...
> Hi I am new to this newsgroup and I plan on replying to all the posts I
can
> for now... but Id like to start out by asking a question. I am trying to
> paginate my sql results in 10 by 10, which I have been able to do no
> problem. but what I want to do is have the pages layed out in google style
> with (1)(2)(3)(4) etc etc and each one is clickeable that will take you to
> that page. I'll show you the code I am using now for next and back
> buttons...
>
>
>
> //located at top of page
> <?php
> include("include/conex.php");
> $link=Conectarse();
> ?>
>
> //start of body, this verifies that so is numeric, divisible by 10, and a
> valid number
> <?php
> $q="SELECT id FROM tblNoticias ORDER BY id ";
> $result=MYSQL_QUERY("$q",$link);
> $num_rows=(MYSQL_NUM_ROWS($result));
> if ( isset($_GET['so']) && is_numeric($_GET['so']) )
> {
> if ( ($_GET['so'] > $num_rows) || ($_GET['so'] < 0) )
> $so='0';
> else
> {
> if ($_GET['so'] % 10)
> $so='0';
> else
> $so=$_GET['so'];
> }
> }
> else
> $so='0';
> ?>
>
> //return results
>
> <?php
> $q="SELECT id,titulo,texto,img1_data FROM tblNoticias ORDER BY id DESC
LIMIT
> $so,10";
> $result=(MYSQL_QUERY("$q",$link));
> while ($row=(MYSQL_FETCH_ARRAY($result))){
> ?>
>
> // next and back buttons
>
> <?PHP
>
> if ( $so >=10)
> {
> $sortback= $so-10;
> echo "<A HREF=\"noticias_historia.php?so=$sortback\"
class=\"mainText\"><<
> Atras</A>" ;
> }
> ?>
> <?PHP
>
> $sortforth=$so + 10;
> $existencias=MYSQL_QUERY("SELECT id FROM tblNoticias LIMIT
> $sortforth,10",$link);
> $existencias=MYSQL_NUM_ROWS($existencias);
> if ( $existencias > 0 )
> echo " <A HREF =\"noticias_historia.php?so=$sortforth\"
> class=\"mainText\"> Siguiente >> </A>";
> ?>
>
>
> DID I PUT WAY TO MUCH CODE?? Sorry, and I apreciate your help.
>
> How can I implement the google style paging into this code?
>
> Thank you...
>
>
>
>
> Ted Conn Lider de Proyectos tedc@scinet.com.mx Scinet México S.A. de C.V.
> +52 (222) 294-05-95 al 97 Sin costo: 01-8000-DOTCOM Puebla · DF ·
Monterrey
> www.scinet.com.mx
>
>