I found the ROLLBACK issue. After examining the structure of the tables in the database with phpMyAdmin, I discovered that the tables are of the MyISAM Storage Engine type, which does not support transactions. Basically, using ROLLBACK with MyISAM is useless.