Page Pagination

[genecide]

Can you help with this one, I have a xxx number of products, and I need it have a pagination by 20 per page. Can you give a code how can I do this, actually I need this not for php but for my jsp code. Thanks in advance!

[knickerlas]

fYOu can get the 'general' technique from this tutorial:

http://www.phpbuilder.com/columns/rod20001214.php3

Nick

[mharju]

You just have to create 1 variable you send to your script: a variable that contains the current position on the products. The just print the new links like:

print "<a href=\"myscript.php?start=".($start+20)."\">Next 20</a><br>\n";
print "<a href=\"myscript.php?start=".($start-20)."\">Previous 20</a><br>\n";

if you have the products in an array, just do

for($i=$start;$i<($start+20);$i++)
print "Product: ".$arr[$i]."<br>\n";

On SQL, just skip the prods before the $start.

🙂Mikko

[genecide]

okay that's good but i need it in this format:

Page: 1 | 2 | 3 and there's no specific number of page the products could be 100 or more.

[mharju]

Okay... So... do like this:

1) Do the query
2) See how many whole page(s) there are
3) generate the links.

I'll explain the 2 last parts:
$numPages=round($numRowsInQuery/20);
print "Page: ";
for($i=0;$i<$numPages;$i++)
print "|<a href=\"myscript.php?start=".($i==0?($i)🙁$i*20))."\">$i</a>|\n";
print "<br>\n";

There. Hope it works since I just wrote it so I haven't tested it. It should work though.

🙂Mikko

[Anon]

for Mikko,

I tried your script and it seems like it should work --I get the right number of links and everything, but the problem is that if the search finds 160 items, it shows all 160 on the first page along with your links. the only way I can think of to stop all 160 from showing up is with "LIMIT 0, 20" on the select statement. but this of course throws off the $numPages variable. I end up with only 20 records found and a single link to "page 0".

The other thing I tried was to use "Limit $start, 20", but of course I get the same problem, since "$start" is going to be o anyway on the first page. How can I get the total number of rows found and not just the total that is being limited? Thanks

--dw