I'm looking into rollback management with MySQLi, and I'm curious what the value of "begin_transaction" method is. Many examples I look at skip it entirley by turning autocommit off, then executing some queries with success value returned, and testing a compound Boolean based on the return values to commit or rollback the multiple statements.
It doesn't seem like the "begin_transaction" method actually does any useful work in a scenario where we are looking to commit or rollback a group of queries based on the success of all of them. I can see that it adds readability to the code perhaps by explicitely declaring a transaction, but is there a value to "begin_transaction" other than in readability? What real work does it do?