Transaction wrapper (pseudocode)

gistfile1.php

<?php

class Transaction
{
    protected $db;
    
    public function __construct($db)
    {
        $this->db = $db
    }
    
    public function execute(Command $command)
    {
        $this->db->start_transaction();
        
        try 
        {
            $command->execute();
        } 
        catch (Exception $ex) { //Catch an appropiate exception here
            $this->db->roll_back();
            return;
        }
            
        $db->commit()
    }
    
}