How can I build a query in my controller action that indexes parent models, with parent-specific children nested using foreach loops?

Question

I'm currently trying to create an index of cards depicting rooms, with their associated desks indexed within them, using nested foreach loops within the view:


                    @foreach ($rooms as $room)
                        
                            {{ $room->name }}
                            
                                
                                    @foreach ($desks as $desk)
                                        
                                            Desk {{ $desk->id }}
                                        
                                    @endforeach
                                
                            
                        
                    @endforeach

The Room controller index action currently looks like this:

class RoomController extends Controller
{
    public function index()
        {
    
            return view('index', [
                'rooms' => Room::all(), 
                'desks' => Desk::all()
            ]);
        }
}

I'm aware that Desk::all() is indexing all desks for all rooms. Instead, I need to build a query that indexes desks belonging only to each room. My model relationships are defined as:

Room hasMany desks

Desk belongsTo room

Any help would be much appreciated, thanks.

user_13796551 · Answer

instant doing like rooms::all and desk::all use can simply run an eloquent query like:-

room::with("desks")->get();

note :-you need to make a relation in your room model with name "desks" like this :-

public function desks(){
    return $this->hasMany(desk::class);
}

and your foreign key name must be like model name +_id

user_17159597 · Answer

Managed to solve this. Desk::all() worked as I wanted to make all desks available at controller level. Instead I added a where clause to the nested foreach loop to filter by room_id:


                    @foreach ($rooms as $room)
                        
                            {{ $room->name }}
                            
                                
                                    @foreach ($desks->where('room_id', $room->id) as $desk)
                                        
                                            Desk {{ $desk->id }}
                                        
                                    @endforeach

How can I build a query in my controller action that indexes parent models, with parent-specific children nested using foreach loops?

2 Answers