事务处理

<?php

$dbhost = '192.168.3.3:8066';  // mysql服务器主机地址

$dbuser = 'root';            // mysql用户名

$dbpass = '123456';          // mysql用户名密码

$conn = mysqli_connect($dbhost, $dbuser, $dbpass);

if(! $conn )

{

    die('连接失败: ' . mysqli_error($conn));

}

// 设置编码，防止中文乱码

mysqli_query($conn, "set names utf8");

mysqli_select_db( $conn, 'TESTDB' );





mysqli_query($conn, "SET AUTOCOMMIT=0"); // 设置为不自动提交，因为MYSQL默认立即执行

mysqli_begin_transaction($conn);            // 开始事务定义



$result = mysqli_query($conn, "select * from demo where id = 3");

echo "<pre>";

$row=mysqli_fetch_array($result,MYSQLI_NUM);

var_dump($row[0]);

 

if(!mysqli_query($conn, "insert into runoob_transaction_test (id) values(9+{$row[0]})"))

{

    mysqli_query($conn, "ROLLBACK");      // 判断执行失败时回滚

}

mysqli_commit($conn);            //执行事务

mysqli_close($conn);

?>