Laravel: Get pivot data for specific many to many relation
My User
model has many Target
and vice versa.
Now I've got a given User
and given Target
and I want to access pivot data from their relation. The pivot column is called type
How can I achieve this?
Solution 1:
On the relationships for both User
and Target
, tack on a ->withPivot('type')
which will instruct Laravel to include that column. Then once you have your result set, you can access the field with $user->pivot->type
.
If you're not iterating over a collection, but have a user and one of their targets and want the type
field, you could use $target = $user->targets->find($targetId)
and access the type with $target->pivot->type
.
More at http://laravel.com/docs/4.2/eloquent#working-with-pivot-tables