Get all the users except current logged in user in laravel eloquent

Question

I am doing:

    User::all();

to get all the users from users table. I want to select all the users except current logged in user. How should I do that? something like,

    User::where('id','!=',$currentUser->id)->get();

Thanks in advance!

Answer 1

You can get the current user's id with auth()->id(). Then pass that to the query:

$users = User::where('id', '!=', auth()->id())->get();

Answer 2

Using except() will accomplish the same thing a little more fluently:

$users = User::all()->except(Auth::id());

...or, since you already have the User id:

$users = User::all()->except($currentUser->id);

Answer 3

If you are using the Auth helper, use this.

User::where('id', '!=', Auth::user()->id)->get();

Answer 4

Use Auth;
Use App\User;

public function index()
$id = Auth::id();
$result = User::where('id', '!=', $id)->get();
dd($result);

Answer 5

App\Models\User::whereKeyNot(auth()->id)->get()

Using 'except' actually retrieves ALL users, then performs an extra operation on the collection to remove the current user, which is not as effective.