User stamp implementation

[misslois74]

im working on a system right now which is a product tracking system and one of the requirement is to be able to display the users who made specific transaction it should display the name of the user together with the date and time the transaction was made i was thinking of making use of sessions for these am i in the right track?

 

[feherke]

Hi

As far as I understand you want some kind of logging. When the session will expire the data accumulated in it will become unavailable. And the session data is available only for the one who created the session.

I would say no, you are not on the right track.

Feherke.

http://rootshell.be/~feherke/

 

[misslois74]

so what could be the best way to be able to store the details of the person who logged in to the system to the database and display the information on the system later on...

 

[davejam]

a logging table - using session variables....

all you need to do is add into your code (on all pages you want logging) an update to a logging table saying date time, userid, task (or something along those lines!!!)

and simply whenever you are passing between pages or running updates etc add this into the mix, everything from logging in to logging out and everything in between, can even have your tasks coded with an id that is a lookup to a standard task table!!!

hope this brings the answers to your mind!!!

daveJam

even my shrink says its all your f#@/ing fault