<?php
$pdo = new PDO('sqlite::memory:');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
var_dump($pdo);
$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());
- Output for 5.5.24 - 5.5.35, 5.6.8 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.20, 7.2.5 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- object(PDO)#1 (0) {
}
array(1) {
[0]=>
array(4) {
["external_id"]=>
string(10) "row2field1"
[0]=>
string(10) "row2field1"
["created_at"]=>
string(10) "row2field2"
[1]=>
string(10) "row2field2"
}
}
preferences:
152.27 ms | 404 KiB | 182 Q