Laravel return specific model attribute

Question

Let's say I have User Model. Each User has Pet model.

both have relationship setup correctly.

When I get the user data along with his pets, I do this:

return $this->with('pets');

but what if I want to return the pet name only with the user data? I've been trying that:

return $this->with('pets.name');

Didn't work for me.

Hashmat Waziri · Accepted Answer · 2016-05-15 17:24:10Z

1

Model

 Class User extends Model ()
 {         
          ...
          public function pets()
           {
              return $this->hasOne('App\Model\Pet');
           }
 }

Controller or Repository or any other object

  function getUserDetails (Request $request) 
   {
         $userId = $request->get('id');
        $findUserById = User::find($userId);
        $fullName = $findUserById->pets->fullname;
   }

answered May 15, 2016 at 17:24

Hashmat Waziri

4779 silver badges9 bronze badges

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

Comments

Murlidhar Fichadia · Accepted Answer · 2016-05-15 18:58:33Z

0

You can do this way :

$users_with_pet_name = DB::table('users')
        ->join('pets', 'users.id', '=', 'pets.user_id')
        ->select('users.*', 'pets.name')
        ->get();

Check out joins section: https://laravel.com/docs/5.1/queries#joins

answered May 15, 2016 at 18:58

Murlidhar Fichadia

2,6298 gold badges47 silver badges104 bronze badges

Collectives™ on Stack Overflow

Laravel return specific model attribute

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related