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 | 1578 views | 10 replies

Mysite07430650

Originally Said By: Jason Byrnes
  you will need to add the count and logged in date columns to the users table.

edit the Authenticate user behavior on the login page so that it does not redirect. Make not of the name of the session that is created whith the users ID

create a recordset to lookup the users record in the the database, see the recordset on the profile page for details

add a Update record behavior to update the users table. for the Key Column value, use the users ID session variable.

For the login count, use the login count binding from the recordset. the binding code will look like:
<?php echo($_row_recordsetName['LoginCount']) ?>

add + 1 to that:
<?php echo($_row_recordsetName['LoginCount'] + 1) ?>

fro the login date, use the following code:
<?php echo(date(Y-m-d h:m:s)); ?>  



Hello Jason,

Thanks for responding to my thread. I just wanted to clarify few things regarding the solution you've provided.

I have created LoginCount and LoginDate columns in the User table. The LoginCount is set to INT and the LoginDate is set to DateTime respectively in the user table. I hope this is correct.

Do I need to define session values on the home page of the user as in WA Set Session Value (LoginCount) and WA Set Session Value (LoginDate), to be used in conjuction with the recordset?

I have also removed the unchecked the redirect function in both SecurityAssist Authenticate User dialogue box, and have also added the both created column names to the Session Values list.

Does LoginCount and LoginDate need to have initial default values either in the user table or server binding?

I have created a recordset for the homepage of the table users. Is that correct or am I supposed to create the recordset in the Login page?

Will I need to add the update record behaviour in the Login page or the Home page of the users?

Lastly, would these codes:

<?php echo($_row_recordsetName['LoginCount']) ?>

add + 1 to that:
<?php echo($_row_recordsetName['LoginCount'] + 1) ?>

fro the login date, use the following code:
<?php echo(date(Y-m-d h:m:s)); ?>[/QUOTE]

be added to update single record General Tab or Bindings?

Thanks for your help. Appreciated.

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...