使用php和mysql，在用户注销时插入时间戳

Question

Using PHP and MySQL

When a user logs in I am able to insert their log-in time-stamp into MySQL while using sessions and with the use of a function. The function would update the database and works wonderfully.

Now, is it possible to get a time-stamp and have it recorded into MySQL the same way when the user clicks on "log-out" and where the log-out will run session_destroy()?

All I am looking for is a time stamp of when the user clicks on log-out, just so I know they have been log-out. I not worried if they just closed the browser and walked away.

I have tried doing something like session_destroy(something); and using this as function. All I got was run-time errors. Is this something that is even possible to do?

Answer 1

You should have no problem recording a logout time when a user clicks logout (of course this won't work if the browser is closed). Just get the UserID and update that user in the database before calling session_destroy().

For example:

Logout.php

$query = "update user set logoutDate=CURRENT_TIMESTAMP where user={$_SESSION['userID']}";
mysql_query($query);

session_destroy();