How can i fetch data in a foreach() loop in Laravel controller

Question

I have a one-to-many relationship between group and students and I want to get all students of some groups so I do this:

public function getStudentsOfGroups()
{
    $groups = Auth::user()->groups;
    foreach($groups as $group){
        $students  = $group->students;
    }

    return view('teacher.home', compact('students'));
}

but it doesn't get the data I need, so what can I do instead?

$students[] = $group->students; otherwise you will only see the data from the last iteration — RiggsFolly
– RiggsFolly, Commented May 26, 2022 at 9:31

MuhammadMP · Accepted Answer · 2022-05-26 10:58:31Z

1

Try this:

$students = Student::whereHas('groups', function (Builder $query) {
    $query->where('your_foreign_key_on_groups', auth()->id());
})
->get();

NOTE: When you want to add something to an array, you should use this syntax:

$array[] = 'a new element';

edited May 26, 2022 at 10:58

answered May 26, 2022 at 9:41

MuhammadMP

4721 gold badge4 silver badges13 bronze badges

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

Comments

algmaal · Accepted Answer · 2022-05-26 09:41:41Z

0

    public function getStudentsOfGroups()
{
    $groups = Auth::user()->groups;
    foreach($groups as $group){
        $students[]  = $group->students;
    }

    return view('teacher.home', compact('students'));
}

answered May 26, 2022 at 9:41

algmaal

1

1 Comment

Marcello B. Over a year ago

Hi, please consider adding more details as to how this helps solve the question. The more detail you can add the more helpful your answer will be to other's. Please consider reviewing the how to answer article stackoverflow.com/help/how-to-answer

James Morey · Accepted Answer · 2022-05-26 11:14:06Z

0

You could do

$results = Auth::user()->groups->students

Or

$results = Group::with('students')->where('user_id', Auth::user()->id;

answered May 26, 2022 at 11:14

James Morey

134 bronze badges

Collectives™ on Stack Overflow

How can i fetch data in a foreach() loop in Laravel controller

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related