Pivot table returns empty array

Question

I am trying to get data from pivot table(I have a third column). but it returns empty array. When I do dd() I get this

Collection {#323 ▼
  #items: []
}

$a = new Subject();
$authorized_users = $a->users()->get(['auth_teacher']);

models

Subject

public function users()
{
    return $this->belongsToMany('App\User')->withPivot('auth_teacher')->withTimestamps();
}

User

public function subjects()
{
    return $this->belongsToMany('App\Subject')->withPivot('auth_teacher')->withTimestamps();
}

EDIT: Wrongly written column name. I change it to correctly but the string is still empty

I can't understand why you're trying to fetch a subject_id from a Subject model, can you please elaborate your question properly! — Saumya Rastogi
– Saumya Rastogi, Commented Dec 6, 2016 at 13:36

user1669496 · Accepted Answer · 2016-12-06 13:47:56Z

3

Just use the pivot relationship on the model.

$a = Subject::find(1);
foreach ($a->users as $user) {
    echo $user->pivot->auth_teacher;
}

https://laravel.com/docs/5.3/eloquent-relationships#many-to-many

In the documentation look for "Retrieving Intermediate Table Columns"

edited Dec 6, 2016 at 13:47

answered Dec 6, 2016 at 13:39

user1669496

33.3k9 gold badges76 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

OunknownO Over a year ago

No I'm trying to get third column from pivot table(there are keys and third custom boolean column. I need the third one). I know how to get specific users or subjects(i wrote wrong column name)

AddWeb Solution Pvt Ltd · Accepted Answer · 2016-12-06 13:29:30Z

0

Try below code:

$a = new Subject();
$authorized_users = $a->users()->find(['subject_id']);

answered Dec 6, 2016 at 13:29

AddWeb Solution Pvt Ltd

21.8k5 gold badges30 silver badges61 bronze badges

Collectives™ on Stack Overflow

Pivot table returns empty array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related