php记录日志mysql

CREATE TABLE `logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `message` text NOT NULL,
  `level` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

<?php
// 数据库连接配置
$host = 'localhost';
$dbname = 'your_database';
$user = 'your_username';
$password = 'your_password';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8mb4", $user, $password);
} catch (PDOException $e) {
    die("数据库连接失败: " . $e->getMessage());
}

// 记录日志
function logToDatabase($message, $level) {
    global $pdo;
    $stmt = $pdo->prepare("INSERT INTO logs (message, level, created_at) VALUES (:message, :level, NOW())");
    $stmt->bindParam(':message', $message);
    $stmt->bindParam(':level', $level);
    $stmt->execute();
}

// 示例：记录一条错误日志
logToDatabase("这是一个错误信息", "ERROR");
?>