laravel foreach loop in controller

Question

i have a problem about looping data in controller (laravel 4). my code is like this:

$owner = Input::get('owner');
$count = Input::get('count');
$product = Product::whereOwnerAndStatus($owner, 0)->take($count)->get();

when i want to use foreach to loop for $product result with code like this:

foreach ($product->sku as $sku) {
    // Code Here
}

the result is returning error Undefined property: Illuminate\Database\Eloquent\Collection::$sku

so, i try to improvise a little with this code:

foreach ($product as $items) {
    foreach ($items->sku as $sku) {
        // Code Here        
    }
}

the code returning error like this: Invalid argument supplied for foreach()

is there someone who could help me solve this?

whereOwnerAndStatus never seen that syntax before. Does that work? Where in the docs is that? — Jake Wilson
– Jake Wilson, Commented Jun 18, 2014 at 5:24

miftahulrespati · Accepted Answer · 2021-12-16 08:25:33Z

58

This will throw an error:

foreach ($product->sku as $sku){ 
// Code Here
}

because you cannot loop a model with a specific column ($product->sku) from the table.
So, you must loop on the whole model:

foreach ($product as $p) {
// code
}

Inside the loop you can retrieve whatever column you want just adding ->[column_name]

foreach ($product as $p) {
echo $p->sku;
}

edited Dec 16, 2021 at 8:25

miftahulrespati

5161 gold badge6 silver badges19 bronze badges

answered Oct 10, 2014 at 15:55

alex t

8618 silver badges9 bronze badges

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

Comments

The Alpha · Accepted Answer · 2014-06-18 06:29:48Z

Actually your $product has no data because the Eloquent model returns NULL. It's probably because you have used whereOwnerAndStatus which seems wrong and if there were data in $product then it would not work in your first example because get() returns a collection of multiple models but that is not the case. The second example throws error because foreach didn't get any data. So I think it should be something like this:

$owner = Input::get('owner');
$count = Input::get('count');
$products = Product::whereOwner($owner, 0)->take($count)->get();

Further you may also make sure if $products has data:

if($product) {
    return View:make('viewname')->with('products', $products);
}

Then in the view:

foreach ($products as $product) {
    // If Product has sku (collection object, probably related models)
    foreach ($product->sku as $sku) {
        // Code Here        
    }
}

Ghanshyam Nakiya · Accepted Answer · 2019-04-25 05:05:38Z

2

The view (blade template): Inside the loop you can retrieve whatever column you looking for

 @foreach ($products as $product)
   {{$product->sku}}
 @endforeach

answered Apr 25, 2019 at 5:05

Ghanshyam Nakiya

1,71220 silver badges24 bronze badges

Comments

ND verma · Accepted Answer · 2022-09-12 07:18:09Z

1

using foreach on table

for me

@foreach($products as $data)
            <tr>
                <td>{{$data->id}}</td>
                <td>{{$data->name}}</td>
                <td>{{$data->price}}</td>
            </tr>
 @endforeach

answered Sep 12, 2022 at 7:18

ND verma

3074 silver badges12 bronze badges

Comments

Jake Wilson · Accepted Answer · 2014-06-18 05:26:47Z

0

Is sku just a property of the Product model? If so:

$products = Product::whereOwnerAndStatus($owner, 0)->take($count)->get();

foreach ($products as $product ) {
  // Access $product->sku here...
}

Or is sku a relationship to another model? If that is the case, then, as long as your relationship is setup properly, you code should work.

answered Jun 18, 2014 at 5:26

Jake Wilson

91.7k97 gold badges262 silver badges371 bronze badges

Comments

Maizied Hasan Majumder · Accepted Answer · 2022-08-17 05:51:25Z

0

$allData = Model::where('status', 1)->get();
                foreach ($allData as $data){
                    $data->status = 0;
                    $data->update();
                }

Here every $data is single data and $allData contains full collection.

answered Aug 17, 2022 at 5:51

Maizied Hasan Majumder

1,0531 gold badge13 silver badges28 bronze badges

Comments

Chika Nwazuo Evuka · Accepted Answer · 2023-01-24 16:21:16Z

0

Edit multiple data in laravel You can use this for updating multiple data in laravel, which i have tested it and it works for me. also remember i used relatationship here

edited Jan 24, 2023 at 16:21

answered Dec 25, 2022 at 23:52

Chika Nwazuo Evuka

512 bronze badges

2 Comments

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

ahuemmer Over a year ago

And also, please make use of the formatting possibilities we provide. Your code is hardly readable without formatting.

Collectives™ on Stack Overflow

laravel foreach loop in controller

7 Answers 7

Comments

Comments

Comments

Comments

Comments

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

Comments

Comments

Comments

Comments

2 Comments

Related