Thanks Daniel, this is a good solution, I will implement it and get it working! Cheers Angelo -----Original Message----- From: Daniel Brown [mailto:parasane@xxxxxxxxx] Sent: 05 March 2008 20:37 To: Angelo Zanetti Cc: php-general@xxxxxxxxxxxxx Subject: Re: Logging session timeout in DB On Wed, Mar 5, 2008 at 3:08 AM, Angelo Zanetti <angelo@xxxxxxxxxxxxxxx> wrote: [snip!] > No what I would like to know is how can I record when a user closes the > browser or the session expires? There is no action for these items. So what > would the best way be to keep a record of this? Would the use of a cron job > be appropriate? I read in the archives that the banks use javascript but I > don't want to go that route. One way that comes to mind right off the bat would be to utilize an idea similar to the following. You'll need to secure it and tailor it to your own needs, but it should point you in the right direction. <? // Place this function in a file that's included // in all pages for users that are logged in. // The field last_seen is INT(10) function updateLoginTable($uid) { $sql = "UPDATE yourTable SET last_seen='".time()."' WHERE uid='".$uid."' LIMIT 1"; mysql_query($sql); } ?> <? // This will be your cron job. // Include your database config here. // The field is_active is BOOL $secs = 600; // Number of seconds to wait before considering logged out $diff_secs = (time() - $secs); $sql = "UPDATE yourTable SET is_active='0' WHERE last_seen > '".$diff_secs."'"; mysql_query($sql); ?> Then, add this to your crontab: */1 * * * * `which php` /path/to/cron/script.php It will run every minute, making users who have not accessed a page within the previous 10 minutes inactive. It's untested, but hopefully it will point you in the right direction anyway. -- </Dan> Daniel P. Brown Senior Unix Geek <? while(1) { $me = $mind--; sleep(86400); } ?> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
