3v4l.org

run code in 200+ php & hhvm versions
Bugs & Features
<?php $pdo = new PDO('sqlite::memory:'); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->exec("CREATE TABLE foo( field1 INT, field2 INT )"); $pdo->exec("INSERT INTO foo SET `field1` = 'row1field1', `field2` = 'row1field2'"); $results = $pdo->query("SELECT * FROM foo "); var_dump($results->fetchAll());
based on V1mAL
Output for 7.0.0 - 7.2.0
Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1 near "SET": syntax error in /in/RroQK:11 Stack trace: #0 /in/RroQK(11): PDO->exec('INSERT INTO foo...') #1 {main} thrown in /in/RroQK on line 11
Process exited with code 255.
Output for 5.3.22 - 5.6.28
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 near "SET": syntax error' in /in/RroQK:11 Stack trace: #0 /in/RroQK(11): PDO->exec('INSERT INTO foo...') #1 {main} thrown in /in/RroQK on line 11
Process exited with code 255.