best approach to insert multiple radio buttons into database Laravel

@Tray2 Thanks Tray for the help, may be I didn't make myself clear enough .. I have no struggles with database tables or how the end result will look like. I want to learn how to do the insertion of all the data . for ex; based on your examples. I know how to insert just question one. but I want to insert multiple questions. maybe I am complicating the process in my head and it's easier than that :D can you show me how the insertion function would look like for the very same two examples you showed.

@MahmoudMonem You insert them using a loop.

Here is an example on how to store a bunch of tracks

  public function storeTracks(array $tracks, ForeignKeyService $foreignKeyService): void
    {
        for ($i = 0; $i < $tracks['track_count']; $i++) {
            $track = [
                'position' => Str::padLeft($tracks['track_positions'][$i], 2, '0'),
                'title' => $tracks['track_titles'][$i],
                'duration' => $tracks['track_durations'][$i],
                'mix' => $tracks['track_mixes'][$i] ?? null,
                'record_id' => $tracks['record_id'],
            ];
            if ($this->isVariousArtists($tracks['record_artist'])) {
                $track['artist_id'] = $foreignKeyService->getArtistId($tracks['track_artists'][$i]);
            }
            Track::create($track);
        }
    }

Hello @Snapey thanks for your help, I have been trying to do the same and managed to get a very few things right, but still can't achieve what I have in mind.. so here is what I want to do and what I have tried so far.

What I am trying to do :

insert into responses table the user choices and their weights 
user_id : 
question_id: 
option_id: [ what he selected ] 
weight: [ the value of selected option ] 

------------------------
create new result table

user_id:
test_id:
result : which is a sum of selected options' weights 

what I tried so far

public function store(Request $request)
    {
        $question_id=  $request->input('question_id');

        $responses = [];
        $total_result =  //  couldn't define this
        foreach ($request->get('questions') as $question_id=> $option_id) {
            $question= question::find($question_id);
            
            $responses[] = [
                'question_id' => $question_id,
                'option_id' => $option_id, // couldn't define this 
            ];


        }
    
    }

@MahmoudMonem do you need to store what option they chose? Just return the weight by setting the weight as the radio value?

@Snapey

I managed to get everything working except capturing the values of user input ($weight). notice in my code below the $weight I gave it static value 3 to test and the insertion goes fine

I tried these, but none of them worked

 'weight' =>  $request->input('questions'); 
'weight' =>  $request->input('questions',[]); 

when I dd $request->all() .. I can see the weight values in an array "questions". how can I loop it to get each value [ weight ] alone.

Have a look at my code below

        $test_id=  $request->input('test_id');
        $answers = [];  
        foreach ($request->get('questions') as $question_id => $answer_id) {
            $question = Question::find($question_id);
            $option = Option::where('question_id',$question_id)
            ->where('id', $answer_id);
 
            $answers[] = [
                'question_id' => $question_id,
                'option_id' => $answer_id,
                'weight' => 3,
            ];
        }
        //dd($request->all());
        $result = Result::create([
            'test_id' => $test_id,
            'user_id' => \Auth::id(),
            'result' => $test_score
        ]);
        $result->answers()->createMany($answers);
        return back()->with('success');
    }

@MahmoudMonem you didn't answer my question. Why store which option they replied with AND the weight?

@Snapey oh apologies , I didn't realize it's a question.

I want to store the weight of every option they choose because my end result is about some calculations based on sum of these weights .. for example if the user picked the following weights : 1 4 4 5

The total sum of these weights will be 14 and if a user scored 14 this will mean something.

so in the answers table I will collect all these data.. then in the result page, I will do the calculations of weights and show final results accordingly.

@MahmoudMonem Yes. I know. But you don't need to know that they clicked the 4th radio and this had a weight of 2. Just that they scored 2.

@Snapey makes sense, so how can i capture the weights then ?

@MahmoudMonem you are aware that test_score is always 0?

@Tray2 .. yes Tray, I just put zero for now will focus on it later .. thank you :)