[SOLVED] How easy is it to log changes to data made by a user, and display in php?

[littlevisuals]

Hi all 

 

I have a question if you may, im currently building a simple cms.  There will be an admin and a few users, but I would like there to be a section where it displays logs/changes to the database.

I have looked through google and bing for an answer and the only way I can think of is inserting datestamps in all my tables but no idea for users? :-\

 

Is there a log built into mysql which I could call? If not whats my best option?  ???

Thanks in advance!

[littlevisuals]

TLDR;     

 

Best way to log user actions (what stuff they change/amend etc)

[PFMaBiSmAd]

The mysql query log (when it is enabled) only shows the queries and the client username that was used in the connection to the database server. The database has no idea what actual user on your site is causing anything to happen.

 

You will need to add code in your application to log the information you want. You can either log to a file error_log or log information to a database table.

[littlevisuals]

Thanks PFMaBiSmAd!