I would like to be able to log all user actions, such as when they create a new item, view any item, update an item etc.
I would like to know where I would be able to add the necessary code to do this?
I would like to be able to log the username (from my login framework), the action performed (create, view, update or delete), as well as some basic identifying information about the item. This can include the id of the object, as well as the table in which the object is/was stored.
I will add some PHP code to store the log details to another table in the database.
Any help would be appreciated.