mysqli rollback - 语法
bool mysqli_rollback ( mysqli $link [, int $flags [, string $name ]] );
此函数用于回滚指定数据库连接的当前事务。
| Sr.No |
参数 & Description |
| 1 |
connection
mysqli_connect()或mysqli_init()返回的链接标识符
|
| 2 |
flags
MYSQLI_TRANS_COR_*常量的位掩码。
|
| 3 |
name
如果提供，则执行ROLLBACK/*NAME*/。
|
mysqli rollback - 返回值
成功时返回TRUE，失败时返回FALSE
mysqli rollback - 示例
<?php
$connection_mysql=mysqli_connect("localhost","user","password","db");
if (mysqli_connect_errno($connection_mysql)){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_autocommit(connectionmysql</span><spanclass="pun">,</span><spanclass="pln">FALSE</span><spanclass="pun">);</span><spanclass="pln">mysqliquery</span><spanclass="pun">(</span><spanclass="pln">connection_mysql,"INSERT INTO emp (name)VALUES (Java)");
mysqli_query($connection_mysql,"INSERT INTO emp (name)VALUES (PHP)");
mysqli_commit(connectionmysql</span><spanclass="pun">);</span><spanclass="pln">mysqlirollback</span><spanclass="pun">(</span><spanclass="pln">connection_mysql);
mysqli_close($connection_mysql);
?>
参考链接
www.learnfk.com/php/php-fun…
