[PHP] Log transaction for audit

2004-08-05 Thread CHAN YICK WAI
Hi, I'm writing an application that requires log every transactions users done, e.g. update which record, delete which record, something like that. I guess one way is whenever I issue a mysql_query(), I also insert this query in whole into another table together with the user name, so I can log

Re: [PHP] Log transaction for audit

2004-08-05 Thread John W. Holmes
From: CHAN YICK WAI [EMAIL PROTECTED] I'm writing an application that requires log every transactions users done, e.g. update which record, delete which record, something like that. I guess one way is whenever I issue a mysql_query(), I also insert this query in whole into another table

Re: [PHP] Log transaction for audit

2004-08-05 Thread Jason Wong
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

Re: [PHP] Log transaction for audit

2004-08-05 Thread John W. Holmes
From: Jason Wong [EMAIL PROTECTED] 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