我有三张桌子
user, specialities & results个
结果包含specialitie_id, user_id个
我创建了多对多关系
下面是用户模型中的关系
public function specialities()
{
return $this->belongsToMany(Speciality::class, 'results', 'user_id', 'specialitie_id')->withPivot('result', 'color');
}
我想从结果表中提取基于specialitie_id的数据
如果我的URL是
abc.com/result/5个
I have attached table structure as well,
它应该向我显示与specialitie_id 5相关的结果
我试过了，但不起作用
$result = User::with('specialities')->where('id', 5)->get();
任何帮助都将不胜感激.
Your current query:个
$result = User::with('specialities')->where('id', 5)->get();
是说，给我所有的结果，其中USER_ID=5WITH，所有与之相关的专业.
You are very close but did it backwards:个
//Give me all results where the SPECIALITY_ID = 5
//WITH all the users related to it
$result = Speciality::with('users')->where('id', 5)->get();
Please note that the above is an array个
Example of a Controller Function:个
public function results($id){
$results = Speciality::with('users')->where('id', $id)->get();
return view('user_specialities', compact('results'));
}
Example view user_specialities:个
@foreach($results as $result)
<p>Result: {{$result->result}}</p>
<p>Formulary: {{$result->formulary}}</p>
<p>Color: {{$result->color}}</p>
<p>User ID: {{$result->user->id}}</p>
<p>User Name: {{$result->user->name}}</p>
@endforeach
Speciality Model:个
public function users()
{
return $this->belongsToMany(User::class, 'results', 'specialitie_id', 'user_id')->withPivot('result', 'color');
}
User Model:个
public function specialities()
{
return $this->belongsToMany(Speciality::class, 'results', 'user_id', 'specialitie_id')->withPivot('result', 'color');
}