Laravel: How to write two query in one query and get result from database?

Question

I have sample code for get all trashed messages current user:

$query1 = $inbox->where('recipient', $user_id)
                ->where('trashed_in_recipient', 1)
                ->where('show_in_recipient', '!=', 1)
                ->orderBy('created_at', 'desc')
                ->paginate($paginate);

$query2 = $inbox->where('sender', $user_id)
                ->where('trashed_in_sender', 1)
                ->where('show_in_sender', '!=', 1)
                ->orderBy('created_at', 'desc')
                ->paginate($paginate);

How can be writed two query in one and get finally result?

Table structure:

You can see my table structure in updated question! @Thomas Moors — Andreas Hunter
– Andreas Hunter, Commented Jan 15, 2018 at 15:10
Yes I use but not now! I will use it if I need to restore messages @Rajender Joshi — Andreas Hunter
– Andreas Hunter, Commented Jan 15, 2018 at 15:18
If you intend to use SoftDeletes, you don’t need trashed_in_recipient and trashed_in_sender columns. — Rajender Joshi
– Rajender Joshi, Commented Jan 15, 2018 at 15:22

SyncroIT · Accepted Answer · 2018-01-15 15:27:53Z

3

You can use functions to define WHERE groups:

$query = $inbox->where(function($query) use ($user_id) {
    $query->where('recipient', $user_id);
    $query->where('trashed_in_recipient', 1);
    $query->where('show_in_recipient', '!=', 1);
})->orWhere(function($query) use ($user_id) {
    $query->where('sender', $user_id);
    $query->where('trashed_in_sender', 1);
    $query->where('show_in_sender', '!=', 1);
})->orderBy('created_at', 'desc')
  ->paginate($paginate);

I hope this helps you

edited Jan 15, 2018 at 15:27

answered Jan 15, 2018 at 15:12

SyncroIT

1,5781 gold badge15 silver badges27 bronze badges

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

5 Comments

Andreas Hunter Over a year ago

Thanks @Syncro! And on last of query can I paginate two query results?

Andreas Hunter Over a year ago

inside of callback function using var $user_id take error: Undefined variable: user_id

Rajender Joshi Over a year ago

Change it to function($query) (use $user_id)

SyncroIT Over a year ago

Use function($query) use ($user_id) instead of just function($query), sorry :)

Andreas Hunter Over a year ago

Working @Syncro! Generaly +1 for you )

Collectives™ on Stack Overflow

Laravel: How to write two query in one query and get result from database?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related