Skip to content
PHP Logo

How can a countdown be implemented in a PHP script using a database?

To implement a countdown in a PHP script using a database, you can store the target end time in the database and then calculate the remaining time by subtracting the current time from the target end time. You can then display the countdown on your webpage using JavaScript to update the countdown in real-time.

php 
<?php
// Connect to your database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "yourDB";

$conn = new mysqli($servername, $username, $password, $dbname);

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

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

// Display the countdown
echo "Countdown: " . gmdate("H:i:s", $remaining_time);
?>

Related questions