How can PHP be used to create a countdown timer that retrieves data from a database?

To create a countdown timer in PHP that retrieves data from a database, you can store the target end time in the database along with the current time. Then, calculate the remaining time by subtracting the current time from the target end time. Finally, display the countdown timer on the webpage using JavaScript to update the timer dynamically. 

<?php
// Connect to your database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";
$conn = new mysqli($servername, $username, $password, $dbname);

// Get the target end time from the database
$sql = "SELECT end_time FROM countdown_timer";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$end_time = strtotime($row['end_time']);

// Calculate remaining time
$current_time = time();
$remaining_time = $end_time - $current_time;

// Display the countdown timer
echo "<div id='countdown'></div>";
echo "<script>
var countdown = $remaining_time;
var timer = setInterval(function() {
  countdown--;
  document.getElementById('countdown').innerHTML = countdown + ' seconds remaining';
  if (countdown <= 0) {
    clearInterval(timer);
    document.getElementById('countdown').innerHTML = 'Countdown expired';
  }
}, 1000);
</script>";
?>

Keywords

PHP countdown timer database data retrieval programming

Related Questions