"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
newsp.tvtlajysqnv3q9@metallium...
> On Sat, 21 Jul 2007 15:55:04 +0200, vic <vic at showsec dot <"com>">
> wrote:
>
>> Hello,
>>
>> I'm looking for a technique where I can delete temporary tables that are
>> created during a user's login session. If the user logs out, I can
>> delete the tables in the logout routine. However, users that do not
>> logout have some temporary tables and I'm having to manually delete
>> these from the MySQL database.
>>
>> Can someone suggest a method like a "Session Expires" event where I
>> might handle this cleanup activity?
>
> Define your own session handler with session_set_save_handler()
> (<http://www.php.net/session_set_save_handler>), and run the logic on
> destroying a session and on the garbage collecting of timed out sessions.
> --
> Rik Wasmus

Thanks Rik - I was looking at this but I'm having trouble understanding the
documentation how to implement this!

Vic

> I used to have exactly the same problem. Temporary data was uploaded by
> the user during working sessions. At regular logout, temp. data was
> deleted. But if the user didn't do a regular logout, data was still there.
>
> So I created a CRON job that was running every single day at Midnight. My
> users were working from 8:00am to 5:00pm and weren't any more at job at
> Midnight.
>
> The CRON job was scheduled to delete data and send a short notice to the
> user (next time he was logging in) saying that temporary data had been
> deleted because he didn't logged out properly.
>
> That's the only I found for this "problem".
>
> Hope this .
>
> Max
>

Thanks Max - I don't think this will work because this being a web site I
could end up deleting someone's active session data.

Vic