PHPize Online / SQLize Online  /  SQLtest Online

<?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, 4001); $row['spinAngleStart'] = rand(17, 20); $stmt = $pdo->prepare(" UPDATE table_data SET spinTimeTotal = ?, spinAngleStart = ?, last_updated = NOW() WHERE id = 1 "); $stmt->execute([$row['spinTimeTotal'], $row['spinAngleStart']]); } print_r($row);