Store and Update The Number of Times Registered Users Login to access contents.
Hello everyone,
I think what am after is possible but I need help with the various steps involved. I have SecurityAssist created registration pages which includes, Login, Logout, Registration, ForgottenPaswword and Userupdate pages. I know what I need to do requires me to add session variables via SecurityAssist Authenticate User dialogue box, but I need help with the coding and steps required as previously mentioned.
Is there a way to record, store and update the amount of times and (last time or date) a user logs in to access contents in their home or profile page?
What I need is best illustrated with an example: User A logs in to access content on his home or profile page 6 times a day, while User B logs in to access content on her home or profile page perhaps 2 time a day. The Same applied to User C, User D, etc,
Would I need to create two columns in the datebase User table, say Column 1 = UserLoginCount, and Column 2 = UserLoggedinLast.
Where Column 1 = UserLoginCount stores integer values that is incremented as the user logs in and Column 2 = UserLoggedinLast stores the dates the user last logged. In that scenario, day 1 the user logs in 6 times and revisits on day 2 and logs in 3 times. The user table should show the user has logged in on those many times on the respective days.
Then I want to be able to display the data in a recordset, showing the number of times users are logged in to access contents on their home or profile page, and corresponding date when they last logged in.
I searched the forum and am mindful that it can be done, but I cannot find anything concrete on the steps required to make it happen.
I appreciate any help that points me in the right direction.
Thank you in advance.