Laravel5 Eloquent custom method return array

Question

I have a static method in my User model which counts something, i am using a raw statement:

static function countOrders($userId)
{
   $sql = "SOME CUSTOM-COMPLICATED QUERY";
   $result = \DB::select( \DB::raw( $sql ) );
   return $result; // <-- toArray() ? returns Exception!
}

Somewhere in my controller:

$orders = User::countOrders(*USER-ID*);

How can I get an array with records as arrays and not objects without modifying the global configuration for the FETCH method?

Fabio Antunes · Accepted Answer · 2015-04-16 15:58:11Z

3

You don't need to run toArray().

When executing raw queries select returns array, it's stated in the docs:

The select method will always return an array of results.

static function countOrders($userId)
{
   $sql = "SOME CUSTOM-COMPLICATED QUERY";
   $result = \DB::select( \DB::raw( $sql ) );
   return $result;
}

edited Apr 16, 2015 at 15:58

answered Apr 16, 2015 at 12:26

Fabio Antunes

22.9k17 gold badges83 silver badges96 bronze badges

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

6 Comments

Broshi Over a year ago

Are you sure? I'm getting a Call to a member function get() on a non-object

Fabio Antunes Over a year ago

Well I noticed tha you have another error, you must do \DB::table(''name_of_table")->select(\DB::raw( $sql ))->get();

Fabio Antunes Over a year ago

can you show us your "SOME CUSTOM-COMPLICATED QUERY"

Fabio Antunes Over a year ago

I've edited my answer, your code was right, you don't need to do a toArray(), since select already returns an array. Sorry as I have misunderstood your problem

Broshi Over a year ago

It returns an array, but each entry in that array is a stdObject, that's my issue. I want each entry to be an array as well.

|

Collectives™ on Stack Overflow

Laravel5 Eloquent custom method return array

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related