cakePHP的联表查询 | 小杰博客

$fields = array('BagBook.id','BagBook.bid','BagBook.position','Cmbook.name as name','BagBook.bag_class_id'
		,'Cmbook.cover_url as cover_url','Cmbook.introduction as introduction','Cmbook.author as author');
		$conditions =  array('bag_class_id' => $id);
		$joins = array(array(
			'table' => 'cmbooks',
			'alias' => 'Cmbook',        
			'type' => 'LEFT',        
			'conditions' => array('Cmbook.bid = BagBook.bid')
		));
		$order = array('BagBook.position','BagBook.id asc');
		$this->paginate = array('limit' => 20,'fields'=>$fields, 'conditions' =>$conditions, 'joins'=>$joins,'order'=>$order);
		$this->NewBook->recursive = 0;
		$NewBooks = $this->paginate();

$fields = array('BagBook.id','BagBook.bid','BagBook.position','Cmbook.name as name','BagBook.bag_class_id'

,'Cmbook.cover_url as cover_url','Cmbook.introduction as introduction','Cmbook.author as author');

$conditions = array('bag_class_id' => $id);

$joins = array(array(

'table' => 'cmbooks',

'alias' => 'Cmbook',

'type' => 'LEFT',

'conditions' => array('Cmbook.bid = BagBook.bid')

));

$order = array('BagBook.position','BagBook.id asc');

$this->paginate = array('limit' => 20,'fields'=>$fields, 'conditions' =>$conditions, 'joins'=>$joins,'order'=>$order);

$this->NewBook->recursive = 0;

$NewBooks = $this->paginate();

Hi，您需要填写昵称和邮箱！