RE: [PHP-DB] Paging large recordsets
| From: | Hutchins, Richard | Date: | Fri, 13 Feb 2004 18:35:21 +0000 |
| Subject: | RE: [PHP-DB] Paging large recordsets | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32942@lists.php.net to get a copy of this message | ||
I know phpclasses.org has a few recordset paging classes out there for your
convenience. Might want to try on a couple of those too just to see if they
fit.
Rich
> -----Original Message-----
> From: Robert Twitty [mailto:rtwitty@neutron.ushmm.org]
> Sent: Friday, February 13, 2004 1:34 PM
> To: Karen Resplendo
> Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] Paging large recordsets
>
>
> Most of the PHP solutions I have seeen require the use of session
> variables. You could create an array containing only the unique
> identifiers of all the records, and then store it into a
> session variable.
> You would then use another session variable to retain the
> page size, and
> then include the page numbers in the "Next", "Prev", "First",
> "Last" and
> "Absolutr" page links. Printing is probably best done with
> dynamically
> generated PDF instead of HTML.
>
> -- bob
>
> On Fri, 13 Feb 2004, Karen Resplendo wrote:
>
> > I guess the time has come that my boss wants "Next",
> "Previous", "First", "Last" paging for our data displays of
> large recordsets or datasets.
> >
> > Any good solutons out there already? I have pieces of a few
> examples.
> >
> > Also, how to deal with printing? I would assume that the
> ideal page size is not the ideal printed page size. oi vay!
> >
> > TIA
> >
> >
> > ---------------------------------
> > Do you Yahoo!?
> > Yahoo! Finance: Get your refund fast by filing online
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>