Online PHP editor | refs for WD6qs

<?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` = ?"); $statement->execute(['row1field1']); var_dump($results->fetchAll());