How to query multiple where in laravel

Question

I have a query that gets all the message between two id (user_id and to_user_id). I want to select all the query all the message of user in the two tables.

I have already made two where and it doesn't seem to work. It is just returning null.

  $last_message = DB::table('messages')
                  ->select('content')
                  ->where('user_id','=',Auth::user()->id)
                  ->where('to_user_id','=',Auth::user()->id)
                  ->orderBy('updated_at', 'desc')
                  ->first();

I expect the output of all the message of user

Junyin · Accepted Answer · 2019-04-04 03:38:33Z

1

You should check on this Auth::user()->id, to see if it has a value or not. Also check on the datatype between table field and data source in query builder.

edited Apr 4, 2019 at 3:38

answered Apr 4, 2019 at 2:42

Junyin

364 bronze badges

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

Collectives™ on Stack Overflow

How to query multiple where in laravel

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