Query builder get array of results instead of objects in Laravel

Question

Here's my query

DB::table('genres')
        ->join('albumGenres', 'genres.id', '=', 'albumGenres.genre_id')
        ->join('albums', 'albumGenres.album_id', '=', 'albums.id' )
        ->select('genres.id')
        ->where('albumGenres.album_id','=',$this->id)->get();

But I get something like this

"genre_id": [
        {
            "id": "4"
        },
        {
            "id": "8"
        }
    ]

What should I do to get the results as just an array

"genre_id" : [4,8]

$result = array_column($result->toArray(), 'id'); perhaps? — Mark Baker
– Mark Baker, Commented May 11, 2015 at 18:31

Sebastien · Accepted Answer · 2017-04-14 07:52:59Z

7

With new versions of Laravel, you should use pluck() instead of lists().

DB::table('genres')
->join('albumGenres', 'genres.id', '=', 'albumGenres.genre_id')
->join('albums', 'albumGenres.album_id', '=', 'albums.id' )
->where('albumGenres.album_id', '=', $this->id)
->pluck('genres.id');

Here is the reference in the documentation: https://laravel.com/docs/5.4/queries#retrieving-results (see 'Retrieving A List Of Column Values')

answered Apr 14, 2017 at 7:52

Sebastien

62510 silver badges15 bronze badges

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

1 Comment

Jass Over a year ago

Using pluck is not good when you are dealing with bulk data. It is pretty slow.

Limon Monte · Accepted Answer · 2015-05-11 18:43:07Z

6

Just use ->lists('id') instead of ->get():

DB::table('genres')
    ->join('albumGenres', 'genres.id', '=', 'albumGenres.genre_id')
    ->join('albums', 'albumGenres.album_id', '=', 'albums.id' )
    ->where('albumGenres.album_id', '=', $this->id)
    ->lists('genres.id');

Read more: http://laravel.com/docs/5.0/queries#selects (Retrieving A List Of Column Values section)

edited May 11, 2015 at 18:43

answered May 11, 2015 at 18:32

Limon Monte

54.8k49 gold badges191 silver badges222 bronze badges

7 Comments

Vector Over a year ago

This returns null. However, using it to query other field works as expected. What?

return DB::table('genres')             ->join('albumGenres', 'genres.id', '=', 'albumGenres.genre_id')             ->join('albums', 'albumGenres.album_id', '=', 'albums.id' )             ->select('genres.name')             ->where('albumGenres.album_id','=',$this->id)->lists('name');

Limon Monte Over a year ago

@Vector I just edited my answer, try again with updated code.

Limon Monte Over a year ago

@Vector replace ->lists('genres.id'); with ->toSql(); and paste result here.

Vector Over a year ago

select 'genres'.'id' from 'genres' inner join 'albumGenres' on 'genres'.'id' = 'albumGenres'.'genre_id' inner join 'albums' on 'albumGenres'.'album_id' = 'albums'.'id' where 'albumGenres'.'album_id' = ? (Replaced back ticks with quotes)

Limon Monte Over a year ago

@Vector please run this query in mysql/pgsql console (don't forget to replace ? with id you want) and paste result here.

|

Collectives™ on Stack Overflow

Query builder get array of results instead of objects in Laravel

2 Answers 2

1 Comment

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related