Home / Questions / 371652
Accepted
Pag
Asked: 2020-07-08 05:07:34 +0800 CST 2020-07-08 05:07:34 +0800 CST

Save Previous Value of a Field and Current Value of a Field (Modification History) - Codeingniter PHP [closed]

  • 772

I would like to know if you could give me a hand with a point that I have been stuck for a few days. The thing is that he wants the application which I am improving to have a history of changes, that is, if in the name field there was "Pepe" before and it is changed to "Pepe 2" in a table (which I already have created) I save the person who modified it, the date, time and the Previous Value and Current Value fields

change history table

Every time a change is made in the application in this tab:

enter image description here

The date, username and the person who has been modified and the changes that were made must be saved in this other

enter image description here

The application is developed in php with the Codeigniter Framework, if you have any ideas, it will be well received.

Thank you so much!!!

php

1 Answers

  1. Best Answer

    If you are always going to show the history of datetimes and the history of modifications for "Name" and "Surname" then I recommend you to create a new table with the history of changes and that these changes are stored there, you will only need a FK.

    Every time that General Data is modified, you take its id and add a new row to the history.

    • 1