Get an array of integer with Laravel query builder

Question

I have this query :

$inError = DB::table('errors')            
        ->select('fk_fact')
        ->distinct()
        ->get();

And I want it to return an array of integers instead of returning an array of objects, I don't want to loop over all the results and push the values one by one... Is there a way to do this with Laravel?

Joel Hinz · Accepted Answer · 2015-08-26 14:15:54Z

5

Sure, you can use the built-in lists() method:

$inError = DB::table('errors')            
    ->select('fk_fact')
    ->distinct()
    ->lists('fk_fact');

You may need to tack on an ->all() after the lists call.

Here's a tinker example from a database I happened to have up:

>>> DB::table('teams')->select('name')->distinct()->lists('name');
=> [
     "AFC Bournemouth",
     "Arsenal",
     "Aston Villa",
     "Chelsea",
     "Crystal Palace",
     "Everton",
     "Leicester City",
     "Liverpool",
     "Manchester City",
     "Manchester United",
     "Newcastle United",
     "Norwich City",
     "Southampton",
     "Stoke City",
     "Sunderland",
     "Swansea City",
     "Tottenham Hotspur",
     "Watford",
     "West Bromwich Albion",
     "West Ham United",
   ]

answered Aug 26, 2015 at 14:15

Joel Hinz

25.4k8 gold badges65 silver badges78 bronze badges

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

Comments

Eduardo · Accepted Answer · 2021-02-18 19:52:57Z

1

lists was removed in newer versions of the query builder. You can use pluck now.

$inError = DB::table('errors')            
->distinct()
->pluck('fk_fact');

answered Feb 18, 2021 at 19:52

Eduardo

2771 gold badge6 silver badges17 bronze badges

1 Comment

jssDev Over a year ago

pluck()->toArray() returns a simple array

Collectives™ on Stack Overflow

Get an array of integer with Laravel query builder

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related