close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Store and Update The Number of Times Registered Users Login to access contents.

Thread began 7/10/2012 9:34 pm by Mysite07430650 | Last modified 7/17/2012 3:10 pm by Mysite07430650 | 1580 views | 10 replies

Mysite07430650

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.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...