我正在尝试在 CakePHP 上做自定义分页,问题是我想传递自定义条件,如下所示:
$conditions['People'] = $this->People->find('all',
array(
'order' => array('People.id DESC'),
'limit' => 16,
'order' => 'People.id DESC'
)
);
$people = $this->paginate('People',$conditions);
这基本上是所有涉及分页的代码,但它不起作用,它抛出它找不到列 People...
我只想使用自定义条件进行分页,也就是说,我想事先设置条件,有没有办法做到这一点?
你看过文档吗?
根据文档,您应该添加如下条件:
public function list_recipes() {
$this->Paginator->settings = array(
'conditions' => array('Recipe.title LIKE' => 'a%'),
'limit' => 10
);
$data = $this->Paginator->paginate('Recipe');
$this->set(compact('data'));
}
所以猜测这应该有效:
public function list_people() {
$this->Paginator->settings = array('order' => array('People.id DESC'),'limit' => 16,'order' => 'People.id DESC');
$data = $this->Paginator->paginate('People');
$this->set(compact('data'));
}
这是我在蛋糕 2.x 中的做法
首先,请确保在控制器中包含分页器组件和辅助程序,例如
$public $components = array(
'Paginator'
);
$public $helpers = array(
'Paginator'
);
然后在你的行动中
$options = array(
'conditions' => array(
'Post.status' => 1
),
'fields' => array(
'Post.id',
'Post.title',
'Post.created'
),
'order' => array(
'Post.created' => 'DESC'
),
'limit' => 10
);
$this->Paginator->settings = $options;
$posts = $this->Paginator->paginate('Post');
好的,我解决了它,这就是我所做的:首先我声明分页,如果需要,它可以是空的:
public $paginate = array('People'=>array(
'limit' => 6,
'order' => 'People.id DESC'
));
然后,每当我想改变一些东西时,我就会做:
$this->paginate['People']['limit'] = 12;