Update MySQL Database When Session Ends

[RTS]

Is there a way to have a database automatically be updated when the session times out?

[MCP]

yes, but you'll have to write your own session handling functions for all session related options. See
http://ca.php.net/manual/en/function.session-set-save-handler.php

There's even an example there for file-based sessions which you might want to extend. You'll want to put your database update in the _close and/or _gc functions.

[RTS]

well, I realized there is a problem with doing that on my site, so I have another question. Is there a way to update the database when a user leaves the site? that would work better.

[Hi I Am Timbo]

not without javascript.  The only action is when a php script is called.

[RTS]

hmmmmm... could someone explain how to do what was suggested first? the tutorial confused me, and I didnt get what I was supposed to do...

[Hi I Am Timbo]

I've never done this before, but it looks like you define functions with the same names as these:

session_set_save_handler("open", "close", "read", "write", "destroy", "gc");

Then when named action occurs, it runs that function.  You would have to include this file on all of your pages, likely before you do session_start();