Laravel query builder grouping

Question

i have a problem making laravel query:

I want for example:

SELECT * FROM USERS WHERE (a = b) or (b = a)

I have this but is not working:

    $user = Auth::user();
    $id_user = $user->id;
    $message = DB::table('message')
    ->where('sender_id', '=', $user->id)
    ->where('reciver_id', '=', $id)
    ->orWhere(function($query) use ($id,$id_user){
      $query-->where('sender_id', '=', $id)
       ->where('reciver_id', '=', $id_user);
    })
    ->join('users', function ($join) {
       $join->on('users.id', '=', 'message.sender_id')->orWhere('users.id', '=', 'message.reciver_id');
    })->select('users.*', 'message.topic', 'message.message', 'message.read', 'message.created_at as date')
    ->orderBy('date')->get();

    return $message;

Can you elaborate on how your code "doesn't work"? What were you expecting, and what actually happened? If you got an exception/error, post the line it occurred on and the exception/error details. Please edit these details in or we may not be able to help. — Blue
– Blue, Commented Sep 1, 2016 at 21:29

Andrej · Accepted Answer · 2016-09-01 20:55:40Z

1

You should nest the first two wheres in a new one. See the code below:

    $message = DB::table('message')
        ->where(function($query) use ($id,$id_user){
            $query->where('sender_id', '=', $id_user)
                ->where('reciver_id', '=', $id);
        })
        ->orWhere(function($query) use ($id,$id_user){
            $query->where('sender_id', '=', $id)
                ->where('reciver_id', '=', $id_user);
        })
        ->join('users', function ($join) {
            $join->on('users.id', '=', 'message.sender_id')->orWhere('users.id', '=', 'message.reciver_id');
        })->select('users.*', 'message.topic', 'message.message', 'message.read', 'message.created_at as date')
        ->orderBy('date')->get();

answered Sep 1, 2016 at 20:55

Andrej

7,5041 gold badge22 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Laravel query builder grouping

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related