Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE table_data (
id INT,
spinTimeTotal INT,
spinAngleStart INT,
last_updated DATETIME
);
<?php
//
$stmt = $pdo->query("
SELECT *
FROM table_data
WHERE last_updated < now() - interval 25 second
");
$row = $stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($row);
if (empty($row)) {
$row['spinTimeTotal'] = rand(3999.000000000, 4001.000000000);
$row['spinAngleStart'] = rand(17.000000000, 20.000000000);
$stmt = $pdo->prepare("
UPDATE table_data
SET spinTimeTotal = ?,
spinAngleStart = ?,
last_updated = NOW()
WHERE id = 1
");
$stmt->execute([$row['spinTimeTotal'], $row['spinAngleStart']]);
}
print_r($row);