Re: About XSLT/XML Pagination

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> wrote in message 
news:46A3180B.3020900@xxxxxxxxxxxx
> 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? 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux