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.
Who is Participating?
Ray PaseurCommented:
You might be able to adapt this design.

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
You could modify mod_auth_mysql to log anything you need.
kiwistagAuthor Commented:
Thanks, I'll look at these & see how I go :)
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.