Editing multiple rows in a grid

Developers Programming
#1

I need to make an edit of a grid with a button to “save” and when pressed save all changes in each of the rows.

How I can approach this problem?

Will using javascript arrays and handle changes in each row?

Or can I use sql tables in memory (something like “cursors”) that do not affect the database but the application behave like a table?

#2

Well, you can create a temporary table, copy the data to change into that, present the temporary table and after hitting the button to save, update the live table by the temporary table. If you use MYSQL you can look at the CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name …