如何在PHP中解密由SQL Server的EncryptByPassPhrase()加密的字符串？

$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));
}

$encryptedString = "your_encrypted_string";
$passphrase = "your_passphrase";

$sql = "SELECT CONVERT(varchar, DecryptByPassPhrase('$passphrase', $encryptedString)) AS decryptedString";
$stmt = sqlsrv_query($conn, $sql);
if ($stmt === false) {
    die(print_r(sqlsrv_errors(), true));
}

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

$decryptedString = sqlsrv_get_field($stmt, 0);

sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);

// 使用解密后的字符串进行后续操作
echo $decryptedString;