Checking Transaction Status with inTransaction()

The inTransaction() method checks if a transaction is currently active on the database connection. This means it verifies if we have previously called beginTransaction() and have not yet closed the transaction with commit or rollback. This method is extremely useful in more complex systems where we want to prevent errors that occur when trying to open a new transaction while one is already open.

EXAMPLE

<?php
class Database {
    private $server = "localhost";
    private $username = "root";
    private $password = "";
    private $db_name = "pdo_db";
    public $connection;

    public function __construct() {
        try {
            // Added charset=utf8mb4 for character support
            $dsn = "mysql:host=" . $this->server . ";dbname=" . $this->db_name . ";charset=utf8mb4";
            $this->connection = new PDO($dsn, $this->username, $this->password);
            $this->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        } catch(PDOException $e) {
            die("Connection failed: " . $e->getMessage());
        }
    }

    public function checkStatus() {
        // Returns true if a transaction is open
        return $this->connection->inTransaction();
    }
}

// PART 3: Usage
$db = new Database();

echo "Status before transaction: " . ($db->checkStatus() ? "Active" : "Not active") . "<br>";

$db->connection->beginTransaction();

echo "Status during transaction: " . ($db->checkStatus() ? "Active" : "Not active");

$db->connection->rollBack();
?>

RESULT

The result will be displayed here...

Practical Application: We use this method before starting a new operation to make sure of the connection state and prevent overlapping transactions. Check the process at home by following these steps:

Start the Apache and MySQL modules in the XAMPP control panel.
The method returns a boolean value: true if a transaction is active, and false if it is not.
Ensure that you have created the pdo_db database so that the connection in the example works correctly.
Insert the example below into a PHP file and observe how the status changes after calling the start of the transaction.