php - Query builder get array of results instead of objects in Laravel -
here's 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 this
"genre_id": [ { "id": "4" }, { "id": "8" } ]
what should results array
"genre_id" : [4,8]
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 list of column values section)
Comments
Post a Comment