Apache Transaction Logs

[Thorby68]

I have all but completed my design for an application in PHP and MySQL using apache as my web server. However, I was wondering whether apache supported transaction logging which would save me creating code with numerous database calls to log all activity myself.

I appreciate I may have to create some sort of reporting if I want to get at specific transaction data like "user created by XXX on YYYY", or "record XXX edited by AAA on YYY, but, to get apache to collate all production transactions in the first place would remove what could become a headache.

If anyone could point me in the right direction, it would be appreciated

[pritaeas]

http://dev.mysql.com/doc/refman/5.6/en/query-log.html

[Thorby68]

http://dev.mysql.com/doc/refman/5.6/en/query-log.html

Many thanks, this will save me hours and hours