jeudi 12 octobre 2023

How can loop and display studentId accoirding to the course_code

I want to display the students ID according to the batchId in table view. example for how I want.

EN01              EN02
12335             58965
45624             78956
46325             78599

This is my controller function.

if($request->courseId!="" && $request->batchId!="")
        {
            $courseCodes = batches::where('course_id','=', $request->courseId)->where('id','=',$request->batchId)->get();
        }else{
            $courseCodes = batches::where('course_id','=', $request->courseId)->get();
        }


        $course = courses::where('course_active','Yes')->where('course_active_flag','1')->get();
        $users = User::all();

        $tabliView = "";

        $studentData = DB::table('students')
            ->select('studentId', 'batchId','courseId')
            ->where('courseId', $request->courseId);

        if ($request->batchId != "") {
            $studentData->where('batchId', $request->batchId);
        }

        $studentData = $studentData->get();

And This is my table view with loop

<table class="table table-bordered text-nowrap border-bottom" id="basic-datatable">
                                        <thead>
                                            <tr>
                                                @foreach ($courseCode as $couscode)
                                                    <th class="wd-15p border-bottom-0"></th>
                                                @endforeach
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($studentData as $student)
                                                <tr>
                                                    @foreach ($courseCodes as $courseCode)
                                                        <td>
                                                            
                                                            @if ($student->batchId === $courseCode->id)
                                                                
                                                            @endif
                                                        </td>
                                                    @endforeach
                                                </tr>
                                            @endforeach
                                        </tbody>
                                </table>

Now the result is coming like each course code same student Id is printing but each course code has a unique batchId. Please help me to fix this issue.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire