database logic for tracking each and every operation in my web application
- by ripa
I am developing an Web application. In my application, I need to keep track of each and every operation for every logged in user.
I have planned following for achieving this task:-
I will create stored procedure in mysql.
I will trigger this procedure on each table's insert , update
delete.
This is an tough job for me. Will anybody direct me in the right way?
I am using PHP based Codeigniter framework and mysql database.