Store login information in DB
Posted on 2007-03-26
Hi, is there a way that i can capture the username, time, date, and Client IP of someone logging on to a secure page on my site - with no end-user input? Currently, i am using:
<cfset clientIP = cgi.REMOTE_ADDR>
<cfoutput>Client IP Address: #CGI.REMOTE_ADDR#</cfoutput>
...using this code i can display the information to the user, but what i really want to do is capture every login in the database, automatically...So, the end-user logs in, sees what i have up there, and logs out. without any input from the end- user, i would like to get an "idea" of who logged on, when, etc. and the information would be stored automatically. I have added a table in MS Access, relative to my other tables, to store the info.