Hello everyone.
I have a php webpage, where there are textforms, dropdown lists and stuff. There is Activity field in the database. Whatever activities that i do on the webpage, like modifying the text in the textbox, or changing a value for a dropdown list, these need to be automatically entered into the activity text in the database. Like this it happens only for one page. Only the form elements that have been modified should be entered into the activity field of the database, so that the user viewing it will know what recent activity has taken place on that project. Data should be appended (not replaced) into the activity field.
Like for example, if i change a project name field and change status to 'Important' from 'Normal', then it needs to make an entry into the Activity field like:
On 'yyyy/mm/dd' Project name has been changed to 'New Project' and status has been changed to 'Important'.
I think this can be achieved with stored procedures or i might be wrong.
I would really appreciate if someone could write down a sample code or help me in making this possible.