Level 75
What about open the documentation?
https://laravel.com/docs/8.x/queries#retrieving-all-rows-from-a-table
https://laravel.com/docs/8.x/queries#retrieving-a-single-row-column-from-a-table
Maybe you'll see the difference.
1 like
Sep 16, 2021
4
Level 3
Query Builder ->first() to array instead of object
How to get the following query result into an array instead of an object ?
$res = DB::connection('myconn')->table('mytable')->where('MYID', $id)->first();
Level 3
@michaloravec Thanks for your help but I'd like to get this result into an array, not just take some rows from it. Also, ->first() returns an object of type stdClass, so functions like value() is undefined.
Level 75
You mean like casting stdClass to the array?
$res = (array) DB::connection('myconn')->table('mytable')->where('MYID', $id)->first();
Level 80
How to get the following query result into an array instead of an object ?
@devondahon Heard of Eloquent? Heard of its toArray method?
Use it, instead of long-winded DB calls like this.
Please or to participate in this conversation.