In index controller i don't need any condition so data retrieves very clearly with all relational models.
$questions = Question::with('user','courses','subjects')->take(10)->orderBy("id","DESC")->get();
This return the question list with all related data like user
courses
and subject
But in courses controller when try to retrieve data with same and adding condition for course slug then its return error.
$questions = Question::with('user','courses','subjects')->where("slug",$course)->take(10)->orderBy("id","DESC")->get();
Because its adds this condition in question table query so there are no slug
coloumn. And When i retrieved with course
class it return correct result but the subjects
and users
are missing
$questions = Course::with("question")->where("nick_name",$course)->orWhere("slug",$course)->orderBy("id","DESC")->take(10)->get();
Then how can i get all related data. And the course model has
public function question(){
return $this->belongsToMany('App\Models\Question','university_questions')->take(10);
}
and question model have
public function courses(){
return $this->belongsToMany('App\Models\Course','course_questions');
}
public function subjects(){
return $this->belongsToMany('App\Models\Subject','subject_questions');
}
public function years(){
return $this->hasMany('App\Models\QuestionYear');
}
What is missing here please help.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire