Laravel Eloquent relationship data retrieve

Question

I have below code to get data from database,

 $profile = Profiles::find(1);
 $currency = Profiles::find($profile->currency_id)->currency;

Then created a relationship in the model as below,

class Profiles extends Model
{
    use HasFactory;

    protected $table = 'Profiles';
    protected $primaryKey = 'profile_id';

    public function Currency()
    {
        return $this->belongsTo(Currencies::class, 'currency_id');
    }
}

class Currencies extends Model
{
    use HasFactory;

    protected $table = 'Currencies';
    protected $primaryKey = 'currency_id';

    public function profile()
    {
        return $this->hasOne(Profiles::class, 'currency_id');
    }
}

Problem is that there is only 1 profile and 100 currency, currency_id is a foreign key in Profiles table,

I could not get data and get this error, Trying to get property 'currency' of non-object"

If i use $currency = Profiles::find(1)->currency; then it retrieve first row of Curriencies table which is not required data.

How can I get currency row for that specific profile?

Answer 1

The problem is that the find() method will look for the primaryKey and in your second call the currency_id is not the pk. Two solution for you:

• replace the find by a where clause like so: $currency = Profiles::where('currency_id',$profile->currency_id)->value('currency')
• Or a more Laravel way to do it, through the relationship $currency = $profile->currency;