[SOLVED] Updating database on browser close.

[GB_001]

How would I be able to update database when the browser closes?

 

-Thankyou, GB.

[rhodesa]

There really is no reliable way to do this. You could use the onunload event to execute some AJAX which will let your server know. But again, it's not reliable. What are you trying to accomplish with this?

[GB_001]

I trying to accomplish whether a user can check a list of users that our online.

 

[rhodesa]

The best way to accomplish that is to have a field in your users table like 'last_active'. And then every time the user does something on your site, update that field with the current time. To get 'online' users, just select the ones where last_active is less then 10 minutes old.

[Northern Flame]

it would be easier to do something like this

 

<?php
$id = $_SESSION['id'];
mysql_query("UPDATE users SET last_active=NOW() WHERE id='$id'");

$wq = mysql_query("SELECT username FROM users WHERE last_active > (NOW() - INTERVAL 5 MINUTE)");

while($row = mysql_fetch_array($wq)){
echo $row['username'] . "<br>\n";
}

?>

[GB_001]

Thankyou, so I just create a timestamp?

 

Do I make it current time?