You are here: Re: Dropping Temporary Tables « PHP Language « IT news, forums, messages
Re: Dropping Temporary Tables

Posted by max on 07/22/07 02:44

Hi Rik,

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 help.

Max

vic a écrit :
>
> "Rik" <luiheidsgoeroe@hotmail.com> wrote in message
> news:op.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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация