how to pagination grid

[marceloatmartins]

Hi Dan,
I would like to know if is possible do pagination in a grip using UserSpice resources.
Thanks

[mudmin]

I don't have anything, but I'd be interested in adding that feature.

[Brandin]

Look at my most recent post where I talk about my System Logs section, that has pagnation, if you want I can post the code? Maybe it can be integrated in the future? Not sure if this is what you are looking for or not.

[marceloatmartins]

Hi Brandin,
Of course, if you can, so, post the code, please.
Everything is welcome.

Thanks

[Brandin]

Here is your PHP:
https://hastebin.com/axifofequb.sm

Define $countCount by doing your query or whatever your heart desires.

You can also remove the $total_pages = $countCount and define $total_pages directly from your query.

Then echo $pagnation:

Code:

<?php echo $pagination; ?>

[marceloatmartins]

Hi,
I will study this today and adapt it to my case, really good.
Thank you very much Brandin.

[Brandin]

You're most welcome! Happy to help!

[karsen]

A couple weeks late, but I use a jQuery plugin that does this exact thing and easily allows Ajax calls to update the content. If you're interested you can look at the documentation on this page: http://botmonster.com/jquery-bootpag/