<?php
$db = new pdo('sqlite::memory:', null, null, [PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION]);
$db->exec('create table foo( n INT UNIQUE );');
$n = 1;
$insert = $db->prepare('insert into foo(n) values(:n)');
$insert->bindParam('n', $n);
for ($i=0; $i<5; $i++) {
try {
$insert->execute();
} catch (PDOException $e) {
// assuming duplicate
$n++;
}
}
var_dump($db->query('select * from foo')->fetchAll());
- Output for 8.1.0 - 8.1.27, 8.2.0 - 8.2.17, 8.3.0 - 8.3.4
- array(3) {
[0]=>
array(2) {
["n"]=>
int(1)
[0]=>
int(1)
}
[1]=>
array(2) {
["n"]=>
int(2)
[0]=>
int(2)
}
[2]=>
array(2) {
["n"]=>
int(3)
[0]=>
int(3)
}
}
- Output for 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30
- array(3) {
[0]=>
array(2) {
["n"]=>
string(1) "1"
[0]=>
string(1) "1"
}
[1]=>
array(2) {
["n"]=>
string(1) "2"
[0]=>
string(1) "2"
}
[2]=>
array(2) {
["n"]=>
string(1) "3"
[0]=>
string(1) "3"
}
}
preferences:
201.84 ms | 403 KiB | 284 Q