Designing action logging system

[Pests]

I'm trying to find a way to design a system which logs users actions on and around the site. Right now I'm trying to log just three things, but this could expand: registration, login, and submitting the one form on the site. With all of them I'm recording ip, user id, and time. Now where I'm stuck at is that I need to log what the user submits with the form. I originally created a column in the datbase called 'extra' and just stored a serialized array of the form data there. I realize now this won't work as I later need to work with this logged form data (selecting all users who put in certain data for example).

The code to log the user signing up, for example:

$log->action(array('action' => ACT_SIGNUP,
                   'user_id' => $db->lastInsertId()
                  )
            );

Thanks!

[mrhappiness]

you could set up a 2nd table with 3 columns

log_id = foreign key, referencing the corresponidng entry in your log table
key
value

you could use [man]foreach[/man] to get key and value of $PST, $GET, whatever

btw:
if you log a login and store the form data you store the password of the user?
i'm quite sure i don't like that...

[Pests]

No, only certain forms are logged. Signup and Login for example just saves: user_id, ip, and time.

[mrhappiness]

you should provide the data to be saved to the log-method of $log in this case