Cannot use object of type stdClass as array when looping with array

Question

I'm trying to get Count of a table called TestRunList that has the foreign key the same as another table called Testrun meaning i want to get count of how many testrunlist that single testrun has in the same page i did a forloop to get testrun id for each testrunlist but it didn't seem to work i get this error

Cannot use object of type stdClass as array

heres my Code in the controller

        $data = DB::table('TestRun')->get();
        $runs=array();
        for ($i=0;$i<sizeof($data);$i++)
        {
            $testrunID=$data[$i]['TestRunID'];
            $Testrunlist=TestRunList::where('test_run_id',$testrunID)->count();
            $runs[$i]=[
                'Countruns'=>$Testrunlist
            ];

        }

    return view('management.testrun.testrun-list')
        ->with('data',$data)
        ->with('runs', $runs);

It's returning a collection(as Lloople has already pointed out). You can use the quite extensive list of methods possible on collections to achieve whatever it is you want to achieve. — Andrei
– Andrei, Commented Oct 25, 2017 at 11:58

Lloople · Accepted Answer · 2017-10-25 11:36:42Z

1

$data is a Collection, you can't access using array syntax

$data = DB::table('TestRun')->get();
$runs = [];
$data->each(function ($row) use ($runs) {
    $runs[] = [
        'Countruns' => TestRunList::where('test_run_id',$row-> TestRunID)->count()
    ];
});

return view('management.testrun.testrun-list')
    ->with('data',$data)
    ->with('runs', $runs);

answered Oct 25, 2017 at 11:36

Lloople

1,8241 gold badge17 silver badges32 bronze badges

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

1 Comment

Mohammad hayajneh Over a year ago

Well you're right about $data being Collection so i used my model to get data from database and it worked so i will accept your answer

Tailer · Accepted Answer · 2017-10-25 12:17:02Z

0

Always use

print_r($data);

if it's object run echo $data->username if array run echo $data['username'];

So you know what type of data you're dealing with.

edited Oct 25, 2017 at 12:17

answered Oct 25, 2017 at 12:05

Tailer

6,5771 gold badge15 silver badges24 bronze badges

Collectives™ on Stack Overflow

Cannot use object of type stdClass as array when looping with 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