Pagination showing but pages not changing.
Pagination showing but pages not changing.
motobrandt
Posts: 2Questions: 0Answers: 0
Hello!
I've been using DataTables for various hand-coded php projects for the past couple of years. I'm just starting to work on a project that someone else has started and it's being used in a way that I haven't seen it before. It's Kohana Framework first of all which I'm trying to get learned up on as well.
The problem is I'm getting the results of the page just fine. For instance at a results page I'll see
[quote]Showing 1 to 10 of 81 entries[/quote]
And I'll be looking at the first 10 results of the 81 records, which is great!
However when I click on the Show 25 Entries option the page says
[quote]Showing 1 to 25 of 81 entries[/quote]
But it still just shows me the same 10 I started with.
We also have pagination set to "full_numbers" but I get the same bad behavior when I click on a separate page. For instance if I click Next from the first page it will say
[quote]Showing 11 to 20 of 81 entries[/quote]
But it still shows me the same 10 I started with.
If I look at the response I'm getting in Firebug I'm getting the same data back. So I'm guessing it has something to do with the calls to the model.
I thought I would ask this as a general question to see if someone had experienced this before. Personally this is the first time I've used datatables in the model like this.
Thanks!
I've been using DataTables for various hand-coded php projects for the past couple of years. I'm just starting to work on a project that someone else has started and it's being used in a way that I haven't seen it before. It's Kohana Framework first of all which I'm trying to get learned up on as well.
The problem is I'm getting the results of the page just fine. For instance at a results page I'll see
[quote]Showing 1 to 10 of 81 entries[/quote]
And I'll be looking at the first 10 results of the 81 records, which is great!
However when I click on the Show 25 Entries option the page says
[quote]Showing 1 to 25 of 81 entries[/quote]
But it still just shows me the same 10 I started with.
We also have pagination set to "full_numbers" but I get the same bad behavior when I click on a separate page. For instance if I click Next from the first page it will say
[quote]Showing 11 to 20 of 81 entries[/quote]
But it still shows me the same 10 I started with.
If I look at the response I'm getting in Firebug I'm getting the same data back. So I'm guessing it has something to do with the calls to the model.
I thought I would ask this as a general question to see if someone had experienced this before. Personally this is the first time I've used datatables in the model like this.
Thanks!
This discussion has been closed.
Replies
Well yeah... In the model we were setting the limit with a requestParam that was named wrongly. Two of them actually. The displayLength and the displayStart parameters used for the Limit and Offset in the query.
Welp, cheers!