Cannot use object of type Illuminate\Database\Query\Builder as array

Question

I cannot find the error here how do i fix this?

$db2 = DB::connection('sqlsrv')->table('Checkinout')
    ->join('Z_MemRecord','Checkinout.Userid','=','Z_MemRecord.uid')
    ->select(DB::raw("FORMAT(MAX (Checkinout.CheckTime), 'hh:mm tt') AS OffTime, FORMAT (min(Checkinout.CheckTime), 'hh:mm tt') AS Ontime, Checkinout.Userid,Z_MemRecord.Uname,FORMAT (Checkinout.CheckTime, 'MMM dd yyyy') as dates,FORMAT (Checkinout.CheckTime, 'dddd') as hour"))
    ->groupBy(DB::raw("Convert(Date, Checkinout.CheckTime),Checkinout.Userid,Z_MemRecord.Uname,FORMAT(Checkinout.CheckTime, 'MMM dd yyyy'),FORMAT (Checkinout.CheckTime, 'dddd')"));

$result = DB::connection('mysql')->table('netdoc')->insert(['Logid' => $db2['Checkinout.Userid'] ,'name'=> $db2['Z_MemRecord.Uname'],'dates' =>  $db2['dates'],'day'=>$db2['hour'],'Ontime' => $db2['Ontime'],'Offtime' => $db2['OffTime']]);


dd($db2);

Which dbms are you using? db2, mysql and sqlsrv give different indications. — jarlh
– jarlh, Commented Jan 22, 2020 at 9:10
i am using SQL Server MS 2018 and i just want to insert the modified data from sqlsrv to mysql. — Michael
– Michael, Commented Jan 22, 2020 at 9:12
dd($db2); before your $result. As the message says, it's a Builder object, you probably need to get results first using ->get() first to access Checkinout.Userid — user8034901
– user8034901, Commented Jan 22, 2020 at 9:18

mrhn · Accepted Answer · 2020-01-22 09:28:56Z

2

The method groupBy() returns a QueryBuilder to convert it to an array call get() to receive an array of rows.

->groupBy(...)
->get();

Thou you need to deal with the query returning multiple rows, so an quick solution for that would to traverse db2 with foreach().

foreach ($db2 as $row) {
    $row = (array) $row;

    $result = DB::connection('mysql')
        ->table('netdoc')
        ->insert(['Logid' => $row['Checkinout.Userid'] ,'name'=> $row['Z_MemRecord.Uname'],'dates' =>  $row['dates'],'day'=>$row['hour'],'Ontime' => $row['Ontime'],'Offtime' => $row['OffTime']]);
}

edited Jan 22, 2020 at 9:28

answered Jan 22, 2020 at 9:21

mrhn

19.1k6 gold badges31 silver badges48 bronze badges

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

8 Comments

Michael Over a year ago

now it shows this error "Cannot use object of type stdClass as array".

mrhn Over a year ago

Laravel returns stdObjects i converted it to array i guess it will help :)

Michael Over a year ago

It works now! It does pass the all data i need! That's really a big help! omg. thank you very much. :D

Michael Over a year ago

ahm, one last question. how do i fix the duplicate something? "Integrity constraint violation: 1062 Duplicate entry '40218' for key 'PRIMARY'"

mrhn Over a year ago

What is your primary key? usually that is set by the db

|

Collectives™ on Stack Overflow

Cannot use object of type Illuminate\Database\Query\Builder as array

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related