Online PHP editor | output for Zm6rN

<?php $db = new SQLite3(':memory:'); $db->exec("CREATE TABLE foo (bar TEXT)"); $stmt = $db->prepare("INSERT INTO foo VALUES (:bar)"); $stmt->bindValue(':bar', 'xx', SQLITE3_TEXT); $stmt->execute(); $stmt = $db->prepare("INSERT INTO foo VALUES (?)"); $stmt->bindValue(0, 'xx', SQLITE3_TEXT); $stmt->execute(); $res = $db->query("SELECT * FROM foo"); while (($row = $res->fetchArray(SQLITE3_ASSOC))) { var_dump($row); } $db = new PDO('sqlite::memory:'); $db->exec("CREATE TABLE foo (bar TEXT)"); $stmt = $db->prepare("INSERT INTO foo VALUES (:bar)"); $stmt->bindValue(':bar', 'xx', SQLITE3_TEXT); $stmt->execute(); $stmt = $db->prepare("INSERT INTO foo VALUES (?)"); $stmt->bindValue(0, 'xx', SQLITE3_TEXT); $stmt->execute();