// where语句 AND条件
public function demo3()
{
$result = Db::table('user')
->field(['name','password'])
->where([
'name'=>['=','root'],
'userid'=>['>',4]
])
->select();
dump($result);
}
// where语句 AND条件（闭包）--引入变量进行查询
public function demo4()
{
$myname = 'admin';
$result = Db::table('user')
->field(['name','password'])
->where(function($query) use ($myname){
$query->where('userid','=',1)
->where('name','=',$myname);
})
->select();
dump($result);
}
// where语句 AND条件（闭包缩写）
public function demo5()
{
dump(
Db::select(
function ($query){
$query->table('user')
->field(['name','password'])
->where([
'userid'=>['>',1],
'password'=>['=','123456']
]);
}
));
}
原文地址：https://www.ailaiyun.com/thinkphp5-%e6%95%b0%e6%8d%ae%e5%ba%93%e6%93%8d%e4%bd%9c-whereand%e8%af%ad%e5%8f%a5.html
