Laravel fetch numeric?

Question

How can I fetch an array of numeric arrays in Laravel?

Here's what I've got:

 $companies = Company::select(['id','name'])->get()->toArray();

This gives me back:

array:21 [
    0 => array:2 [
      "id" => 21
      "name" => "Cool Company"
    ]
    1 => array:2 [
      "id" => 4
      "name" => "Bacon Co"
    ]
    ....

But I want:

array:21 [
    0 => array:2 [
      21,
      "Cool Company"
    ]
    1 => array:2 [
      4,
      "Bacon Co"
    ]
    ....

a suggestion: $companies = Company::select(['id','name'])->get()->toArray()->map(function($item){ return array_flatten($item); }); — Naco
– Naco, Commented Aug 5, 2017 at 23:14
@user3681740 Don't think you can ->map after it's an array, and I think I'd want array_values instead, but regardless, surely I shouldn't have to do that? — mpen
– mpen, Commented Aug 5, 2017 at 23:16
sure, sorry, you can use array_map instead, or put toArray() after map(). — Naco
– Naco, Commented Aug 5, 2017 at 23:19
I'd like to know if this works for you: Company::select(['id','name'])->get()->map(function($item){ return array_flatten($item->toArray()); })->toArray(); — Naco
– Naco, Commented Aug 5, 2017 at 23:30
@user3681740 Yeah, it does give the correct result, it's just a stupid number of function calls and iterations for something so simple -- something that PDO could have easily given me with ->fetchAll(PDO::FETCH_NUM) — mpen
– mpen, Commented Aug 5, 2017 at 23:36

peterm · Accepted Answer · 2017-08-05 23:57:41Z

1

If you need this exact output you can do

$companies = App\Company::pluck('name', 'id')
    ->map(function ($name, $id) { 
        return [$id, $name]; 
    })
    ->values()
    ->toArray();

Output:

=> [
     [
       4,
       "Bacon Co",
     ],
     [
       21,
       "Cool Company",
     ],
   ]

Not sure what you're doing with it afterwards but maybe just the output of pluck() will suffice

$companies = App\Company::pluck('name', 'id')->toArray();

=> [
     4 => "Bacon Co",
     21 => "Cool Company",
   ]

edited Aug 5, 2017 at 23:57

answered Aug 5, 2017 at 23:51

peterm

93k16 gold badges157 silver badges162 bronze badges

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

1 Comment

mpen Over a year ago

No, I don't want it to be indexed. I'm serializing to JSON and I need an array, not an object. Your first solution will work I guess. Thanks

Collectives™ on Stack Overflow

Laravel fetch numeric?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related