/**
  * 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'));
 }