How can PHP be used to save elapsed time data in MySQL when a page is closed and retrieve it when the page is reopened?

To save elapsed time data in MySQL when a page is closed and retrieve it when the page is reopened, you can use PHP to store the timestamp when the page is closed in a database table. When the page is reopened, you can retrieve this timestamp and calculate the elapsed time since the page was closed. 

// Save elapsed time data in MySQL when page is closed
// Assuming you have a MySQL database connection established

// Get current timestamp when page is closed
$timestamp = time();

// Insert timestamp into a database table
$query = "INSERT INTO elapsed_time (timestamp) VALUES ($timestamp)";
mysqli_query($connection, $query);

// Retrieve elapsed time data when page is reopened
// Get the timestamp stored in the database
$query = "SELECT timestamp FROM elapsed_time ORDER BY id DESC LIMIT 1";
$result = mysqli_query($connection, $query);
$row = mysqli_fetch_assoc($result);

// Calculate elapsed time since page was closed
$elapsed_time = time() - $row['timestamp'];
echo "Elapsed time: " . $elapsed_time . " seconds";

Keywords

PHP MySQL session variables data persistence page lifecycle

Related Questions