Page 1 of 1

Tracking Users

Posted: Wed Sep 22, 2004 5:12 am
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...?

Posted: Wed Sep 22, 2004 5:32 am
by timvw
Article i thought was interesting:

http://www.tonymarston.net/php-mysql/auditlog.html

Posted: Wed Sep 22, 2004 5:42 am
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...?