PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE table_data ( id INT, spinTimeTotal INT, spinAngleStart INT, last_updated DATETIME );
Copy Clear
Copy Format Clear
<?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);
Show:  
Copy Clear