<?php
$pdo = new pdo('sqlite::memory:', null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
$pdo->exec('create table foo(a int)');
$pdo->exec('insert into foo values (1), (2), (3), (4)');
$sql = 'select a from foo group by a having a > 2';
$stmt = $pdo->prepare($sql);
$stmt->execute();
var_dump($stmt->fetchAll());
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]=>
array(2) {
["a"]=>
int(3)
[0]=>
int(3)
}
[1]=>
array(2) {
["a"]=>
int(4)
[0]=>
int(4)
}
}