Reputation: 489

How to return array instead of object in laravel 5

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.

Upvotes: 8

Answers (4)

Ajowi

Reputation: 505

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.

Upvotes: 0

Afzal Patel

Reputation: 144

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.

Upvotes: 8

Raghbendra Nayak

Reputation: 1646

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.

Upvotes: 6

Arun pandian M

Reputation: 882

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

Upvotes: 2

How to return array instead of object in laravel 5

Answers (4)

Related Questions