Need to convert raw sql to eloquent query builder

Question

I need to convert the following sql query to eloquent query builder.

select * from projects
inner join assigned_projects on projects.id = assigned_projects.project_id
where assigned_projects.user_id=9;

where projects and assigned_projects are in many to many relation. Please help me figure it out.

mydo47 · Accepted Answer · 2016-06-17 08:03:04Z

1

$project = DB::table('projects')
             ->join('assigned_projects' , 'projects.id' , '=', 'assigned_projects.project_id')
             ->where('assigned_projects.user_id', '=', 9)
             ->get();

answered Jun 17, 2016 at 8:03

mydo47

3791 silver badge8 bronze badges

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

2 Comments

user835479 Over a year ago

I came across with this one : DB::table('projects') ->join('assigned_projects', function ($join) { $join->on('projects.id', '=', 'assigned_projects.project_id') ->where('assigned_projects.user_id', '=', Auth::user()->id); }) ->get(); But your solutions also do the job done right. Thanks !

user835479 Over a year ago

Another question, I need to access client name from $project like $project->client->username . But that solution is not working in that case. How will I do that ?

Collectives™ on Stack Overflow

Need to convert raw sql to eloquent query builder

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related