Laravel : Insert multiple data into database

Question

I have been creating Quesionnaire where there are 3 tables : standarts,questions,and responses.
Inside each standart have their own questions.

here is how my form question look like

           @foreach($standarts as $s)
                
                @endforeach
                    @csrf
                    
                        Dokumen Pendukung :
                        
                            
                        
                    
                    Penilaian
                    
                            @foreach($standarts as $s)
                                @if($s->type == 'Likert')
                                    
                                @else
                                    
                                @endif
                            @endforeach
                        
                        @foreach($standarts as $s)
                            @foreach($s->questions as $q)
                                

                                    @if($s->type == 'Likert')
                                        
                                    @else
                                        
                                    @endif
                                
                            @endforeach
                        @endforeach
                        
                        
                        
                            No
                            Pertanyaan 1
                                    2
                                    3
                                    4 Ya
                                    Tidak
                        
                        
                                    {{ $loop->iteration }}
                                    
                                        
                                        
                                        {{$q->question}}
                                    
                                            
                                        
                                        
                                            
                                        
                                        
                                            
                                        
                                        
                                            
                                        
                                            
                                        
                                        
                                            
                                        
                    
                    
                        Keterangan :
                        
                            
                        
                    
                    
                    
                        
                            
                        
                        
                            Batal

this is my controller :

        $request->all();
        foreach ( $request->get('answers') as $answer) {
            $answers[] = [
                'user_id' => \Auth::user()->id,
                'files_link' => $request->files_link,
                'question' => $request->question,
                'question_id' => $request->question_id,
                'answer' => $request->answers,
                'description' => $request->description,
            ];
        }

        dd($answers);

and here is how it look like at diedump :

array:3 [▼
  0 => array:6 [▼
    "user_id" => 3
    "files_link" => "http://127.0.0.1:8000/auditee/1/respons/"
    "question" => array:3 [▼
      0 => "Lorem Ipsum is "
      1 => "Lorem Ipsum is "
      2 => "Lorem Ipsum is "
    ]
    "question_id" => array:3 [▼
      0 => "6"
      1 => "7"
      2 => "8"
    ]
    "answer" => array:3 [▼
      0 => "Ya"
      1 => "Tidak"
      2 => "Ya"
    ]
    "description" => "asdasd"
  ]
  1 => array:6 [▶]
  2 => array:6 [▶]
]

While what i want is like this :

array:3 [▼
  0 => array:6 [▼
    "user_id" => 3
    "files_link" => "http://127.0.0.1:8000/auditee/1/respons/"
    "question" => "Lorem Ipsum is "
    "question_id" => "6"
    "answer" => "Ya"
    "description" => "asdasd"
  ]

  1 => array:6 [▼
    "user_id" => 3
    "files_link" => "http://127.0.0.1:8000/auditee/1/respons/"
    "question" => "Lorem Ipsum is"
    "question_id" => "7"
    "answer" => "Tidak"
    "description" => "asdasd"
  ]

  2 => array:6 [▶]
]

and then insert it to the database.

im new at laravel and i have been searching the whole day on internet some example to make it work.

Thanks before

John Lobo · Accepted Answer

You can do somethink like this

 @foreach($standarts as $s)
            @foreach($s->questions as $key=>$q)
                
                    {{ $loop->iteration }}
                    
                        
                        
                        {{$q->question}}
                    

                    @if($s->type == 'Likert')
                        
                            
                        
                        
                            
                        
                        
                            
                        
                        
                            
                        
                    @else
                        
                            
                        
                        
                            
                        
                    @endif
                   
                
            @endforeach
        @endforeach

So in your controller method you can

dd($request->all()); or dd($request->standart)

Laravel : Insert multiple data into database

Answers (1)

Related Questions