Laravel Combine DB Queries

Question

Is it possible to combine the following two queries into one?

$session_id = DB::table('oauth_access_tokens')->where('id', '=', $access_token)->value('session_id');
$owner_id = DB::table('oauth_sessions')->where('id', '=', $session_id)->value('owner_id');

Thanks for your help!

@JosephSilber - From the first query I get the session_id value and then I use this in the second query to be able to get the owner_id. I was hoping it would be possible to have the first query as a part of the second one. The tables do not have the same columns. — Ragnarsson
– Ragnarsson, Commented Sep 1, 2015 at 13:31

Joseph Silber · Accepted Answer · 2015-09-01 13:35:20Z

1

What you need is a subquery:

$query = DB::table('oauth_sessions');

$query->where('oauth_sessions.id', function ($query) use ($access_token) {
    $query->from('oauth_access_tokens')
          ->where('oauth_access_tokens.id', $access_token)
          ->select('session_id');
});

$owner_id = $query->value('owner_id');

You can chain it all instead of using 3 separate statements. I just formatted it because I think it reads nicer this way.

answered Sep 1, 2015 at 13:35

Joseph Silber

221k59 gold badges369 silver badges293 bronze badges

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

1 Comment

Ragnarsson Over a year ago

Great! Works perfectly. Thank you the help.

Collectives™ on Stack Overflow

Laravel Combine DB Queries

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related