mysqli 异常处理

<?php
$host = 'localhost';
$user = 'username';
$password = 'password';
$database = 'database_name';

try {
    // 创建数据库连接
    $mysqli = new mysqli($host, $user, $password, $database);

    // 检查连接是否成功
    if ($mysqli->connect_error) {
        throw new Exception("连接失败: " . $mysqli->connect_error);
    }

    // 执行 SQL 查询
    $sql = "SELECT * FROM users WHERE id = ?";
    $stmt = $mysqli->prepare($sql);
    $stmt->bind_param('i', $userId);
    $userId = 1;
    $stmt->execute();

    // 获取查询结果
    $result = $stmt->get_result();
    while ($row = $result->fetch_assoc()) {
        echo "ID: " . $row['id'] . " - Name: " . $row['name'] . "<br>";
    }

    // 关闭连接
    $stmt->close();
    $mysqli->close();
} catch (Exception $e) {
    echo "发生异常: " . $e->getMessage();
}
?>