CakePhp Pagination Issue with Group by Solution

It is easy to use in Cakephp it built in pagination in a simple way. But if you will try to use Group By keyword in querying your data. The pagination will return unexpected result. I have notice that the total number of data count is not correct. I Google about this issue, read a blogs and try to run all recommended solution and luckily I found a working one.

CakePhp Pagination with JQuery

CakePhp Pagination Example

CakePhp pagination

In web application, displaying all data from database is not a good practice. It can affect the performance especially if we have a million or even a thousand of data. It will load the entire page in certain amount of time which is not good for the user experience.