如何使用PHP在SQL Server中转义字符串？

<?php
// 连接到数据库
$serverName = "your_server_name";
$connectionOptions = array(
    "Database" => "your_database_name",
    "Uid" => "your_username",
    "PWD" => "your_password"
);
$conn = sqlsrv_connect($serverName, $connectionOptions);

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

// 准备要插入的数据
$data = "This is a string with a 'quote' character.";

// 转义字符串中的特殊字符
$escapedData = sqlsrv_real_escape_string($conn, $data);

// 插入数据
$sql = "INSERT INTO your_table_name (column_name) VALUES ('$escapedData')";
$stmt = sqlsrv_query($conn, $sql);

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

echo "Data inserted successfully!";

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