Transaction processing analysis of PDO in PHP_php skills

This article analyzes the transaction processing of PDO in PHP through examples. Share it with everyone for your reference, the details are as follows:

Transaction processing has four characteristics: atomicity, consistency, independence, and durability.

Not all databases support transaction processing. PDO provides transaction support for databases that can perform transaction processing.

Note when configuring transaction processing:

1. Turn off automatic submission of PDO;

$pdo->setAttribute(PDO::ATTR_AUTOCOMMIT, false);

2. Methods required to open a transaction;

$pdo->beginTransaction(); // 开启一个事务
$pdo->commit(); // 提交事务
$pdo->rollback(); // 回滚事务

3. General transaction processing is run in the try...catch... statement. When the transaction fails, the catch code segment is executed.

<&#63;php
try {
  $pdo->beginTransaction(); // 开启一个事务
  $row = null;
  $row = $pdo->exec("xxx"); // 执行第一个 SQL
  if (!$row)
    throw new PDOException('提示信息或执行动作'); // 如出现异常提示信息或执行动作
  $row = $pdo->exec("xxx"); // 执行第二个 SQL
  if (!$row)
    throw new PDOException('提示信息或执行动作');
  $pdo->commit();
} catch (PDOException $e) {
  $pdo->rollback(); // 执行失败，事务回滚
  exit($e->getMessage());
}
&#63;>

If an error occurs in the SQL statement in the transaction, all SQL will not be executed. Only when all SQL statements are correct will they be submitted for execution.

Readers who are interested in more PHP-related content can check out the special topics of this site: "Summary of PHP database operation skills based on pdo", "Summary of PHP operations and operator usage" , "Summary of PHP network programming skills", "Introduction tutorial on basic PHP syntax", "Summary of PHP operating office document skills (including word, excel, access, ppt)》, "php date and time usage summary", "php object-oriented programming introductory tutorial", "php string (string) usage summary ", "php mysql database operation introductory tutorial" and "php common database operation skills summary"

I hope this article will be helpful to everyone in PHP programming.