Hi All,
I am working one project where i want to create report of users. In the report i want to show Username only one time in next column his last five login attempt.
Will anybody help me out to build logic for it. For example
username1 : 12 Jan '12 , 10 Jan '12, 14 Dec '11, 10 Dec '11, 10 Nov '12
username2 : 12 Jan '12 , 10 Jan '12, 14 Dec '11, 10 Dec '11, 10 Nov '12
Regards,
beji
Well, in most cases, you would keep only so many login records. Let say 10.
These, of course, would be stored in your database. In this manor, you would just
have to use a query to get your records. Like $query=“Select UserNames, LoginDates from Users where blah blah blah order by LoginDates”, or something. This would give you a recordset with your user names and the last 10 logins. Then, you can print the data with just a few lines of code. Some sites keep every single login record in a table that keeps all data such as Username,password-tried,date,time, Ip address and any other info that might be needed. Overkill, I think, except for high-security site or special needs.
Not sure if that is what you wanted. Hope it helps…