How to paginate results? 1

[MrT2005]

Using the following XSL as an exmaple, how could it be modified to include pagination of the results (ie. Previous, Next, 1,2,3,4 ) etc...

Keep in mind that I am using sorting and search parameters also.


<?xml version="1.0" encoding="ISO-8859-1" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="

http://www.w3.org/1999/XSL/Transform">

<xslutput method="html" encoding="ISO-8859-1" indent="yes"/>

<xslaram name="keyword">none</xslaram>
<xslaram name="keyregion">none</xslaram>
<xslaram name="sterm">none</xslaram>
<xslaram name="sorder">none</xslaram>


<xsl:template match="/">
<xsl:for-each select="fiches/fiche[texte/cattouristique=$keyword]">

<xsl:sort order="{$sorder}" select="
texte/fichetitre[$sterm='a'] |
texte/typeheberg[$sterm='b'] |
region/regionnseo[$sterm='c']
"/>

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="myBkgnd_{position() mod 2 -1}">
<td width="*" class="pad">
<a>
<xsl:attribute name="href">
<xsl:text>page-g.php?key=</xsl:text>
<xsl:value-of select="numero"/><xsl:text>&amp;keyword=</xsl:text><xsl:value-of select="texte/cattouristique"/>
</xsl:attribute>
<xsl:value-of select="texte/fichetitre" />
</a>
</td>
<td width="200" align="center" class="pad"><xsl:value-of select="texte/typeheberg" /></td>
<td width="100" align="center" class="pad"><xsl:value-of select="region/regionnseo" /></td>
</tr>
</table>
</xsl:for-each>
</xsl:template>


</xsl:stylesheet>

 

[JontyMC]

Not clear what you want. Whats the purpose of this project? What information are you trying to display and how do you want to display it? XSL-FO might be the way to go.

 

[MrT2005]

the existing code (posted above) displays the results based on the parameters put in. This all works fine.

The thing that is missing is the XSL code to paginate the results.

Pagination is when you split the results into pages and have links like "Previous, Next, page 1, page 2, page 3, page 4".

XSL-FO is not an option as we dont have support for that on the server.

 

[MrT2005]

any ideas?

 

[JontyMC]

Install an XSL-FO on your server.

If you really can't do that, you're gonna have to figure out a way to split the data up into pages. If you want help with that, you're probably best off posting an example of the html you produce.

 

[flumpy]

You _can_ do some sort of complicated count mechanism by passing variables in as to page size and page that you are on (i have done it in the past).

so for example, [NOT WORKING, INCREDIBLY SIMPLIFIED just here for the general gist]

<xsl:if test="count() > $pagesize and count() < $pagesize - $pagerange"> 
    <xsl:apply-templates/>
</xsl:if>

--- its not as easy as that tho, you have to do calculation and page ranges based on your page sizes, and that can be tricky. This method is wasteful and slow, as you are still processing nodes that are outside the page ranges.

However, its best to mark up your XML with <page number="1"/> tags really, especially if you are generating them on the fly with a database. That way, you can pick out only the pages you require.

Matt