Re: About XSLT/XML Pagination
| From: | Tony Marston | Date: | Sun, 22 Jul 2007 15:04:33 +0000 |
| Subject: | Re: About XSLT/XML Pagination | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-259333@lists.php.net to get a copy of this message | ||
You misunderstand that article. All pagination is done within the program
code in order to construct the SQL query with the relevant LIMIT and OFFSET
values. The entire result set is then extracted from the database and
written to an XML file, and the XSL transforms the whole XML file into a
single HTML document, after which the XML document is discarded. The HTML
document contains hyperlinks which allow the user to select the number of
rows per page and the desired page number and these selections are processed
within the PHP code. There is no process which goes back to the previous XML
file to extract just a subset of the rows that need to be displayed as each
page is extracted directly from the database.
--
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
"Kelvin Park" <kelvinpark86@gmail.com> wrote in message
news:46A3180B.3020900@gmail.com...
> http://www.tonymarston.net/php-mysql/xsl.html#a1
> This site generally explains how pagination is done with xslt and xml.
> However it does not fully explain how to paginate the data when a certain
> number of rows are printed.
> For example, it wouldn't make another page after 100 item names were
> printed out where total there are 1000 items that need to be printed out,
> making it total 10 pages.
> Do you know what should be added in order to make it work?