How to get select field in model using laravel?

Question

I want to fetch only the specific column seller_db from seller table with the help of model, but when i used this below code my relationship shows null value, please help me to find my mistake, and how can i fetch selected one field with model using laravel?

here is my User.php file.

User.php


    public function sellerDB()
        {
            $instance = $this->hasOne('\App\Seller', 'user_id', 'id')->select('seller_db');
            return $instance;
        }

you should be selecting the 'id' and any foreign keys needed for the relationship — lagbox, Jan 15 '21 at 07:10
@lagbox i already mentioned this, user_id is my foreign key, and id is my primary key. — , Jan 15 '21 at 07:20
what problem are you trying to solve at the moment? as this relationshp should just return the relationship and something else should specify if it wants to load all the fields or not — lagbox, Jan 15 '21 at 08:27

David Vanegas · Answer 1 · 2021-01-15T09:08:03.990

0

Edit: I made a mistake, I misunderstood your database design, it's necessary add an aditional method to resolve this:

    public function seller()
    {
        return $this->hasOne('\App\Seller', 'user_id', 'id')
    }

    public function sellerDB()
    {
        return $this->seller->seller_db;
    }

In this case you can call $user->sellerDB() and receive the column seller_db

edited Jan 15 '21 at 09:08

answered Jan 15 '21 at 07:39

David Vanegas

61
4

How to get select field in model using laravel?

1 Answers1