HasMany() not working in Laravel for fetch relationship wise records

Question

Currently, I'm working on laravel 6 with MySQL database.

So I want to fetch records with has Many relations wise.

Fetch Training Intensity Records vie multiple ids -- see image

TrainingGoalModel.php

/**
 * training_intensity_details => get multiple intensity with current goal
 *
 * @return void
 */
public function training_intensity_details()
{
    return $this->hasMany(TrainingIntensity::class, 'id', 'training_intensity_ids');
}

GoalController

$query = $query->with('training_intensity_details')->get();

,both applied,

$query = $query->with(['training_intensity_details'])->get();

But, Relation not applying. Please, Help me.

Relationship cannot work on comma separated ids. if you have hasMany relation with TrainingIntensity's table, then you should add goal id in training_intensities table instead of storing in goals table. — Shailesh Matariya
– Shailesh Matariya, Commented Dec 12, 2019 at 5:21

VIKAS KATARIYA · Accepted Answer · 2019-12-12 05:40:34Z

1

Try..

   public function training_intensity_details()
    {
        return $this->hasMany(TrainingIntensity::class, 'training_intensity_ids', 'id');
    }

answered Dec 12, 2019 at 5:40

VIKAS KATARIYA

6,0153 gold badges19 silver badges37 bronze badges

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

1 Comment

Nico Haase Over a year ago

Please add some explanation to your answer such that others can learn from it

Collectives™ on Stack Overflow

HasMany() not working in Laravel for fetch relationship wise records

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related