Level 18
The best way? Use a relationship and a model.
Otherwise you are just doing all the work that has already been done...
1 like
Aug 27, 2018
4
Level 2
db query to relationship
my query
$data = DB::table('countries')
->leftJoin('matches', function ($join) {
$join->on('matches.hometeam', '=', 'countries.id')
->orOn('matches.awayteam', '=' ,'countries.id');
})
->where('countries.id', $id)->get();
return dd($data);
how i can get same results use relationship
Level 18
First, a slight modification to your code:
model
public function awayteam(){
return $this->hasOne("App\WorldCup"); //fill in proper keys
}
public function hometeam(){
return $this->hasOne("App\WorldCup); //fill in proper keys
}
Level 2
query to get many rows from table matches
Level 2
any help
Please or to participate in this conversation.