开发者

cakephp paginate: data from different tables

i have "PostsController" controller and in this controller i need get all user list. So i need get data no from "Posts" DB table, bu from "Users". In function I make this paginate:

$this->paginate = array(
    'user' => array(
    'limit' => 2,
    'order' => array(
        'user.id' => 'asc',
    ),
    'table' => 'users'
    ),
);

$users = $this->paginate('user');
$this->set('use开发者_运维问答rs', $users);

But always get empty result, why? And show this error:

Warning (512): Controller::paginate() - can't find model user in controller PostsController [CORE\cake\libs\controller\controller.php, line 1106]


Model name have first letter capitalized, so try

$this->paginate = array(
'User' => array(
'limit' => 2,
'order' => array(
    'User.id' => 'asc',
),
'table' => 'users'
),
);

$users = $this->paginate('User');
$this->set('users', $users);
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜