How to retrieve data from a database as an array in Laravel? [duplicate]

Question

Normally data retrieved as an object from database in Laravel when we use get() function. But I want to retrieved data as an array.

In CodeIgnitor we use get_array(). What we use in Laravel ?

I have already tried with toArray(). But no result.

$doctor_result = Doctor::select('*')->toArray();

How to solve that?

toArray() is correct on an instance of the resulting collection not on Query builder. The select statement has not returned anything from the db, hence chaining toArray() on it would throw error. — omitobi
– omitobi, Commented Sep 15, 2018 at 12:10

Arafat Rahman · Accepted Answer · 2018-09-15 10:59:10Z

4

I got result. just change the code

$doctor_result = Doctor::all()->toArray();

answered Sep 15, 2018 at 10:59

Arafat Rahman

6244 gold badges14 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

fahdshaykh · Accepted Answer · 2021-05-03 20:08:05Z

1

You can also do like this.

$result = DB::table('tableName')->get();
$resultArray = $result->toArray();

second way, but some tricky.

$resultArray = json_decode(json_encode($result), true);

answered May 3, 2021 at 20:08

fahdshaykh

7025 silver badges12 bronze badges

Ali Akbar Azizi · Accepted Answer · 2025-01-25 21:43:26Z

0

You can get data from base query builder without any unnecessary transformation.

$doctor_result = Doctor::select('*')->toBase()->get()

This will give you array of stdClass usually ( base on PDO config ).

answered Jan 25 at 21:43

Ali Akbar Azizi

3,5654 gold badges31 silver badges50 bronze badges