After 30 seconds, update MYSQL databse

Posted by Sam on Stack Overflow See other posts from Stack Overflow or by Sam
Published on 2010-06-14T10:20:12Z Indexed on 2010/06/14 10:22 UTC
Read the original article Hit count: 153

Filed under:
|
|
|

Hello everyone! I've been looking around here on SO and Googling, however I can't find anything that fits my description.

What I want to do is update the database if the page has not been refreshed after 30 seconds. I want to email a person with the contents of a form {submitted by a different user} (I can do that) IF the person has NOT visited the page (I can do that) within the last 30 seconds.

What I've tried to do is make the page that should be visited refresh every 30 seconds, and so I figured if I did something like after 31 seconds, edit the database (so if the refreshed page was not refreshed, the database editing would run).

I'm sorry if this sounds complicated, there's probably a better way to do this, but I'm not sure how.

The bigger picture is I'm trying to make a 'on-duty' sort of thing, so that if the person is not actively looking at the page, they will get emailed with whatever the contents of the form is. The page will contain a table of all the entered form results.

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql