PHP连接MSSQL实现日志记录方法

$serverName = "localhost";
$connectionOptions = [
    "Database" => "LogDB",
    "UID" => "sa",
    "PWD" => "your_password"
];
$conn = sqlsrv_connect($serverName, $connectionOptions);
if (!$conn) {
die("连接失败: " . print_r(sqlsrv_errors(), true));
}

CREATE TABLE AppLogs (
    ID INT IDENTITY(1,1) PRIMARY KEY,
    LogLevel VARCHAR(10),        -- 如 ERROR, INFO, DEBUG
    Message NVARCHAR(MAX),
    Source VARCHAR(100),         -- 模块或类名
    CreatedAt DATETIME DEFAULT GETDATE()
);

function writeLog($level, $message, $source, $conn) {
    $sql = "INSERT INTO AppLogs (LogLevel, Message, Source) VALUES (?, ?, ?)";
    $params = [$level, $message, $source];
    $stmt = sqlsrv_query($conn, $sql, $params);
if ($stmt === false) {
    error_log("日志写入失败: " . print_r(sqlsrv_errors(), true));
}
}
// 使用示例
writeLog("ERROR", "数据库连接超时", "UserService", $conn);
writeLog("INFO", "用户登录成功", "AuthController", $conn);

$sql = "SELECT TOP 50 * FROM AppLogs ORDER BY CreatedAt DESC";
$stmt = sqlsrv_query($conn, $sql);
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    echo "[$row[CreatedAt]] [$row[LogLevel]] ($row[Source]): $row[Message]<br>";
}