如何在Cakephp中为多个sql查询使用一个控制器?

每次需要在单个控制器中执行多个查询时,我都会这样做:

// model Foo
function edit($id){
    $this->data = $this->Foo->read(null, $id);
    $second = $this->Foo->Foo2->find('list');
    $third = $this->Foo->Foo3->find('list');
    $this->set(compact('second', 'third')); 
}

我猜,你想在这3列上分页,所以上面的例子不适合。

我认为你的方法有错误。 $posts 与您的 find $posts = $this->Post->find('all', $sql); . 但这不允许您对结果分页。看一看 Custom Query Pagination

function index(){
    if(!isset($this->params['requested'])) {
        $this->paginate = array('Post' => array(
            'conditions' => array('id BETWEEN ? AND ?' => array(286, 291))
        ));
    }
    $this->set('posts', $this->paginate());
}