Eloquent get only one column as an array

Question

How to get only one column as one dimentional array in laravel 5 2 using eloquent   I have tried     array   Word relation  select  word two  - gt where  word one    word id - gt get  - gt toArray      but this one gives it as 2 dimentional array like   array 2           0   gt        array 1              word one    gt          int 2                 1   gt        array 1              word one    gt          int 3                  but I want to get it as   array 2         0   gt 2      1   gt 3

User · Answer

I came across this question and thought I would clarify that the lists() method of a eloquent builder object was depreciated in Laravel 5.2 and replaced with pluck().

// <= Laravel 5.1
Word_relation::where('word_one', $word_id)->lists('word_one')->toArray();
// >= Laravel 5.2
Word_relation::where('word_one', $word_id)->pluck('word_one')->toArray();

These methods can also be called on a Collection for example

// <= Laravel 5.1
  $collection = Word_relation::where('word_one', $word_id)->get();
  $array = $collection->lists('word_one');

// >= Laravel 5.2
  $collection = Word_relation::where('word_one', $word_id)->get();
  $array = $collection->pluck('word_one');

User · Answer

That can be done in short as   Model  pluck  column     where model is the Model such as User model  amp  column as column name like id  if you do   User  pluck  id       1 2 3          amp  of course you can have any other clauses like where clause before pluck

User · Answer

You can use the pluck method   Word relation  where  word one    word id - gt pluck  word two  - gt toArray      For more info on what methods are available for using with collection  you can you can check out the Laravel Documentation

User · Answer

I think you can achieve it by using the below code  Model  get   ColumnName   - gt toArray

User · Answer

If you receive multiple entries the correct method is called lists       Word relation  select  word two  - gt where  word one    word id - gt lists  word one  - gt toArray

[laravel] Eloquent get only one column as an array

Examples related to laravel

Examples related to eloquent

Examples related to laravel-5.2