{"id":1361,"date":"2021-04-23T03:36:49","date_gmt":"2021-04-23T03:36:49","guid":{"rendered":"https:\/\/phptutorial.net\/?page_id=1361"},"modified":"2021-07-08T04:23:59","modified_gmt":"2021-07-08T04:23:59","slug":"php-pdo-transaction","status":"publish","type":"page","link":"https:\/\/www.phptutorial.net\/php-pdo\/php-pdo-transaction\/","title":{"rendered":"PHP PDO Transaction"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to perform a database transaction from PHP by using PDO API.<\/p>\n\n\n\n

Introduction to PHP PDO transaction #<\/a><\/h2>\n\n\n\n

To start a transaction in PDO, you use the PDO::beginTransaction()<\/code> method:<\/p>\n\n\n

$pdo->beginTransaction();<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
The beginTransaction()<\/code> method turns off the autocommit mode. It means that the changes made to the database via the PDO object won’t take effect until you call the PDO::commit()<\/code> method.<\/p>\n\n\n\n
To commit a transaction, you call the PDO::commit()<\/code> method:<\/p>\n\n\n
$pdo->commit();<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
If you want to roll back the transaction, you can call the PDO::rollback()<\/code> method:<\/p>\n\n\n
$pdo->rollback();<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
The PDO::rollback()<\/code> method rolls back all changes made to the database. Also, it returns the connection to the autocommit mode.<\/p>\n\n\n\n
The PDO::beginTransaction()<\/code> method throws an exception if the database doesn’t support transactions.<\/p>\n\n\n\n
PDO transaction example #<\/a><\/h2>\n\n\n\n
Suppose that you need to insert data into three tables: books<\/code>, authors<\/code>, and book_authors<\/code>. <\/p>\n\n\n\n
To do that, you need to:<\/p>\n\n\n\n