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

问题描述

问 题

如图 加入了$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条件应该怎样加才对啊?

解决方案

把条件这个条件单独拿出来试试
$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();

这篇关于php - TP 框架多表查询where()的写法问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！