以举例说明:
$where['name'] = ['like','%爱你%'];
$user= User::where($where)->select();
dump($user);die;
上面的例子是不会查出来的 tp5.0是可以的
对的方法是:
$where[] = ['name','like','%爱你%'];
$user= User::where($where)->select();
dump($user);die;
在tp5.1where多条件查询就改动挺大的
tp5.0的
//tp5.0的
$where=[
'name' => ['like','think%'],
'id' => ['>',0]
];
tp5.1的
$where=[
['name','like','think%'],
['id','>',0],
];
//或者
$where[]=['name','like','think%'];
$where[]=['id','>',0];
//或者
$where['name']=['name','like','think%'];
$where['id']=['id','>',0];
//如果需要条件合并
//写成
$where1['status']=['status','=',1];
$where2['status']=['status','=',2];
$where=array_merge($where1,$where2);