Logging Updates?

[brianb]

Hello,

I'm trying to come up with a solution for logging updates made to my site. Any ideas about this matter are appreciated...

Say I have a form which updates an entry in my database. This form contains 20 fields. An admin goes in to edit an entry and updates 2 of the 20 fields...

What is, if any, the easiest way to track that this admin made an adjustment to the 2 fields?

Any ideas are appreciated!

Thanks in advance.

[bike5]

Make hidden fields on the edit form for each thing that can be changed, with the same values as what was pulled from the database.

When an admin submits the script to be updated,

if($_POST['original_value'] != $_POST['new_value'])
{
insert into database the admins name, the feild they changed, and the date and time they changed it.
}

you would have to repeat that 20 times changing the names within the if the match the names on the form. Or make 2 arrays with 20 of the names and use a for loop 20 times to load
if($POST[$array1[$x]] != $POST[$array2[$x]])

Then you can search who did what by pulling the admins name, the date/time, or feild that was changed. I hope that made any sense.

[furious5]

I looked in to something similar a while ago, as you may know MySQL does not support logging.

However if I remember rightly PostgreSQL does support logging.

It might be worth looking to export your tables and structure over to PostgreSQL.

Again it will depend on how detailed the logging is that you require.