php + sqlserver如何使用事务

举个例子：

<?php
/**
 * php sql server事务
 * Created by PhpStorm.
 * User: lu_master
 * Date: 2019-1-10 0010
 * Time: 15:43
 */

header("Content-Type: text/html; charset=UTF-8");
header('Access-Control-Allow-Origin: *');
header("Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept");
header('Access-Control-Allow-Methods: GET, POST, PUT,DELETE');

$serverName = ".\SQLSERVERDEMO"; // 服务器名称
$connInfo = array("Database" => "myDatabase", "UID" => "admin", "PWD" => "123"); // 数据库名称、服务器用户名、服务器密码
$conn = sqlsrv_connect($serverName, $connInfo); // 连接数据库

if ($conn === false) {
    die(print_r(sqlsrv_errors(), true));
}

// 启动事务
if (sqlsrv_begin_transaction($conn) === false) {
    die(print_r(sqlsrv_errors(), true));
}

$UserName = "admin";
$PassWord = "1";
$SEX = "";


$sql1 = "INSERT INTO userInfo (UserName, PassWord) VALUES (?,?)";
$sql2 = "INSERT INTO userInfoDetail (USERNAME, PASSWORD, SEX) VALUES (?,?,?)";

$param1 = array($UserName, $PassWord);
$param2 = array($UserName, $PassWord, $SEX);

$stmt1 = sqlsrv_query($conn, $sql1, $param1);
$stmt2 = sqlsrv_query($conn, $sql2, $param2);

if ($stmt1 && $stmt2) {
    sqlsrv_commit($conn); // 事务提交
    echo "提交成功！";
} else {
    sqlsrv_rollback($conn); // 事务回滚
    echo "提交失败！事务回滚";
}