Re: DataTables, cakePHP, and Pagination through Ajax

Jeremy, thanks for your response. I previously used the cakePHP
PaginatorHelper, and even have been able to get client side DataTables
fully working. The issue, is I have over a million rows in my table,
and all processing must be done on the server-side. Plus of course, I
use JQuery (vs Prototype), and want the UI functionality of the
DataTables plug in.

So, you mentioned "doing the same in jQuery". Have you specifically
tied cakePHP and DataTables together, and used server-side processing?
I can read the $_REQUEST variables iDisplayStart, iDisplayLength, etc.
on the server when doing a sort, but I am not sure how to tie in
iTotalRecords and iTotalDispalyRecords.

Any help, is appreciated.

Martin

On Mar 29, 12:07 am, Jeremy Burns <jeremybu...@me.com> wrote:
> Ajax pagination is quite simple - here's a good link using MooTools (I do exactly the same but using JQuery). Also, see the guide. Then look at the pagination section of the book, which spells out the pagination options (such as the footer text you refer to).
>
> Jeremy Burns
> jeremybu...@me.com
>
> On 29 Mar 2010, at 07:13, Martin wrote:
>
> > Has anyone used DataTables with cakePHP, successfully implemented
> > Pagination through Ajax, and can provide example code?
>
> > I am successfully populating the table from cakePHP, but am not
> > getting the footer line "Showing X to Y of Z entries", am not getting
> > paging, and am not sure how to pass the values iTotalRecords
> > iTotalDispalyRecords.
>
> > Any examples?
>
> > Thanks,
> > Martin
>
> > Check out the new CakePHP Questions sitehttp://cakeqs.organd help others with their CakePHP related questions.
>
> > You received this message because you are subscribed to the Google Groups "CakePHP" group.
> > To post to this group, send email to cake-php@googlegroups.com
> > To unsubscribe from this group, send email to
> > cake-php+unsubscribe@googlegroups.com For more options, visit this group athttp://groups.google.com/group/cake-php?hl=en
>
> > To unsubscribe from this group, send email to cake-php+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en

To unsubscribe from this group, send email to cake-php+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.