当计时器到达零时执行查询

Question

The idea is pretty simple:

Where the timer is made in Javascript, when it reaches zero it performs a query in PHP that alters the database value to add 1.

The problem is that the timer in question must not be reset with page refresh, just like any browser based game, when you build a new facility.

This is for a school game project, in which you click "Build" and depending on that facility's level it would take X time to upgrade it to a new level, showing a timer that tells the user how much time left until the upgrade is done.

I'm really sorry if the solution is somewhere here, but I swear to god I've searched everywhere but I could not get a decent methodology to do this.

Answer 1

Do not rely on frontend script to do this, instead schedule a task in the backend. some ways to do it. If the load and users are less, and timer value is not very high. Put Sleep(10) ( for 10 seconds ) in your script.and call it through your javascript, it will execute the query after 10 seconds :) . And will work even if the browser is closed or page is refrehsed

Php script :

<?php

  $timer = $_REQUEST['timer'];
  $timer = intval($timer);
   sleep($timer); // sleep for some seconds
   ....rest of the stuff..

 ?>

However for heavy use, and large intervals like 15 minutes etc, you can immediately store some information and triggering time in a database, and later on process them with a cron ( scheduled task ) in the backend