How to return array instead of object in laravel 5

Asked 27/7, 2017 at 5:51 Answered 21/7 at 16:20

Solved laravel-5 sql-server-2014

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.

Memling answered 27/7, 2017 at 5:51 Comment(0)

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.

Nahuatl answered 27/7, 2017 at 6:8 Comment(6)

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 – Memling 27/7, 2017 at 6:10

So you want it without of Eloquent ? – Nahuatl 27/7, 2017 at 6:11

You will pass raw query always ? – Nahuatl 27/7, 2017 at 6:14

yes I have row query. like DB::select('my query') – Memling 27/7, 2017 at 6:15

Please check my updated answer, is that work for you? – Nahuatl 27/7, 2017 at 6:24

Let us continue this discussion in chat. – Nahuatl 27/7, 2017 at 6:30

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.

Equip answered 18/4, 2019 at 7:48 Comment(3)

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. – Leakage 21/4, 2022 at 15:29

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. – Detritus 6/5, 2023 at 22:8

however this answer will not log the query – Wreathe 9/6, 2023 at 11:52

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.

Nahuatl answered 27/7, 2017 at 6:8 Comment(6)

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 – Memling 27/7, 2017 at 6:10

So you want it without of Eloquent ? – Nahuatl 27/7, 2017 at 6:11

You will pass raw query always ? – Nahuatl 27/7, 2017 at 6:14

yes I have row query. like DB::select('my query') – Memling 27/7, 2017 at 6:15

Please check my updated answer, is that work for you? – Nahuatl 27/7, 2017 at 6:24

Let us continue this discussion in chat. – Nahuatl 27/7, 2017 at 6:30

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

Scaffolding answered 27/7, 2017 at 5:58 Comment(2)

This only returns an array of models. I guess what Raj wants is an array of array. toArray() only changes collection to array. – Dorton 20/5, 2020 at 12:1

This converts the data to a collection and then back to an array. Huge performance loss! – Coldhearted 12/12, 2022 at 14:17

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.

Bear answered 21/7 at 16:20 Comment(0)

Hot tags

Godot Unity Godot Help Programming Godot 4.X GUI GDScript 3D 2D Physics CSharp Godot 3.X VR XR Projects C++

Recommended topics

Hot tags