Best way to store much data in database

Issue

As you can see on the picture, I’ve a big table with all my products of my virtual webshop. This view is the admin panel. All the data you can see in the input field are fetched with a select statement when the page loads.

What I want to realise: When someone edits the value of an input field at different places in the table, this specific data should be updated in my database.

What is the best way to realise this? Do I need to work with multi-dimensional arrays? Fetch all the data of that input field and overwrite all my database with update statement?

enter image description here

Solution

I would add the id of the row in the edit form. So you can send that with the changed values to the backend. Now you can update only that changed row in the database.

Answered By – pinguinside

Answer Checked By – Clifford M. (AngularFixing Volunteer)

Leave a Reply

Your email address will not be published.