[Resolved] timeout inside database

[kerodeon]

In MySQL, is it possible to attach a timeout to a field, so after a certain time the data in the field changes?

And if that is possible, are you able to add a timeout, and take out a timeout with PHP.

For example, if i had a table named users, and a field named doingsomething, set to yes. I would like a timeout added so after 15 minutes doingsomething could be set to no.

[bastien]

No, MySQL does not support stored procedure, jobs or triggers as yet...

You can do this thru PHP with a file as CRON job (or scheduled task in windows) where you write the script to make the changes and then set the event to fire at certain times.

The other option is to add the script to a file that is called frequently and use that to fire the changes. This will not cover all users but should be okay for the large majority

[kerodeon]

if you cant run a timeout in a database, can you run the functions you mentioned seperate of a client window?

to make clear what i mean, if a user closes a window, can i call a php page to run a function, without a window for that php file appearing?

[bastien]

sure, you can try to use the onUnload function in javascript to call the script. If the script contains no html then there is no need for a client window.

It might be best to call this script before you load another page and use the header function to redirect the user from the db script to the client script...

[kerodeon]

thanks this seems to solve my problem. I especially like this sentence

If the script contains no html then there is no need for a client window.

lol