How to save dynamic data in database in laravel

Question

My project is on angularjs+Laravel.

From frontend I am sending dynamically generated input to laravel controller.

Scenario is I am taking family details where child field is dynamic.So if you click of Add more It will generate another input field.

Initially Person X have 1 child namely ROohan . Now he Have 2 more, Now when he is sending data of 3 new children, I want that 2 children data get added without over writing present 2 children.

My request which I am receiving in controller

family_data : 
      {"famdet":[{"id":"choice1","cname":"Rohan","doa":"2017-01-12"},  
       {"id":"choice2","cname":"sohan","cdob":"2017-01-13"},           
       {"id":"choice3","cname":"nitesh","cdob":"2017-01-07"}
          ]}

my problem is How to make this data save in separate row and if data is present then row should not be get created.

Create a model and corresponding database table. Then loop through each of the inputs, check it the models already exist and if not, create them. — Loek
– Loek, Commented Jan 17, 2017 at 16:05

Alexey Mezenin · Accepted Answer · 2017-01-17 16:06:37Z

1

First you need to use json_decode() to convert data to an array, for example:

$familyData = json_decode($data, true)['famdet'];

Then you should iterate over this array and use updateOrCreate() method to update existing rows or create new ones. For example, if you're using and ID to identify a row:

foreach ($familyData as $row) {
    Model::updateOrCreate(['id' => $row['id']], $row)
}

answered Jan 17, 2017 at 16:06

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

2 Comments

Mohammed Over a year ago

can you please elobrate more. I am not getting proper output. @Alexey Mezenin

Mohammed Over a year ago

How can I remove the field from table if user has removed some particular data. @AlexeyMezenin

Collectives™ on Stack Overflow

How to save dynamic data in database in laravel

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related