PHP / MySQL - “BEGIN ... COMMIT”不工作

I was searching for a way to insert data into two database tables in a single query in such a way that if one failed, neither saved (I don't want orphaned data). I came across a Stack Overflow question that showed me how to use BEGIN...COMMIT to accomplish this, but it simply is not working.I was searching for a way to insert data into t