The practice of using paginator to sort multiple fields under cakephp

Original: http://blog.csdn.net/kunshan_shenbin/article/details/7644603The practice of using paginator to sort multiple fields under CakePHP 2012-06-08 11:03 448 people read comments (0) favorite reports

Sometimes you need to sort multiple fields when you turn the page.

But CakePHP 's paginator sort method can only be sorted by default for one field.

There are 2 ways to solve this problem:

1. Append a dummy field to the model:

Http://book. cakephp. Org/1.3/view/1608/virtual-fields

2. Merge the parameters of the default sort method.

http://www.amityadav.name/cakephp-pagination-sorting-on-2-columns/

In addition, if it is count data, it is said that you can use the following method:

Http://book. cakephp. Org/1.3/view/1033/countercache-cache-your-count

Other references:

http://stackoverflow.com/questions/6018233/cakephp-pagination-sort-by-calculated-field-count

The practice of using paginator to sort multiple fields under cakephp