I use laravel query builder instead Eloquent. Now, i have a lot of repeating joins. How can I use them without standard models scope in my query?
Simple:
public function getUserCourse(int $user_id)
{
return DB::table($this->table)
->select($this->table.'.id','title','description')
->join('user_course', $this->table.'.id','=','user_course.course_id')
->where('user_course.user_id','=',1)
->where('status','=', 0)
->get();
}
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire