3v4l.org

run code in 300+ PHP versions simultaneously
<?php $pdo = new PDO('sqlite::memory:'); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); var_dump($pdo->getAttribute(PDO::ATTR_AUTOCOMMIT)); var_dump($pdo->getAttribute(PDO::ATTR_PERSISTENT)); $pdo->exec("CREATE TABLE claim( external_id CHAR(10), created_at CHAR(10) )"); $pdo->exec("INSERT INTO claim VALUES ('row1field1', 'row1field2')"); $pdo->exec("INSERT INTO claim VALUES ('row2field1', 'row2field2')"); //$statement = $pdo->query("SELECT * FROM foo WHERE `field1` in(?)"); $statement = $pdo->query("select * from `claim` where `external_id` in (?, ?) order by `created_at` desc limit 9223372036854775807 offset 0"); $statement->execute(['row2field1']); var_dump($statement->fetchAll());
Output for 7.0.0 - 7.0.20, 7.1.0 - 7.1.20, 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.27, 8.2.0 - 8.2.17, 8.3.0 - 8.3.4
Fatal error: Uncaught PDOException: SQLSTATE[IM001]: Driver does not support this function: driver does not support that attribute in /in/nPA9s:6 Stack trace: #0 /in/nPA9s(6): PDO->getAttribute(0) #1 {main} thrown in /in/nPA9s on line 6
Process exited with code 255.
Output for 5.5.24 - 5.5.35, 5.6.8 - 5.6.28
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[IM001]: Driver does not support this function: driver does not support that attribute' in /in/nPA9s:6 Stack trace: #0 /in/nPA9s(6): PDO->getAttribute(0) #1 {main} thrown in /in/nPA9s on line 6
Process exited with code 255.

preferences:
151.24 ms | 402 KiB | 179 Q