I have write that code but i want take an array of this, is this possible?
$results = DB::table('pages')->select('id', 'link')->orderBy('id', 'asc')->get();
-
Use toArray() functionAnkur Tiwari– Ankur Tiwari2016-04-30 11:46:39 +00:00Commented Apr 30, 2016 at 11:46
Add a comment
|
2 Answers
To get laravel query builder result in array check this:
$results = DB::table('pages')->select('id', 'link')->orderBy('id', 'asc')->get()->toArray();
Or
If you prefer to use Query Builder instead of Eloquent here is the solutions
$results = DB::table('pages')->select('id', 'link')->orderBy('id', 'asc')->get();
First Solution
$array = (array) $result;
Second Solution
$array = get_object_vars($result);
Third Solution
$array = json_decode(json_encode($result), true);
hope it may help
2 Comments
John Stamoutsos
I try but... Symfony \ Component \ Debug \ Exception \ FatalErrorException (E_UNKNOWN) HELP Call to a member function toArray() on array
Ankur Tiwari
Updated to answer @user3211908
You can see from the API docs that the get() function returns either a Collection or a Builder.
Laravel collections have the toArray() method (described in the docs) as shown below:
$collection = collect(['name' => 'Desk', 'price' => 200]);
$collection->toArray();
/*
[
['name' => 'Desk', 'price' => 200],
]
*/
Therefore, you can do the following:
$results = DB::table('pages')->select('id', 'link')->orderBy('id', 'asc')->get()->toArray();
2 Comments
John Stamoutsos
I try but... Symfony \ Component \ Debug \ Exception \ FatalErrorException (E_UNKNOWN) HELP Call to a member function toArray() on array
KelvZhan
@user3211908 Can you call
dd(DB::table('pages')->select('id', 'link')->orderBy('id', 'asc')->get()); and take a screenshot, censoring sensitive info? It'd be good to see exactly what's being returned.