Laravel Database Query

Question

I am trying to write a MySQL select query using Laravel's Database Query Builder as follows:

Select all projects where the project's author_id equals the user's id , or where the project's group_id equals a group_id that the user is assigned to.

For example:

User 1 is in group 24. There are 3 projects in group 7. User 1 wants to see all of the projects from that group.

Database Tables:

users

+----+
| id |
+----+

projects

+-----------+----------+
| author_id | group_id |
+-----------+----------+

groups

+----+
| id |
+----+

groups_users_are_assigned

+---------+----------+
| user_id | group_id |
+---------+----------+

Any help on how to do this correctly in a single query would be amazing. Thanks!

Lavarel or Laravel ?

Korvo
– Korvo

2014-04-20 20:26:02 +00:00
Commented Apr 20, 2014 at 20:26 — Korvo
– Korvo, Commented Apr 20, 2014 at 20:26

totymedli · Accepted Answer · 2014-04-20 21:07:27Z

1

A don't want to create a test enviroment for this query, but according to my knowledge, this should work:

DB::table('projects')
    ->leftJoin('groups_users_are_assigned', 'projects.group_id', '=', 'groups_users_are_assigned.group_id')
    ->where('author_id', '=', $userId)
    ->orWhere('groups_users_are_assigned.user_id', '=', $userId)
    ->get()

edited Apr 20, 2014 at 21:07

answered Apr 20, 2014 at 20:22

totymedli

31.5k23 gold badges141 silver badges174 bronze badges

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

1 Comment

user3554382 Over a year ago

Excellent - thank you, works perfectly. The 'orWhere' needed the equals operator passed as the second argument, and $userId as third.

Collectives™ on Stack Overflow

Laravel Database Query

Database Tables:

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Database Tables:

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related