For me it looks weird.
Cannot use object of type stdClass as array
I converted my query to array.
$query = DB::table('users')->where('name','=','Alex')->get()->toArray();
Checked my variable gettype($query); and it says Array.
Also checked it with var_dump($query); and it also shows Array.
So why while looping my $query in foreach I have to use $item->name and can't access to items as array $item['name'] ?
When you're using toArray(), you get an array of objects, so you still need to use:
$item->name
If you want to convert it to an array of arrays, do this:
$users = DB::table('users')->where('name', 'Alex')->get();
$users->transform(function($i) {
return (array)$i;
});
$array = $users->toArray();
if you want to get result as array then use get()
$query = DB::table('users')->where('name','=','Alex')->get();
if you want to get result as object use first()
$query = DB::table('users')->where('name','=','Alex')->first();
