Laravel - get DB result without table column name

Question

I wanted to have the result with only the values not with the table column name in Laravel 4.2. For example,

$recs = DB::table('table_name')
        ->select('id', 'title')
        ->get();

the result is

array(2) {
  [0]=>
  object(stdClass)#863 (2) {
    ["id"]=>
    int(2)
    ["title"]=>
    string(8) "my title"
  }
  [1]=>
  object(stdClass)#862 (2) {
    ["id"]=>
    int(3)
    ["title"]=>
    string(10) "my title 2"
  }
}

but I want to have only the result NOT the column name, like

[
  2,
  "my title"
],
[
  3,
  "my title 2"
]

yes, I can make it by looping the result and make new array without column name. But is there are any way to get the result in this fashion using Laravel ?

EddyTheDove · Accepted Answer · 2017-03-23 14:22:14Z

9

Try

$recs = DB::table('table_name')->pluck('id', 'title');
dd($recs->all());

edited Mar 23, 2017 at 14:22

answered Mar 23, 2017 at 13:58

EddyTheDove

13.2k2 gold badges40 silver badges46 bronze badges

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

2 Comments

EddyTheDove Over a year ago

Oh sorry, you need to append all(). Check my code again.

user2609021 Over a year ago

'pluck' returning a number and so it is showing error when put 'all()' to a number

Alexey Mezenin · Accepted Answer · 2017-03-23 16:05:16Z

1

You can use the map() and the array_values() methods:

$recs->map(function($i) {
    return array_values((array)$i);
})

I'm not sure about Laravel 4.2, but I've just tested it and it works perfectly in Laravel 5.3. If it doesn't work in 4.2, use the native array_map() function instead.

edited Mar 23, 2017 at 16:05

answered Mar 23, 2017 at 14:05

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

2 Comments

DevK Over a year ago

That is the only (nearly) correct answer for what I know. You'll just need to do return array_values($i->toArray()); to make use of array_values. That being said I'm really interested in use case for this (converting human-readable keys into indexes).

Alexey Mezenin Over a year ago

@devk I've tested it too and since OP is using Query Builder here, toArray() will return an error. At least in 5.3 (not sure about 4.2 though). I've edited my code to cast objects to arrays. I've copied wrong code first. Thanks for mentioning that.

Saumini Navaratnam · Accepted Answer · 2017-03-24 05:01:20Z

1

Reference

Try $recs->flatten()->all()

Update

Since your $recs looks like an array from your error. Try converting to collection. I hope this will work on v4.2

$recsCollection = new \Illuminate\Database\Eloquent\Collection($recs);
$recsCollection->flatten()->all();

edited Mar 24, 2017 at 5:01

answered Mar 23, 2017 at 14:06

Saumini Navaratnam

8,9455 gold badges47 silver badges75 bronze badges

4 Comments

user2609021 Over a year ago

thanks for the reply... im getting error since im using Laravel 4.2 and the given reference is in 5.4

user2609021 Over a year ago

getting error "Call to a member function flatten() on array"

user2609021 Over a year ago

"Call to undefined function collect()" i think 'collect' is not supported at 4.2

Saumini Navaratnam Over a year ago

Updated the answer. collect helper function is not available in v4.2

Preshan Pradeepa · Accepted Answer · 2018-09-12 11:08:28Z

1

DB::table('table_name')->all()->lists('id', 'title')->toArray()

Referance: Retrieving A List Of Column Values

answered Sep 12, 2018 at 11:08

Preshan Pradeepa

68314 silver badges31 bronze badges

Collectives™ on Stack Overflow

Laravel - get DB result without table column name

4 Answers 4

2 Comments

2 Comments

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

2 Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related