How to save array of objects to mysql database in laravel?

Question

I am using vue with laravel. I am trying to save array of objects but not able to do it though i am able to save single object. Here is my code App.vue

// Not working
saveData(){
  this.axios.post('/addperson', **this.rows**).then((response) => {
    console.log("WOW");
  })
}

//working
    saveData(){
      this.axios.post('/addperson', **this.rows[0]**).then((response) => {
        console.log("WOW");
      })
    }

Here is controller code where i am getting error when i pass array.

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\OrderPerson;

class PersonController extends Controller
{
  public function create(Request $request){

      $person = new Person([
        'name' => $request->get('name'),
        'age' => $request->get('age'),
        'user_id' =>$request->get('user_id')''
      ]);

      $person->save();
    return response()->json('Successfully added');
  }
}

Can any body help me to save the array?

you can use serialise method to store in db

Vision Coderz
– Vision Coderz

2017-09-16 06:13:16 +00:00
Commented Sep 16, 2017 at 6:13 — Vision Coderz
– Vision Coderz, Commented Sep 16, 2017 at 6:13
@iCoders, can you give me reference link?

Hitendra
– Hitendra

2017-09-16 06:27:09 +00:00
Commented Sep 16, 2017 at 6:27 — Hitendra
– Hitendra, Commented Sep 16, 2017 at 6:27
stackoverflow.com/questions/8641889/…

Vision Coderz
– Vision Coderz

2017-09-16 06:28:28 +00:00
Commented Sep 16, 2017 at 6:28 — Vision Coderz
– Vision Coderz, Commented Sep 16, 2017 at 6:28

Nitish Kumar · Accepted Answer · 2017-09-16 07:23:50Z

3

First of all assign all the this.rows to a data set then push it to the axios call something like this:

saveData(){
    const postData = {
            data: this.rows
        }
  this.axios.post('/addperson', postData).then((response) => {
    console.log("WOW");
  })
}

Now in laravel controller you can use foreach to use this data set.

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\OrderPerson;

class PersonController extends Controller
{
  public function create(Request $request){

    foreach($request->data as $data)
    {
        $container = new Person([
            'name' => $data['name'],
            'age' => $data['age'],
            'user_id' => $data['user_id']
          ]);

        $container->save();
    }

    return response()->json('Successfully added');
  }
}

Hope this helps.

answered Sep 16, 2017 at 7:23

Nitish Kumar

6,30722 gold badges88 silver badges160 bronze badges

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

Collectives™ on Stack Overflow

How to save array of objects to mysql database in laravel?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related