No autocommit

[M737557]

My suggestion is, add to the sheet: No autocommit.

https://www.php.net/manual/en/pdo.commit.php
https://www.php.net/manual/en/pdo.begintransaction.php

$pdo = new PDO($dsn, $username, $password);

try {
// Start the transaction
$pdo->beginTransaction();

// Execute multiple queries
$pdo->exec("UPDATE accounts SET balance = balance - 100 WHERE user_id = 1");
$pdo->exec("UPDATE accounts SET balance = balance + 100 WHERE user_id = 2");

// Commit the transaction if all queries succeeded
$pdo->commit();

} catch (Exception $pdo) {
// Roll back the transaction if any query fails
$pdo->rollBack();
echo "Transaction failed: " . $pdo->getMessage();
}

[M737557]

$db = pdo_connect_mysql(); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION, PDO::ATTR_AUTOCOMMIT, 0); // 0 = false