- var_dump: documentation ( source)
<?php
$pdo = new PDO('sqlite::memory:');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
var_dump($pdo->getAttribute(PDO::ATTR_AUTOCOMMIT));
var_dump($pdo->getAttribute(PDO::ATTR_PERSISTENT));
$pdo->exec("CREATE TABLE claim(
external_id CHAR(10),
created_at CHAR(10)
)");
$pdo->exec("INSERT INTO claim VALUES ('row1field1', 'row1field2')");
$pdo->exec("INSERT INTO claim VALUES ('row2field1', 'row2field2')");
//$statement = $pdo->query("SELECT * FROM foo WHERE `field1` in(?)");
$statement = $pdo->query("select * from `claim` where `external_id` in (?, ?) order by `created_at` desc limit 9223372036854775807 offset 0");
$statement->execute(['row2field1']);
var_dump($statement->fetchAll());