我有 User 型号和 Job 型号 . 他们之间有很多关系 . 数据透视表名称为 job_user . 现在我在数据透视表中有三个外键列;两个来自用户表,一个来自作业表 . 现在我的问题是我如何查询所以我将能够显示基于Laravel 5.2中数据透视表的外键列的表用户和表作业的所有记录
User
Job
job_user
All jobs of a specific user
$user = User::find(1); $jobs = $user->jobs;
All users of a specific job
$job = Job::find(1); $users = $job->users;
Show columns
$user = User::find(1); $jobs = $user->jobs; for ($jobs as $job) { echo $job->id; }
Retrieving intermediate table columns
$user = User::find(1); foreach ($user->jobs as $job) { echo $job->pivot->created_at; }
有关详细信息,请查看Laravel docs .
PASSING DATA TO VIEW
你的控制器:
$users = User::all(); return View::make('yourView', ['users' => $users]);
你的观点:
@foreach ($users as $user) @foreach ($user->jobs as $job) {{ $job->id }} @endforeach @endforeach
1 回答
All jobs of a specific user
All users of a specific job
Show columns
Retrieving intermediate table columns
有关详细信息,请查看Laravel docs .
PASSING DATA TO VIEW
你的控制器:
你的观点: