When you notice that BEGIN, COMMIT, ROLLBACK don’t seem to work (the queries are committed immediately) just take a look at the storage engine of your tables. It should be set to InnoDB. I’ve wasted 4 hours until i figured out what the problem was in my php pages, hope this will help you 🙂