DataTables, cakePHP, and Pagination through Ajax
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 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+unsubscr...@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.
Re: DataTables, cakePHP, and Pagination through Ajax
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 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+unsubscr...@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. 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+unsubscr...@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.
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+unsubscr...@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+unsubscr...@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.