Laravel Eloquent How to get only certain columns from joined tables

Question

I have got 2 joined tables in Eloquent namely themes and users   theme model   public function user       return  this- gt belongs to  User        user model   public function themes       return  this- gt has many  Theme        My Eloquent api call looks as below   return Response  eloquent Theme  with  user  - gt get       Which returns all columns from theme  that s fine   and all columns from user  not fine   I only need the  username  column from the user model  how can I limit the query to that

User · Answer

This Way   Post  with array  user   gt function  query        query- gt select  id   username       - gt get

User · Answer

Using with pagination    data   DB  table  themes   - gt join  users    users id         themes user id   - gt select  themes      users username   - gt paginate 6

User · Answer

Change your model to specify what columns you want selected   public function user       return  this- gt belongs to  User  - gt select array  id    username         And don t forget to include the column you re joining on

User · Answer

Using Model   Model  where  column   value  - gt get   column1   column2   column3           Using Query Builder   DB  table  table name  - gt where  column   value  - gt get   column1   column2   column3

User · Answer

I know that this is an old question  but if you are building an API  as the author of the question does  use output transformers to perform such tasks   Transofrmer is a layer between your actual database query result and a controller  It allows to easily control and modify what is going to be output to a user or an API consumer   I recommend Fractal as a solid foundation of your output transformation layer  You can read the documentation here

User · Answer

You can supply an array of fields in the get parameter like so   return Response  eloquent Theme  with  user  - gt get array  user username       UPDATE  for Laravel 5 2  From the docs  you can do this    response   DB  table  themes       - gt select  themes      users username       - gt join  users    users id         themes user id       - gt get

User · Answer

For Laravel    5 2  Use the - pluck   method   roles   DB  table  roles  - gt pluck  title         If you would like to retrieve an array containing the values of a single column  you may use the pluck method     For Laravel  lt   5 1  Use the - lists   method   roles   DB  table  roles  - gt lists  title         This method will return an array of role titles  You may also specify a custom key column for the returned array

User · Answer

I know  you ask for Eloquent but you can do it with Fluent Query Builder   data   DB  table  themes       - gt join  users    users id         themes user id       - gt get array  themes      users username

User · Answer

user2317976 has introduced a great static way of selecting related tables  columns   Here is a dynamic trick I ve found so you can get whatever you want when using the model   return Response  eloquent Theme  with array  user    gt  function   q         q- gt addSelect array  id   username       - gt get      I just found this trick also works well with load   too  This is very convenient    queriedTheme- gt load array  user   gt function  q   q- gt addSelect          Make sure you also include target table s key otherwise it won t be able to find it

User · Answer

In Laravel 4 you can hide certain fields from being returned by adding the following in your model   protected  hidden   array  password   secret field      http   laravel com docs eloquent converting-to-arrays-or-json

User · Answer

This is how i do it   posts   Post  with   category    gt  function  query            query- gt select  id    name             - gt get      First answer by user2317976 did not work for me  i am using laravel 5 1

User · Answer

Check out  http   laravel com docs database eloquent to-array  You should be able to define which columns you do not want displayed in your api

User · Answer

On Laravel 5 5  the cleanest way to do this is   Theme  with  user userid name address  - gt get     You add a colon and the fields you wish to select separated by a comma and without a space between them

User · Answer

If I good understood this what is returned is fine except you want to see only one column  If so this below should be much simpler   return Response  eloquent Theme  with  user  - gt get   username

User · Answer

Another option is to make use of the  hidden property on the model to hide the columns you don t want to display  You can define this property on the fly or set defaults on your model   public static  hidden   array  password      Now the users password will be hidden when you return the JSON response   You can also set it on the fly in a similar manner   User   hidden   array  password

[php] Laravel Eloquent: How to get only certain columns from joined tables

Examples related to php

Examples related to laravel

Examples related to eloquent