Page 1 of 1

tracking user activity on database

Posted: Tue Jul 06, 2004 6:36 am
by Zooter
Hi,

I'm busy with an internal CMS system for a friend of mine. They want to be able to see precisely what a logged in user is doing in terms of database activity. Did he insert something, or did a select, etc.

How do I do that? They are also working from different pc's. First of all I'm using Apache 2.0.47, PHP 4.3.7 and mySQL 4.1 on a Windows XP machine. I tried to find out how to make sessions work on Apache (set timeout period, and directory to store session files), but couldn't find anything that helped me. Then also I don't know how to link the user after logging in to the site, connect to the db automatically.

I'm working in Dreamweaver MX as well...

Can anyone please help me?

Posted: Tue Jul 06, 2004 9:48 am
by feyd
I'd build a journalling log system. You could use it to track all activity on the site, or whatever you like. Basically, you'd call it with where you are calling from, and how you got there..