Online PHP editor | refs for 64MQv

<?php $table = 'foo'; $query = "INSERT INTO $table VALUES (\"first value\"); -- dam'd quote INSERT INTO $table VALUES (\"foo : ba'r \"), (\"foo.:bar\"); "; $pdo = new PDO('sqlite::memory:'); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->exec('CREATE TABLE foo (text bar)'); $stmt = $pdo->prepare($query); try { $stmt->execute(); } catch (Exception $e) { echo "Failed : ", $e->getMessage(); } $stmt = $pdo->query('SELECT * FROM foo'); var_dump($stmt->fetchAll());