<?php
$pdo = new pdo(
'sqlite::memory:',
null,
null,
[
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_EMULATE_PREPARES => false,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_GROUP | PDO::FETCH_FUNC
]
);
$pdo->exec('create table x(sort int, foo text, bar text)');
$pdo->exec("insert into x(sort, foo, bar) values (1, 'a', 'b'), (1, 'c', 'd'), (2, 'e', 'f')");
$pdo->query('select * from x')
->fetchAll(PDO::FETCH_GROUP | PDO::FETCH_FUNC, function () { var_dump(func_get_args()); });
- Output for 7.0.0 - 7.0.24, 7.1.0 - 7.1.25, 7.2.0 - 7.2.33, 7.3.0 - 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.4, 8.3.6
- array(2) {
[0]=>
string(1) "a"
[1]=>
string(1) "b"
}
array(2) {
[0]=>
string(1) "c"
[1]=>
string(1) "d"
}
array(2) {
[0]=>
string(1) "e"
[1]=>
string(1) "f"
}
- Output for 8.3.5
- Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
array(2) {
[0]=>
string(1) "a"
[1]=>
string(1) "b"
}
array(2) {
[0]=>
string(1) "c"
[1]=>
string(1) "d"
}
array(2) {
[0]=>
string(1) "e"
[1]=>
string(1) "f"
}
preferences:
159.52 ms | 402 KiB | 194 Q