使用PHP锁定SQL Server数据库

<?php
// 连接数据库
$serverName = "localhost";
$connectionOptions = array(
    "Database" => "myDB",
    "Uid" => "myUsername",
    "PWD" => "myPassword"
);
$conn = sqlsrv_connect($serverName, $connectionOptions);

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

// 开始锁定
$sql = "BEGIN TRANSACTION";
$stmt = sqlsrv_query($conn, $sql);

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

// 执行数据库操作
$sql = "UPDATE myTable SET myField = 'myValue' WHERE id = 1";
$stmt = sqlsrv_query($conn, $sql);

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

// 提交事务
$sql = "COMMIT TRANSACTION";
$stmt = sqlsrv_query($conn, $sql);

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

// 关闭连接
sqlsrv_close($conn);
?>