Online PHP editor | refs for otfDj

<?php $dbh = new \PDO('sqlite:'); $dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); $goodSql = 'SELECT number FROM (SELECT 1 number UNION SELECT 2) numbers WHERE number not in (2)'; echo json_encode($dbh->query($goodSql)->fetchAll(PDO::FETCH_NUM)); $badSql = 'SELECT number FROM (SELECT 1 number UNION SELECT 2) numbers WHERE number not in (?)'; $binds = ['2']; $statement = $dbh->prepare($badSql); $statement->execute($binds); echo json_encode($statement->fetchAll(PDO::FETCH_NUM));