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 test15 ( number INT PRIMARY KEY, checkbox BOOLEAN DEFAULT 0, date1 DATE, date2 DATE );

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

Copy Clear
Copy Format Clear
<?php $q = mysqli_query("INSERT INTO test15 (number, checkbox, date1, date2) VALUES (11,1,'2024-05-11', '2025-05-16'), (13,0,'2025-05-13', '2025-05-14'), (15,1,'2025-06-11', '2025-06-16'), (17,0,'2025-06-17', '2025-06-23')") $ids = array(13,15,17) $testQ = mysqli_query("SELECT * FROM test15 WHERE number IN" . $ids);
Copy Clear