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.
