Transform collective to array in Laravel, Laravel 5

Question

How can I transform this collection to array and eject "whereNotIn" using a Laravel query, like this:

->whereNotIn('id', ['collection'])->get();'


Collection {#259 ▼
#items: array:3 [▼
0 => {#257 ▼
  +"id": 2
}
1 => {#256 ▼
  +"id": 3
}
2 => {#237 ▼
  +"id": 6
}
]}

Whats your question exactly? If you want to convert to array, just use the toArray method — Paras, Sep 07 '17 at 19:49
i want to use the method 'whereNotIn' and i dont knwo how to pass the laravel coletion to array ->whereNotIn('id', [array])->get();' — Renato, Sep 07 '17 at 20:00

DevK · Answer 1 · 2017-09-07T20:28:22.350

2

Use pluck(attribute):

->whereNotIn('id', $collection->pluck('id'))->get();

edited Sep 07 '17 at 20:28

answered Sep 07 '17 at 20:09

DevK

9,597
2
26
48

score 1 · Accepted Answer · edited Oct 08 '17 at 07:09

1

In fact, to get an array, you should use pluck together with the all() method, so in this case you should use:

->whereNotIn('id', $collection->pluck('id')->all())->get();

edited Oct 08 '17 at 07:09

Peter Mortensen

30,738
21
105
131

answered Sep 07 '17 at 21:36

Marcin Nabiałek

109,655
42
258
291

Transform collective to array in Laravel, Laravel 5

2 Answers2