UPDATE after a time delay

[stephend330]

hi im not sure if this is a MySQL, PHP or other problem what im trying to achive is

 

user clicks button ->  after a time delay of days or hours -> update database with new data

 

im trying to build a leveling up system

 

thanks

[shlumph]

Perhaps updating the database right away, and then caching the results for the user for a certain period of time would be a solution.

 

Otherwise you'd probably have to store everything in a temporary directory, and then set up a cron job to scan the folder and make the DB updates.

[stephend330]

do you know of any tutorial i could refur to complete this task

[Spring]

Perhaps updating the database right away, and then caching the results for the user for a certain period of time would be a solution.

 

Otherwise you'd probably have to store everything in a temporary directory, and then set up a cron job to scan the folder and make the DB updates.

 

I have the same question, but I was pretty  sure you could some how use a php time function to do this..or maybe javascript? Is going through all that trouble the only way?

[stephend330]

yer i was thinking of using javascript but do not know if you can

[shlumph]

JavaScript happens on the users machine, and if you want to delay a function call for hours, or even days, chances are the person will close their browser by then

[Spring]

I fixed mine by using sessions.

 

session_start();
session_set_cookie_params(84600);

if(isset($_POST['submit'])){
$_SESSION['clicked'] = 1;
}

 

You should know what to do from here. (: