We have a PHP/MySQL application and I want to setup a logging mechanism to log all financial related actions into this table.
I was thinking of a simple file based mechanism, but due to the risk of two instances conflicting with each other, I suppose a database based mechanism would be better.
Can anyone recommend a class / toolkit that can encapsulates simple logging mechanisms, but with a database backend?
I'm guessing that you want to log changes to data which is stored in a database.
Why not just use the DBMS audit tracking facilities?
(with mysql, just set up a dummy slave to consume the replication logs).
Try Log4PHP, it's quite flexible and support a wide range of storages for the log!