Skip to content


Every query executed will return Blrf\Dbal\Result object.

class Result {
    public readonly array $rows = [];
    public readonly ?int $insertId = null;
    public readonly int $affectedRows = 0;
    public readonly int $warningCount = 0;


SELECT queries will return result with $rows array.


Result implements Iterator so you can also use Result object as an array:

foreach ($result as $row) {
    echo " - my awesome row: " . print_r($row, true) . "\n";


INSERT queries with sequence/autoincrement/... table keys will return last insert id.


UPDATE or DELETE queries will report affected rows.