Updating Database on Browser Exit Close..

[eluser]ginteno[/eluser]
Hi,

I want to update my member log status.. from online to offline everytime the browser is being close or shutdown.
how do i do it???

I want to call this function everytime the browser is being closed..

public function set_status($status){
$data = array('status' => $status);
$this->db->where('username', $this->session->userdata('username'));
$this->db->update('members',$data);
}

any help will be appreciated..

[eluser]jonez[/eluser]
You can't, not all browsers support onunload AJAX calls. Another way to show status is to track actions, each time a user performs an action stamp it in a tracking DB. Check for stamps within the last 5m to see who was online recently.

[eluser]ginteno[/eluser]
Wow this is a huge help.. thank you so much...

[eluser]ginteno[/eluser]
about the last_activity... correct me if im wrong, i was thinking of this formula to know who were recently online..

it's

if ( Time_Now > Last_activity_time + 5min ){
echo "Offline";
}
else{
echo "Online";
}

if this is right.. can you tell me what's the codeigniter syntax for the condition above..
Thank you!..