PHP - Manual: API support for transactions

2025-05-14

API support for transactions

The MySQL server supports transactions depending on the storage engine used. Since MySQL 5.5, the default storage engine is InnoDB. InnoDB has full ACID transaction support.

Transactions can either be controlled using SQL or API calls. It is recommended to use API calls for enabling and disabling the autocommit mode and for committing and rolling back transactions.

示例 #1 Setting autocommit mode with SQL and through the API

<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("example.com", "user", "password", "database");

/* Recommended: using API to control transactional settings */
$mysqli->autocommit(false);

/* Won't be monitored and recognized by the replication and the load balancing plugin */
$mysqli->query('SET AUTOCOMMIT = 0');

Optional feature packages, such as the replication and load balancing plugin, can easily monitor API calls. The replication plugin offers transaction aware load balancing, if transactions are controlled with API calls. Transaction aware load balancing is not available if SQL statements are used for setting autocommit mode, committing or rolling back a transaction.

示例 #2 Commit and rollback

<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("example.com", "user", "password", "database");
$mysqli->autocommit(false);

$mysqli->query("INSERT INTO test(id) VALUES (1)");
$mysqli->rollback();

$mysqli->query("INSERT INTO test(id) VALUES (2)");
$mysqli->commit();

Please note, that the MySQL server cannot roll back all statements. Some statements cause an implicit commit.

See also

发现了问题？

了解如何改进此页面 • 提交拉取请求 • 报告一个错误

＋添加备注

用户贡献的备注

此页面尚无用户贡献的备注。

官方地址：https://www.php.net/manual/en/mysqli.quickstart.transactions.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言开发编程 Linux 科技 Elasticsearch HTML/CSS/XML 面试数据库网络 JAVA NoSQL C/C++ Golang Git 操作系统算法正则表达式 Redis 互联网 MySql 运维 JavaScript 软件国际架构设计 Mac OS Excel TCP/IP Windows Vim Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器 Docker

php7.3 使用 PDO_DM 扩展连接 DM8 中文乱码 PhpStorm中PHP注释的规范指南 laravel查看orm生成的sql PHPStorm ESC 会退出命令行 laravel orm中DB::insert方法导致内存泄漏的问题解决方法 docker-compose启动nginx与php-fpm composer install参数 php7 安装fileinfo扩展 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 preg_split — 通过一个正则表达式分隔字符串 Composer的Packagist资源 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 opcache预加载 PHP json解析（json_decode）页面工具 mysql面试题 PHP - mysql_real_escape_string()与mysql_escape_string() 的区别 PHP获取指定函数定义在哪个文件中及行号 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式 php上周一、本周一、下周一日期

略微加速

PHP官方手册 - 互联网笔记

API support for transactions

发现了问题？

用户贡献的备注