Db::table('think_user')
->where([
'name' => ['like','thinkphp%'],
'title' => ['like','%thinkphp'],
'id' => ['>',0],
'status'=> 1
])
->select();
数组之后就能直接操作条件数组来动态增加或减少查询条件了
if(isset($search))
{
$dict['name']=['like','%search%'];
}
$dict['status']=1
Db::table('think_user')
->where($dict)
->select();