Login Date and Time Stamps

Hello All,
I need help to include in my profile page the time stamp the user last visited (Logged in), for example (You last visited: Wednesday 23, 2009 at 07:54 AM )and I also want the time stamps be registered into the my database. That is each time a user login, the date and time is registered in the database. Any help will be appreciated.
Thanks in advance

Create a LastLogin table in your database with a date/time field, and then apply the DataAssist Insert server behavior on your login page. You would leave the success redirect blank in your login server behavior and use the redirect after insert to redirect to the profile page or whatever page you go to after login.

Insert the value: <?php echo(date("Y-m-d h:i:s")); ?> to get the current time inserted into that field and also insert the userID for the logged in user from the session.

You can then create a recordset from that table to show the last login by using: ORDER BY LoginDate DESC LIMIT 1

Similar situation. I have a "lastchanged" field in my db table. When updating via DataAssisst, after I inserted a hidden field


<input id="HiddenFields_fields" name="HiddenFields_fields" type="hidden" value="<?php echo date("Y-m-d h:m:s"); ?> " />

it works great.

In my Security Assist update page, I can't get it to work.

Missing some concept.

Thanks much.

send a copy of your page so i can examine the code.

original and 2 different tests. Thanks much. This is the same project that had a ticket on it yesterday, so if you need ftp access, it's noted in that ticket...

thanks

userupdateTEST2.php is a renamed DA updater page... I was hoping that would work, but I couldn't get the redirect to go to logout

trying again on attachment

the pages have the forms action hard coded:
<form action="../directory2/directory_Update.php?ID=<?php echo(rawurlencode($row_WADAdirectory['ID'])); ?>" method="post" name="WADAUpdateForm" id="WADAUpdateForm">


so if you rename the page, you will also need to modify the forms action so that it will go to that page. Right now, you have the userupdateTEST2.php posting the information to the directory_Update.php page.

Thank you so much!

I understand what you explained. However, that was a test to see if I could get a data assist page to replace the security assist page. I tried this because I was able to get the DA page to accept a time date change but was unsuccessful with my userupdate.php in Security Assist.

So I'm back to square one. What do I do, within the SA page, userupdate.php to update the database for time date stamp.

Thanks for the patience.

You can click on the the update database server behavior on the user update page and set the field value to the current timestamp using php:

<?php echo(date('Y-m-d h:n:s')); ?>