Need array instead of object in laravel using raw Query like DB::select("SELECT * FROM table");

Question

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 4](http://stackoverflow.com/questions/20776656/db-query-builder-toarray-laravel-4) — Tim Biegeleisen, Sep 18 '15 at 09: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 http://stackoverflow.com/questions/2022544/can-i-use-stdclass-like-an-array — Basheer Kharoti, Sep 18 '15 at 13:27

score 3 · Accepted Answer · answered Sep 19 '15 at 09:33

3

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 '15 at 09:33

Md Rashedul Hoque Bhuiyan

10,151
5
30
42

unxp · Answer 2 · 2015-09-18T09:44:26.440

1

It actually returns an array of objects. To make an individual object to be an array just cast it. For example: (array)$data[0]

edited Sep 18 '15 at 09:44

answered Sep 18 '15 at 09:04

unxp

318
2
12

I need a two dimension array not object – Payer Ahammed Sep 18 '15 at 09:14
Can you explain how you can get a two dimensional array by doing `SELECT *` when in fact you might get, say 10 records back? – Tim Biegeleisen Sep 18 '15 at 09:15
i need a method which return a full array instead of object? – Payer Ahammed Sep 18 '15 at 09:31
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 – unxp Sep 18 '15 at 09:46

Need array instead of object in laravel using raw Query like DB::select("SELECT * FROM table");

2 Answers2