tracking user activity on database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Zooter
Forum Commoner
Posts: 45
Joined: Tue May 18, 2004 10:46 am
Location: South Africa

tracking user activity on database

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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..
Post Reply