Simple php countdown timer starting from sql time

[roger01]

Hello

 

I currently have this code:

$timeBetweenClaims = 1800;
$timeQuery = mysqli_query($conn, "SELECT * FROM users WHERE addy = '$userAddy'");
$timeResult = mysqli_fetch_assoc($timeQuery);
$timeDif = $time - $timeResult['time'];
$timeLeft = gmdate("i:s", $timeBetweenClaims - $timeDif);
if($timeDif < $timeBetweenClaims){
   $message = "Wait 30 minutes before posting. Timeleft: $timeLeft";
   }

how to make $timeLeft auto countdown til 0 so users don't have to refresh the page every few minutes to see the progress on timeleft?

 

thank you!

[PravinS]

Try AJAX

[Jacques1]

I don't know how Ajax is going to help with this, but JavaScript can create timers. After the page has been loaded, you start with $timeLeft, count down the seconds and display the remaining time somewhere on the page.

 

There are thousands of examples and working implementations, just google for it.