Answers for "laravel where in query builder"

query builder laravel

use IlluminateDatabaseEloquentBuilder;

public function scopeFakePersons(Builder $query): Builder
{
  return $query->where('is_fake', 1);
}

laravel query when

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

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