Result query to single array of string

Question

I would like to transform the result of an Eloquent query into a single array of strings.

What my query currently gives: (I apply a ->toArray() to initial query to get that :)

array:2 [▼
  0 => array:1 [▼
    "title" => "User"
  ]
  1 => array:1 [▼
    "title" => "Premium"
  ]
]

What I would like it to give me:

['User', 'Premium'];

My query :

Rank::where('strength', '<', $this->rank->strength)->select('title')->get();

Thanks in advance

Rwd · Accepted Answer · 2021-08-23 09:15:17Z

1

You can use pluck():

Rank::where('strength', '<', $this->rank->strength)->pluck('title');

answered Aug 23, 2021 at 9:15

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

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

Comments

Rahul Jat · Accepted Answer · 2021-08-23 09:27:16Z

1

If you want exactly same array response instead of collection, You can add toArray() function at the last

$ranks = Rank::where('strength', '<', $this->rank->strength)
        ->pluck('title')->toArray();

answered Aug 23, 2021 at 9:27

Rahul Jat

7061 gold badge7 silver badges14 bronze badges