saving array of array into database laravel

Question

I have gone through an earlier post Storing Array of Arrays Let me firstly show what I have tried

Code:

public function createQuestions(Request $request)
{
  $elements = 0;
  while($elements < count($data["question"])) {
     $dataArray[] = array(
       question'          => $data['question'][$elements],
       'answer'            => $data['answer'][$elements],
       'questionnaire_id'  => $data['questionnaire_id'][$elements],
       'type'              => $data['type'][$elements],
       'flag'              => $data['flag'][$elements],
       'choice'              => $data['choice'][$elements],
       'created_at'    => Carbon\Carbon::now(), // only if your table has this column
       'updated_at'    => Carbon\Carbon::now(), // only if your table has this column
        );
$elements++;

}
Question::create($dataArray);

    return back()->with('message', 'Questionnaire is being created successfully'); 
}

The problems I am facing are different. Whenever I run the code. It throws an error

Undefined offset: 1

secondly it throws an error

General error: 1364 Field 'answer' doesn't have a default value. This error is being thrown for every database column.

I have declared these in fillable. Hence there should not be any issue.

protected $fillable = [
    'question', 'idea_id', 'answer', 'type', 'choice', 'flag',
];

I have changed my app name to Questionnaire May be this is the issue?

One thing was missing that is in fillable it should be questionnaire_id not idea_id. Thanks — Qasim Ali
– Qasim Ali, Commented Nov 20, 2016 at 17:20

Mruf · Accepted Answer · 2016-11-20 17:17:35Z

1

It seems there is an answer missing.

Try something like:

...
'answer'            => (array_key_exists($elements,$data['answer']))?$data['answer'][$elements]:"", // default value
...

Honestly the best solution would be to change your migration:

$table->text()->default("");

But the problem here, seems to be a missing parameter from the post request maybe.

answered Nov 20, 2016 at 17:17

Mruf

8088 silver badges17 bronze badges

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

5 Comments

Qasim Ali Over a year ago

I have dd it. everything is coming fine from there and also this was working a little while ago after undefined offset this issue started

Mruf Over a year ago

Can you post the array $data

Qasim Ali Over a year ago

Now the loop is working fine and data is storing in database. Thanks to you but now the issue is, it is storing the data twice and sometimes if there are 4 entries it replicate some of them and store 10 entries @Mruf

Mruf Over a year ago

Are you sure your data is submited correctly? It doesn't seem too be an error of laravel

Qasim Ali Over a year ago

Let us continue this discussion in chat.

Jan Willem · Accepted Answer · 2016-11-20 17:14:24Z

0

You can just use Eloquent's method insert:

Question::insert($dataArray);

Note: this will not update or set timestamps. But you added these timestamps in your $dataArray manually, so you already fixed this yourself.

answered Nov 20, 2016 at 17:14

Jan Willem

1,3201 gold badge10 silver badges10 bronze badges

1 Comment

Qasim Ali Over a year ago

I have also used insert instead of create it still gives undefined offset error

Collectives™ on Stack Overflow

saving array of array into database laravel

2 Answers 2

5 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related