How to return array instead of object in laravel 5

Question

I have use in model .

$data = DB::select('select * from users');
return $data;

But in controller I have got like this.

Array
(
    [0] => stdClass Object
        (
            [Id] => 10
            [Name] => Sachin
            [Gender] => M
        )

    [1] => stdClass Object
        (
            [Id] => 12
            [Name] => Sourav
            [Gender] => M
        )
)

But I want Like this

Array
    (
        [0] => Array
            (
                [Id] => 10
                [Name] => Sachin
                [Gender] => M
            )

        [1] => Array
            (
                [Id] => 12
                [Name] => Sourav
                [Gender] => M
            )
    )

I already tried using get() and toArray() but its giving call to unknown member function. Anyone have an idea how to resolved this issue.

coatesap · Accepted Answer · 2021-06-02 08:47:16Z

8

If you just need to get raw nested arrays of data, without using Eloquent:

$data = DB::connection()->getPdo()
    ->query("SELECT * FROM users")
    ->fetchAll(\PDO::FETCH_ASSOC);

This should be much more efficient than the current accepted answer.

edited Jun 2, 2021 at 8:47

coatesap

11.2k5 gold badges28 silver badges33 bronze badges

answered Apr 18, 2019 at 7:48

Afzal Patel

1441 silver badge6 bronze badges

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

3 Comments

Vytenis Ščiukas Over a year ago

Accepted answer will build models and on large datasets those approaches will crash. This answer is better because on large datasets you want to work with more raw data.

Chris Over a year ago

performance-wise this is the only correct answer. The other answers all convert into collections first and then back into arrays. I know the OP didn't ask for the best performing solution but if you're looking to get array data instead of Eloquent data I imagine it's probably for optimization reasons, and this is a great way to do it.

Hery Kurniawan Over a year ago

however this answer will not log the query

Raghbendra Nayak · Accepted Answer · 2017-07-27 06:29:52Z

You just use the laravel standard function

public function testData(){
    $data = YOUR_MODEL_NAME::all()->toArray();
    echo "<pre>";print_r($data);
}

UPDATED:

public function testData(){
    $data =  DB::select('select * from users');
    $data = collect($data)->map(function($x){ return (array) $x; })->toArray(); 
    echo "<pre>";print_r($data);
}

Output will be :

UPDATED:

Array
(
    [0] => Array
        (
            [email] => [email protected]
            [member_code] => BMC0001ADMIN
        )

    [1] => Array
        (
            [email] => [email protected]
            [member_code] => BMC0003ADMIN
        )

    [2] => Array
        (
            [email] => [email protected]
            [member_code] => BMC0002ADMIN
        )
)

I hope it will work to you.

I know its works with eloquent but I could not use Eloquent in my situation.so please do answer if you know how to do with DB::select

Arun pandian M · Accepted Answer · 2017-07-27 05:58:51Z

2

toArray is a model method of Eloquent, so you need to a Eloquent model, try this:

 User::all()->toArray();

http://laravel.com/docs/eloquent#collections

answered Jul 27, 2017 at 5:58

Arun pandian M

89210 silver badges17 bronze badges

2 Comments

lightbyte Over a year ago

This only returns an array of models. I guess what Raj wants is an array of array. toArray() only changes collection to array.

btx Over a year ago

This converts the data to a collection and then back to an array. Huge performance loss!

Ajowi · Accepted Answer · 2024-07-21 18:18:51Z

0

After several trials of the solutions suggested, the problem why Laravel complains that the returned set is db:query (and thereby not eloquent collection - am new to these terms) is that the given line of code is incomplete:

$data =  DB::select('select * from users');
//should change to something like
$data =  DB::select('select * from users')->get();
//then to get pure array, just add the to-array method as:
$data =  DB::select('select * from users')->get()->toArray();
//if the above does not work, then as a last resort (from answer here) 
$data = collect($data)->map(function($x){ return (array) $x; })->toArray();

I hope this helps someone in same situation. Tested at Laravel 11.x.

edited Jul 21, 2024 at 18:18

answered Jul 21, 2024 at 16:20

Ajowi

5355 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to return array instead of object in laravel 5

4 Answers 4

3 Comments

6 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

6 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related