MySQL / htaccess authentication with login timestamping

Currently our site runs MySQL autentication to get in. This is via htaccess/MySQL auth. (LAMP based system).

I'm trying to think of a way to timestamp a successful login onto the site. Mainly via logging the successful authentication time into the login Table.

Any ideas on how to approach this would be appreciated.
LVL 6
kiwistagAsked:
Who is Participating?
 
Ray PaseurCommented:
You might be able to adapt this design.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_2391-PHP-login-logout-and-easy-access-control.html

The adaptation would write the client identity and the DATETIME values into a log table.  This would happen in the registration script near line 33 and in the login script near line 26.

HTH, ~Ray
0
 
shalomcCTOCommented:
You could modify mod_auth_mysql to log anything you need.
0
 
kiwistagAuthor Commented:
Thanks, I'll look at these & see how I go :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.