Re: pagination example?
| From: | xkorakidis | Date: | Wed, 23 Nov 2005 11:15:05 +0000 |
| Subject: | Re: pagination example? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40719@lists.php.net to get a copy of this message | ||
hmmm,
it seems simple, althought I didn't yet understand what exactly takes
part in
$page = (!is_numeric($_GET['page'])) ? '1' : round($_GET['page']);
it seems like a c expression : if page is not numeric page=1 else round
page?
How does the $perpage increase?
couldn't we use smth $page++ ?
Thanks.
Unnawut Leepaisalsuwanna wrote:
> $perpage = 10;
> $page = (!is_numeric($_GET['page'])) ? '1' :
> round($_GET['page']);
>
> $page = ($page-1) * $perpage;
> $sql = 'SELECT * FROM
table WHERE 1 LIMIT '. $page
> .', '. $perpage;
>
> something like this?
>
> xkorakidis wrote:
>
>>Hi, I'm trying to find a simple example for pagination in php-mysql. I
>>found smth in php classes but it seems too complex (3-4 files and things
>>not so simple). Is there any simple way to do that?
>>Thanks.
>>
>>
>>
>
>