Question

thinkphp 关联模型怎么进行条件查询

Answer 1

$task = D("task a");
$list = $task->join('think_user b on a.poster=b.id')->where($where)->field('a.*,b.username,b.name,b.kid')->order($order )->limit($p->firstRow.','.$p->listRows)->select();
$where可以是数组也可以是字符串

Answer 2

$bookinfo = $Book->table('t_book a')
->field('a.id,a.cid,a.bookname,b.catename')
->join('t_book_cate b ON a.cid = b.id')
->where('a.id = ' . $bid)
->find();

是指这样的么