How to create a timer

Question

Using mysqli the $dbSessionDuration variable can 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:

01:30:10

I want to display $dbSessionDuration value in a timer so that in the above's example it will start ticking down from 01:30:10 and go all the way to 0 when it stops.  Can someone tell me how I can create a timer and place whatever value $dbSessionDuration value in the timer to count down to 00:00:00?

Answer 1

What you have to do is, convert your time into seconds.

<?php

list($hour,$min,$sec) = explode(':', $dbSessionDuration);
$dbSessionDurationTime = mktime(0,0,0,$hour,$min,$sec);

?>

To create a countdown, use Javascript.

<script type="text/javascript">
    var millis = <?php echo $dbSessionDurationTime; ?>

    function displaytimer(){
        var hours = Math.floor(millis / 36e5),
            mins = Math.floor((millis % 36e5) / 6e4),
            secs = Math.floor((millis % 6e4) / 1000);
            //Here, the DOM that the timer will appear using jQuery
            $('.count').html(hours+':'+mins+':'+secs);  
    }

    setInterval(function(){
        millis -= 1000;
        displaytimer();
    }, 1000);

</script>

I hope this helps you.