Hi! Could we please enable some services and cookies to improve your experience and our website?

PHPize Online / SQLize Online  /  SQLtest Online

A A A
Login    Share code      Blog   FAQ

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Copy Format Clear
CREATE TABLE sportusers ( id INT AUTO_INCREMENT PRIMARY KEY, phone VARCHAR(100), userdate DATETIME DEFAULT CURRENT_TIMESTAMP ); INSERT INTO sportusers (userdate, phone) VALUES (NOW(), '123456'); SELECT * FROM sportusers;

Stuck with a problem? Got Error? Ask AI support!

Copy Clear
Copy Format Clear
<?php $phone = '1234567'; $sql = "INSERT INTO sportusers (userdate, phone) SELECT NOW(), :userphone WHERE NOT EXISTS ( SELECT 1 FROM sportusers s2 WHERE s2.phone = :userphone AND userdate > date_sub(now(), interval 12 HOUR) )"; $stmt = $pdo->prepare($sql); $res = $stmt->execute([':userphone' => $phone]); if($stmt->rowCount() > 0 ){ echo "Запись сделана"; } else { echo "Try later"; }
Copy Clear