Laravel - converting a collection to a simple array

Question

so I have this code:

    $collectionOfProducts = \DB::table('products_specif')->whereIn('size',$arrayOfAttributes)->whereIn('color',$arrayOfAttributes)->whereIn('material',$arrayOfAttributes)->get('product_code');
    $product_codes = $collectionOfProducts->unique();
    dd($product_codes->toArray());
    $arrayOfProducts = \DB::table('products')->whereIn('product_code',$product_codes)->get();
    return view('pages.products', compact('arrayOfProducts','type'));

the dd() responds with:

array:4 [▼
  0 => {#1252 ▼
    +"product_code": "SocksCode"
  }
  4 => {#1257 ▶}
  9 => {#1262 ▶}
  13 => {#1266 ▶}
]

I would like to use the $product_codes in my whereIn statement, but I can't because of those numbers at the start(0,4,9,13). How do I convert this collection/array to just a simple "product_code" : "code" array?

Dilip Hirapara · Accepted Answer · 2020-05-20 13:11:33Z

1

You can use pluck method to get array of product_code

$product_codes= \DB::table('products_specif')
->whereIn('size',$arrayOfAttributes)
->whereIn('color',$arrayOfAttributes)
->whereIn('material',$arrayOfAttributes)->pluck('product_code')->toArray();

$arrayOfProducts = \DB::table('products')->whereIn('product_code',$product_codes)->get();

answered May 20, 2020 at 13:11

Dilip Hirapara

15.4k3 gold badges34 silver badges56 bronze badges

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

1 Comment

Dilip Hirapara Over a year ago

select the answer please.. glad to help you :)\

Collectives™ on Stack Overflow

Laravel - converting a collection to a simple array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related