Php transaction rollback simple implementation example, php transaction example

Php transaction rollback simple implementation example, php transaction example

This example describes the simple implementation of php transaction rollback. We will share this with you for your reference. The details are as follows:

$ Servername = "localhost"; $ username = "root"; $ password = "admin"; $ dbname = "test"; try {$ conn = new PDO ("mysql: host = $ servername; dbname = $ dbname ", $ username, $ password); $ conn-> setAttribute (PDO: ATTR_ERRMODE, PDO: ERRMODE_EXCEPTION ); // start the transaction $ conn-> beginTransaction (); $ conn-> exec ("insert into 'hello' ('firstname', 'lastname', 'email ') VALUES ('Ye ', 'xiaming', 'yexianming @ 163.com') "); $ conn-> exec (" insert into 'hello' ('firs Tname', 'lastname', 'email ') VALUES ('Ye', 'cong', 'yecong @ 163.com ')"); $ conn-> exec ("insert into 'hello' ('firstname', 'lastname', 'email ') VALUES ('fang', 'meng ', 'fangmeng @ 168.com ') "); // submit the transaction $ conn-> commit (); echo" New records created successfully! ";} Catch (PDOException $ e) {// roll back the transaction $ conn-> rollBack (); echo $ SQL. "<br> ". $ e-> getMessage () ;}$ conn = NULL;