John Davidson

public function collection(Collection $rows)

    {

        foreach ($rows as $row) {

            $IDnumber = $row['IDnumber'];

            $name = $row['firstname'];

            $exam = $row['exam'];

            $course = $row['course'];

            $courseCode = $row['coursecode'];

            $question = $row['question'];



            $user = User::withTrashed()->firstOrCreate(

                ['IDnumber' => $IDnumber],

                [

                    'IDnumber' => $IDnumber,

                    'first_name' => $firstname, 

                ]

            );



            $q_insert = \Modules\Qulak\Entities\Question::create(

                [

                    'question' => $question,

                    'question_type' => 'MCQ',

                    'user_id' => $user->id,

                    'created_by' => Auth::user()->id,

                    'updated_by' => Auth::user()->id,

                ]

            );

        }

---

My Answer:
> In order to read the answers of the question downwards and save them to the database, you can modify your `collection` method as follows:

php
public function collection(Collection $rows)
{
foreach ($rows as $row) {
$IDnumber = $row['IDnumber'];
$name = $row['firstname'];
$exam = $row['exam'];
$course = $row['course'];
$courseCode = $row['coursecode'];
$question = $row['question'];

// Get the question answers by looping through the remaining columns
$answers = [];
foreach ($row as $key => $value) {
if ($key !== 'IDnumber' && $key !== 'firstname' && $key !== 'exam' && $key !== 'course' && $key !== 'coursecode' && $key !== 'question') {
$answers[] = $value;
}
}

// Save the question and answers to the database
$newQuestion = Question::create([
'IDnumber' => $IDnumber,
'name' => $name,
'exam' => $exam,
'course' => $course,
'courseCode' => $courseCode,
'question' => $question,
]);

foreach ($answers as $answer) {
QuestionAnswer::create([
'question_id' => $newQuestion->id,
'answer' => $answer,
]);
}
}
}


This code snippet will loop through each row in the Excel file, extract the question and answers, and save them to the database accordingly. Make sure to adjust the model names and relationships based on your Laravel project structure.