Home: Perl Programming Help: DBI:
model for a log in log out database


Feb 24, 2011, 8:22 AM

Views: 4776
model for a log in log out database

Does any body have a good model for a session log database table?

I need to keep track of sign in and sign off and time spend information of users who access my web application.

I was figuring on keeping the information in a table that records their datetime stamp and extrapolates their time spent then write that info to a log file but keep only the last log in time on the database.

I would like to see some suggestions for the db layout.

I appreciate any suggestions.