How can PHP and MySQL be used together to store and retrieve time data for a timer in JavaScript?

To store and retrieve time data for a timer in JavaScript using PHP and MySQL, you can create a database table to store the timer start time. When the timer starts, use PHP to insert the current timestamp into the database. When the timer stops or needs to retrieve the elapsed time, use PHP to query the database for the start time and calculate the elapsed time in seconds. 

// Connect to MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "timer_db";

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

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Insert current timestamp into database when timer starts
$start_time = time();
$sql = "INSERT INTO timer_data (start_time) VALUES ($start_time)";
$conn->query($sql);

// Query database for start time when timer stops
$sql = "SELECT start_time FROM timer_data ORDER BY id DESC LIMIT 1";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $start_time = $row["start_time"];
    
    // Calculate elapsed time in seconds
    $elapsed_time = time() - $start_time;
    
    // Output elapsed time
    echo $elapsed_time;
} else {
    echo "No timer data found";
}

// Close database connection
$conn->close();

Keywords

PHP MySQL time data timer JavaScript

Related Questions