In laravel when i use DB::select("SELECT * FROM table");
It return a object,but i need a array.
So how can i get a array instead of object?
example:
$data = DB::select("SELECT * FROM table");
var_dump($data);
-
possible duplicate of DB query builder toArray() laravel 4Tim Biegeleisen– Tim Biegeleisen2015-09-18 09:10:10 +00:00Commented Sep 18, 2015 at 9:10
-
$data itself is an array so $data could not be converted to an array while looping foreach over $data and then converting object to array will throw error take a look at the following question answer stackoverflow.com/questions/2022544/…Basheer Kharoti– Basheer Kharoti2015-09-18 13:27:12 +00:00Commented Sep 18, 2015 at 13:27
Add a comment
|
2 Answers
Please Try this one.
\Illuminate\Support\Facades\DB::setFetchMode(PDO::FETCH_ASSOC);
$values=\Illuminate\Support\Facades\DB::select("select * from your_table");
\Illuminate\Support\Facades\DB::setFetchMode(PDO::FETCH_CLASS);
var_dump($values);
answered Sep 19, 2015 at 9:33
Md Rashedul Hoque Bhuiyan
10.7k5 gold badges33 silver badges42 bronze badges
Comments
It actually returns an array of objects. To make an individual object to be an array just cast it. For example: (array)$data[0]
4 Comments
Payer Ahammed
I need a two dimension array not object
Tim Biegeleisen
Can you explain how you can get a two dimensional array by doing
SELECT * when in fact you might get, say 10 records back?Payer Ahammed
i need a method which return a full array instead of object?
unxp
Note: Casting $data to an array is not relevant as it as already an array and casting will not affect it's members. Each of them has to be cast individually or json_encode/json_decode combination has to be used