How to query all except one in Laravel 4?

Question

CONTROLLER

public function index() {
    $users = User::all(); // Is there a way to chain it with the except method or sth like that
    return View::make('distributors.index')->with('users',$users);
}

GOAL

I want to query all of my users table, but one.

I want to list all the user(s) for my client, but I want to hide my self.

Question

How do I do that ? Am I approaching it in the right way ?

Feel free to give me any suggestions for improvement.

I'm not too familiar with laravel, but could you use something like User::Where('id', '!=', '1')->get(); The 1 would be your user id — Insecurefarm
– Insecurefarm, Commented Nov 18, 2014 at 21:57
here you can find better solution stackoverflow.com/a/32627797/7373178 — Witold Tkaczyk
– Witold Tkaczyk, Commented Sep 14, 2018 at 10:23

Sudhir Bastakoti · Accepted Answer · 2014-11-19 00:35:11Z

10

If you mean except currently logged in user, then do:

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

answered Nov 19, 2014 at 0:35

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

iori Over a year ago

Not exactly, but very close.

Collectives™ on Stack Overflow

How to query all except one in Laravel 4?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related