TP 框架多表查询where()的写法问题

Question

如图 加入了$serch_val这个条件后就报错了

$result = M()->table(array('newcrawl.right_protect_orgin_relation'=>'a','newcrawl.right_protect_orgin'=>'b','newcrawl.right_protect_result'=>'c'))
                         ->field('a.orgin_id,a.task_name,b.status,c.status as re_status,c.title')
                         ->where('a.orgin_id=b.id AND a.orgin_id=c.orgin_id AND b.status='.$status.' AND a.task_name like %'.$serch_val.'%')
                         ->select();
                         

求教,这个like条件应该怎样加才对啊?

Answer 1

把条件这个条件单独拿出来试试
$where['a.task_name'] =array('like',"%".$serch_val."%");

$result = M()->table(array('newcrawl.right_protect_orgin_relation'=>'a','newcrawl.right_protect_orgin'=>'b','newcrawl.right_protect_result'=>'c'))
                         ->field('a.orgin_id,a.task_name,b.status,c.status as re_status,c.title')
                         ->where('a.orgin_id=b.id AND a.orgin_id=c.orgin_id AND b.status='.$status)
                         ->where($where)
                         ->select();

Answer 2

这么复杂的sql 语句为什么不用原生的呢