Tracking Users

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
Harlequin
Forum Commoner
Posts: 51
Joined: Tue Sep 21, 2004 10:51 am
Location: UK

Tracking Users

Post by Harlequin »

Morning all.

I've decided that it's about time I started tracking my users activities and have made a start by creating a table that registers when a user has logged in.

I'd like also to register which pages they have visited and maybe even how long their session lasted.

Before I start on this though I was wondering if anyone else had done the same thing and what sort of information they capture...?
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

Article i thought was interesting:

http://www.tonymarston.net/php-mysql/auditlog.html
Harlequin
Forum Commoner
Posts: 51
Joined: Tue Sep 21, 2004 10:51 am
Location: UK

Post by Harlequin »

Good article.

I'm thinking of creating a load of session variables and then stuffing them into a seperate table as I already have one table that tells me when they actually logged in, I could easily create a random code, MD5 I think the command is, and use that as the local key and the foregn key to link the two tables maybe...?
Post Reply