How to get values from an array in Laravel

Question

I have a 3 level category. I need to gain businesses on level 3 category.

I write this code:

$main_cat = Category::where(['slug' => $url])->first();
$lev_cat2 = Category::where(['parent_id' => $main_cat->id, 'status' => '1'])->get();
 foreach ($lev_cat2 as $subCategory) {
            $cat_ids_lv2[] = $subCategory->id . ',';
        }
 foreach ($lev_cat2 as $subCat) {
            $lev_cat3[] = Category::where(['parent_id' => $subCat->id, 'status' => '1'])->pluck('id')->toArray();
        }

dd($lev_cat3);

Then I got this array which is correct:

array:5 [▼
  0 => array:3 [▼
    0 => 145
    1 => 146
    2 => 147
  ]
  1 => array:3 [▼
    0 => 148
    1 => 149
    2 => 150
  ]
  2 => array:3 [▼
    0 => 151
    1 => 152
    2 => 153
  ]
  3 => array:3 [▼
    0 => 154
    1 => 155
    2 => 156
  ]
  4 => []
]

now I dont know how can I get values like 145,146,147,148,149,... to pass theme to

Business::where(['category_id'=> [145,146,147,148,...]]->get();

of course dynamic.

Maraboc · Accepted Answer · 2019-01-29 09:50:36Z

3

You can use laravel collection helpers :

Business::whereIn('category_id', collect($lev_cat3)->flatten()->all())->get();

answered Jan 29, 2019 at 9:50

Maraboc

11.1k3 gold badges43 silver badges51 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-20 22:45:59Z

1

Since PHP 5.5.0 there is a built-in function array_column which does exactly this.

You can use it to Converting php array of arrays into single array then use it like this

$category_ids = array_column($lev_cat3);

Business::where(['category_id'=> $category_ids]]->get();

edited Nov 20, 2023 at 22:45

CommunityBot

11 silver badge

answered Jan 29, 2019 at 10:58

Mehran

1951 silver badge10 bronze badges

Collectives™ on Stack Overflow

How to get values from an array in Laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related