$username = 'huang3'; $password = '888888'; $res = DB::table('users')->when($username,function($query) use ($username) { return $query->where('username',$username); })->when($password,function($query) use ($password) { return $query->where('password',$password); })->get(); dd($res);
说明:当条件为真时,会执行when里面的语句
laravel5.4(含)以后版本支持该写法