Session cleanup

timus

Hi All

Is there a way to call a function when a session is closed?

Basically I'm creating a table for each user that logs onto the website, based on their session_id() it may contain over 500 rows of data so when the user closes the browser, I'd like the table to be removed so I dont end up with lots and lots of dud tables.

I can't use temporary tables as they need to be accessible from one page to the next and temp tables are dropped after the connection is closed.

I didn't want to write a whole set of functions for session_set_save_handler, could i just write a function for the $gc? is this garbage collection? Is this called when the session_start() is called?

Any info would be greatly appreciated.

Thanks

Tim

devinemke

any particular reason that you are cresting a whole new table for each login? why not just store the temp data in the session array?

timus

Hey thanks for the reply

The table stores search results, which includes a rank for each result that is calculated as the result are found. The first time the query runs it takes a few seconds but I'll only show 10 or 20 of those records to the user at a time.

It seemed to make more sense to save the results in a table, then I can sort them more easily and link this search results table to other tables in order to fetch other details.

Originally I'd hoped to use temporary tables but they get cleared at the end of each script when the db connection is dropped.

There may be anything up to 1000 records in this table and I thought a database would be a better place to store it than the session file

Any other suggestions would be gratfully received

Thanks

Tim

HalfaBee

PHP doesn't know when the session is ended.

You need to run a garbage service every hour or so (maybe every page load)
that removes tables that are over a certain period old.

timus

I think your probably right, just wondered is there was a better way.

There is a garbage collection with is called on the session_start() but to use that I'd have to create all the functions to handle sessions and that seems like overkill

Thanks for the suggestion

Tim

middleman666

Hey,

I'm not sure if this helps, but a banking site I use - If the user closes the browser then they have a onExit (i think) that loads a mini window that then ends my session with them.

Pretty sure its JavaScript.