sorting/ filtering paginated results - don't want to duplicate work if it already exists

[eluser]compoundeye[/eluser]
Hello

I'm just about to code some pages where i want to be able to sort some tables of paginated data by clicking on the column, and maybe offer some filtering on column values.

I get how to do it on the back end, and have a fair idea of how i'll do it on the front end,
but i figure this must be something that other people are doing all the time,
so someone has probably already written a really nice library or some cut and paste-able functions to do exactly that.

can anyone please point me in the right direction?

thank you

mathew

[eluser]Référencement Google[/eluser]
You may consider a Javascript + Ajax based solution, some links using JQuery:

http://reconstrukt.com/ingrid/

http://webplicity.net/flexigrid/
(search also for Flexigrid on this forum, it is popular and some folks have already well implemented it with CI)

[eluser]compoundeye[/eluser]
thanks too,

I'll definitely use them for another project,
but for this one i need it too work without javascript, even though
that needs the inconvenience of reloading the page.

anyone got any suggestions?

[eluser]manilodisan[/eluser]
What's wrong with CI's pagination class? I see their documentation pretty well written...
http://ellislab.com/codeigniter/user-gui...ation.html

[eluser]compoundeye[/eluser]
oh nothing at all, in fact i'm planning on using pagination,

I thought someone might have written a snippet of code so i don't need to make the links on all the column headings

cheers

mat

[eluser]dpgtfc[/eluser]
[quote author="manilodisan" date="1222102274"]What's wrong with CI's pagination class? I see their documentation pretty well written...
http://ellislab.com/codeigniter/user-gui...ation.html[/quote]

How well does the pagination work if you use your own oracle connection model instead of the built in one?

My work uses Php 4.6 something and it looks like CI uses php5 OCI8 commands which just give me errors. Instead of dregging through the CI code I just wrote my own. However, I am also looking for a pagination option, and Oracle isn't as easy as MYSQL, and my PL/SQL skills aren't the greatest. I'd like to use CI, but I'm not sure if the support is there.