How to insert array to db using create Laravel method?

Question

There is a controller method:

public function addEducation(AddPatientEducationRequest $request) {

    dd($request->all());

    $state = UserEducation::create($request->validated());
}

The dd() returns me an array that I need to insert into db:

array:1 [ // app\Http\Controllers\Api\PatientController.php:99
  "education" => array:1 [
    0 => array:5 [
      "patient_id" => 1
      "education_id" => 2
      "diplom" => "ZV 800"
      "start_date" => "2021-10-30"
      "end_date" => "2022-10-30"
    ]
  ]
]

I tried this way using loop:

foreach($request->education as $value) { UserEducation::create($value); }

Lajos Arpad · Accepted Answer · 2022-12-30 14:31:52Z

1

Your content looks like this:

[
    'education' => [
        //some fields
    ]
]

So, you can reach your record like this:

myArray['education'][0]

, hence your script should be

foreach($request['education'] as $value) {
    UserEducation::create($value);
}

answered Dec 30, 2022 at 14:31

Lajos Arpad

80.4k42 gold badges123 silver badges235 bronze badges

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

Comments

John Lobo · Accepted Answer · 2022-12-30 15:06:37Z

1

If education multidimensional array matches database columns then you can use the insert method like below

UserEducation::insert($request->education)

Ref :Insert Statements

answered Dec 30, 2022 at 15:06

John Lobo

15.4k2 gold badges18 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to insert array to db using create Laravel method?

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related