I have a
$dbSessionDuration variable where by using mysqli, it is able to bind the result of data from the query into this variable. The
$dbSessionDuration variable holds time so the variable has a time format as below:
Now that means 1 hour 30 mins and 10 seconds. What I want to do is display
$dbSessionDuration value in a timer so that in above’s example it will start ticking down from 01:30:10 and go all the way to 0 when it stops. My question is how do you create timer and place whatever value
$dbSessionDuration value in the timer to count down to 00:00:00?
First of all, you have to convert your time in seconds.
<?php list($hour,$min,$sec) = explode(':', $dbSessionDuration); $dbSessionDurationTime = mktime(0,0,0,$hour,$min,$sec); ?>
I didn’t test, but that should work!