Insert array values into database in laravel

Question

I have 8 different questions that are coming from the database randomly.

Now I want to insert the question_id, user_id and en_answer into en_answers table.

Data was inserted, but here is some error like - the first one is, it's inserting only one-row value and the second one is, the question id is not correct.

I tried something like bellow. Would someone please help to correct the controller method -

In index.blade.php -

<form action="{{ url('en-question-answer') }}" method="POST">
       {{ csrf_field() }}
  <?php 
    $count=1;
  ;?>
  @foreach($equestions as $equestionType)
      @foreach($equestionType as $key => $equestion)
          <p>{{ $equestion->question }}</p>
          <input type="hidden" name="question_id[{{$count}}]" value="{{ $equestion->id }}">
          <label class="radio-inline">
           <input type="radio" name="en_answer[{{$count}}]" value="{{ $equestion->option1 }}">{{ $equestion->option1 }}
          </label>
           <label class="radio-inline">
           <input type="radio" name="en_answer[{{$count}}]" value="{{ $equestion->option2 }}">{{ $equestion->option2 }}
           </label>
             <hr>
    <?php $count++; ?>
       @endforeach
   @endforeach      
  <button type="submit" class="btn btn-primary btn-sm pull-right">Submit</button></form>

In my controller-

    public function store(Request $request, User $user){
    $user_id = Sentinel::getUser()->id;

    $answer = new EnAnswer;
    $answer->user_id     = $user_id;

    $data = Input::get();
    for($i = 1; $i < count($data['en_answer']); $i++) {
        $answer->en_answer     = $data['en_answer'][$i];
    }
    for($i = 1; $i < count($data['question_id']); $i++) {
        $answer->question_id     = $data['question_id'][$i];
    }

    //dd($answer);
    //return $answer;
    $answer->save();
    return redirect('submitted')->with('status', 'Your answers successfully submitted');

}

I believe Laravel has the Object::insert(array $array) or DB::table([name])->insert(array $array)) methods to insert array's — Raymond Nijland
– Raymond Nijland, Commented Jan 6, 2018 at 14:50
yess but for that you will have to set key-value .. key as column name and value that need to be inserted. @RaymondNijland — Ali Raza Lilani
– Ali Raza Lilani, Commented Sep 8, 2021 at 7:42

Alexey Mezenin · Accepted Answer · 2018-01-06 14:52:45Z

19

You're inserting into DB just one answer, the last one. Also, you can prepare the data and insert all the answers with just one query:

public function store(Request $request)
{
    for ($i = 1; $i < count($request->en_answer); $i++) {
        $answers[] = [
            'user_id' => Sentinel::getUser()->id,
            'en_answer' => $request->en_answer[$i],
            'question_id' => $request->question_id[$i]
        ];
    }
    EnAnswer::insert($answers);
    return redirect('submitted')->with('status', 'Your answers successfully submitted');
}

answered Jan 6, 2018 at 14:52

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

juliushuck · Accepted Answer · 2020-06-30 12:58:35Z

0

$answers = [];
for ($i = 0; $i < count($request->day); $i++) {
    $answers[] = [
        'day' => $request->day[$i],
        'from' => $request->from[$i],
        'to' => $request->to[$i]
    ];

edited Jun 30, 2020 at 12:58

juliushuck

1,7821 gold badge14 silver badges26 bronze badges

answered Jun 30, 2020 at 9:35

Mohammad Usman

293 bronze badges

1 Comment

juliushuck Over a year ago

Please add an explanation to your answer

Collectives™ on Stack Overflow

Insert array values into database in laravel

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related