Answers for "laravel query bar"

laravel query builder

$email = DB::table('users')->where('name', 'John')->value('email');

laravel query when

$role = $request->input('role');

$users = DB::table('users')
                ->when($role, function ($query, $role) {
                    return $query->where('role_id', $role);
                })
                ->get();