/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $trainersList = Trainer::lists('name', 'id'); $courses = Course::lists('course_name', 'id'); $trainers = TrainerCourse::all(); //dd($trainers); return view('TrainerCoursesRelation.index', compact('trainers', 'trainersList', 'courses')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $trainersList = DB::table('users')->leftjoin('role_user', 'users.id', '=', 'role_user.user_id')->where('role_user.role_id', 2)->select('users.id as id', 'users.name as name')->lists('name', 'id'); $courses = Course::lists('course_name', 'id'); $trainers = TrainerCourse::all(); //dd($trainers); return view('TrainerCoursesRelation.index', compact('trainers', 'trainersList', 'courses')); }