thinkphp5.0查询AND / OR多条件实现搜索功能
1.这是我的文章表审核条件字段,等于0就是已经审核的,不能把没经过审核或者是屏蔽的文章也搜索出来~$where['examine'] = 0;
2.这里是模糊搜索的条件:$where['writer | title'] = array('like', "%$search%");
3.把$where数组传入thinkphp的搜索操作Db::name('article')->order('time desc')->where($where)->limit('0,14')->field('id,title,url')->select();
4.搜索接口示例public function searchText($search){
$where['examine'] = 0;
$where['writer | title'] = array('like', "%$search%");
$result = Db::name('article')->order('time desc')->where($where)->limit('0,14')->field('id,title,url')->select();
foreach ($result as $key => $value) {
print_r('
ID为'.$result[$key]['id']." ".''.$result[$key]['title'].'
') ;};
}
5.测试的效果如下:
测试返回JSON如下: