Get only specific attributes with from Laravel Collection

Question

I ve been reviewing the documentation and API for Laravel Collections  but don t seem to find what I am looking for   I would like to retrieve an array with model data from a collection  but only get specified attributes   I e  something like Users  toArray  id   name   email    where the collection in fact holds all attributes for the users  because they are used elsewhere  but in this specific place I need an array with userdata  and only the specified attributes   There does not seem to be a helper for this in Laravel  - How can I do this the easiest way

User · Answer

this seems to work  but not sure if it s optimized for performance or not    request- gt user  - gt get   id   - gt groupBy  id  - gt keys  - gt all     output   array 2     0   gt  4   1   gt  1

User · Answer

You need to define  hidden and  visible attributes  They ll be set global  that means always return all attributes from  visible array   Using method makeVisible  attribute  and makeHidden  attribute  you can dynamically change hidden and visible attributes  More  Eloquent  Serialization -  Temporarily Modifying Property Visibility

User · Answer

I have now come up with an own solution to this   1  Created a general function to extract specific attributes from arrays  The function below extract only specific attributes from an associative array  or an array of associative arrays  the last is what you get when doing  collection- toArray   in Laravel    It can be used like this    data   array extract   collection- gt toArray      id   url        I am using the following functions   function array is assoc   array             return is array   array    amp  amp  array diff key   array  array keys array keys  array           function array extract   array   attributes          data            if   array is assoc   array                   foreach    attributes as  attribute                          data   attribute      array   attribute                        else               foreach    array as  key   gt   values                          data   key                      foreach    attributes as  attribute                                  data   key     attribute      values   attribute                                          return  data         This solution does not focus on performance implications on looping through the collections in large datasets   2  Implement the above via a custom collection i Laravel  Since I would like to be able to simply do  collection- gt extract  id   url    on any collection object  I have implemented a custom collection class   First I created a general Model  which extends the Eloquent model  but uses a different collection class  All you models need to extend this custom model  and not the Eloquent Model then    lt  php namespace App Models  use Illuminate Database Eloquent Model as EloquentModel  use Lib Collection  class Model extends EloquentModel       public function newCollection array  models                     return new Collection   models                  gt    Secondly I created the following custom collection class    lt  php namespace Lib  use Illuminate Support Collection as EloquentCollection  class Collection extends EloquentCollection       public function extract                  attributes   func get args            return array extract   this- gt toArray     attributes                 gt    Lastly  all models should then extend your custom model instead  like such    lt  php namespace App Models  class Article extends Model         Now the functions from no  1 above are neatly used by the collection to make the  collection- gt extract   method available

User · Answer

Method below also works    users   User  all  - gt map function   user      return collect  user - gt only   id    name    email

User · Answer

users   Users  get      subset    users- gt map function   user        return array only user    id    name    email

User · Answer

use User  get   id    name    email     it will return you a collection with the specified columns and if you want to make it an array  just use toArray   after the get   method like so   User  get   id    name    email   - gt toArray     Most of the times  you won t need to convert the collection to an array because collections are actually arrays on steroids and you have easy-to-use methods to manipulate the collection

User · Answer

I had a similar issue where I needed to select values from a large array  but I wanted the resulting collection to only contain values of a single value   pluck   could be used for this purpose  if only 1 key item is required   you could also use reduce    Something like this with reduce    result    items- gt reduce function  carry   item        return  carry- gt push  item- gt getCode        collect

User · Answer

This avoid to load unised attributes  directly from db  DB  table  roles  - gt pluck  title    name     References  https   laravel com docs 5 8 queries retrieving-results  search for pluck  Maybe next you can apply toArray   if you need such format

User · Answer

this is a follow up on the patricus  answer  1  above but for nested arrays    topLevelFields      id   status     userFields     first name   last name   email   phone number   op city id     return  onlineShoppers- gt map function   user         return collect  user - gt only  topLevelFields                               - gt merge collect  user  user   - gt only  userFields  - gt all            - gt all

User · Answer

You can do this using a combination of existing Collection methods  It may be a little hard to follow at first  but it should be easy enough to break down     get your main collection with all the attributes     users   Users  get        build your second collection with a subset of attributes  this new    collection will be a collection of plain arrays  not Users models   subset    users- gt map function   user        return collect  user- gt toArray            - gt only   id    name    email            - gt all         Explanation First  the map   method basically just iterates through the Collection  and passes each item in the Collection to the passed in callback  The value returned from each call of the callback builds the new Collection generated by the map   method  collect  user- gt toArray    is just building a new  temporary Collection out of the Users attributes  - gt only   id    name    email    reduces the temporary Collection down to only those attributes specified  - gt all   turns the temporary Collection back into a plain array  Put it all together and you get  quot For each user in the users collection  return an array of just the id  name  and email attributes  quot   Laravel 5 5 update Laravel 5 5 added an only method on the Model  which basically does the same thing as the collect  user- gt toArray   - gt only       - gt all    so this can be slightly simplified in 5 5  to     get your main collection with all the attributes     users   Users  get        build your second collection with a subset of attributes  this new    collection will be a collection of plain arrays  not Users models   subset    users- gt map function   user        return  user- gt only   id    name    email          If you combine this with the  quot higher order messaging quot  for collections introduced in Laravel 5 4  it can be simplified even further     get your main collection with all the attributes     users   Users  get        build your second collection with a subset of attributes  this new    collection will be a collection of plain arrays  not Users models   subset    users- gt map- gt only   id    name    email

[php] Get only specific attributes with from Laravel Collection

Examples related to php

Examples related to laravel