Re: Log transaction for audit
| From: | John W. Holmes | Date: | Thu, 05 Aug 2004 18:06:44 +0000 |
| Subject: | Re: Log transaction for audit | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-192921@lists.php.net to get a copy of this message | ||
From: "Jason Wong" <php-general@gremlins.biz>
> On Friday 06 August 2004 01:47, John W. Holmes wrote:
>
> > Sounds like you just need to write a wrapper for mysql_query() that logs
> > what's going on.
> >
> > function my_mysql_query($query)
> > {
> > log_query($query);
> > return mysql_query($query);
> > }
> >
> > and use my_mysql_query() everywhere instead of mysql_query.
>
> If that is indeed what is required just simply use MySQL's own logging
system.
> Only feasible if you have control of the MySQL server, MySQL manual for
> details.
True. http://dev.mysql.com/doc/mysql/en/Binary_log.html
I assume there's probably some application level information that'd need to
be logged also, that probably isn't contained in the query.
---John Holmes...