3v4l.org

run code in 300+ PHP versions simultaneously
<?php $pdo = new PDO('sqlite::memory:'); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->exec("CREATE TABLE foo( field1 CHAR(10), field2 CHAR(10) )"); $pdo->exec("INSERT INTO foo VALUES ('row1field1', 'row1field2')"); $pdo->exec("INSERT INTO foo VALUES ('row2field1', 'row2field2')"); $statement = $pdo->query("SELECT * FROM foo WHERE `field1` in(?)"); $statement->execute(['row2field1']); var_dump($statement->fetchAll());
Output for 5.5.24 - 5.5.35, 5.6.8 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.10, 7.2.0 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
array(1) { [0]=> array(4) { ["field1"]=> string(10) "row2field1" [0]=> string(10) "row2field1" ["field2"]=> string(10) "row2field2" [1]=> string(10) "row2field2" } }
preferences:
144.17 ms | 404 KiB | 181 Q