PHP OOP中PDO数据库连接Options参数的正确使用

<?php

class DatabaseConnection
{
    private $host;
    private $username;
    private $password;
    private $database;
    private $options;
    public $connect;

    public function __construct()
    {
        $this->host = 'localhost';
        $this->username = 'root';
        $this->password = '';
        $this->database = 'mydatabase';
        $this->options = array(
            PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,
            PDO::ATTR_EMULATE_PREPARES   => false,
        );

        // 错误的连接方式：将 $this->options 用双引号包裹
        $this->connect = new PDO(
            "mysql:host=$this->host;dbname=$this->database",
            "$this->username",
            "$this->password",
            "$this->options" // 错误点：这里将数组转换为字符串
        );
    }
}

// 实例化类以触发连接
$db = new DatabaseConnection();

?>

<?php

class DatabaseConnection
{
    private $host;
    private $username;
    private $password;
    private $database;
    private $options;
    public $connect;

    public function __construct()
    {
        $this->host = 'localhost';
        $this->username = 'root';
        $this->password = '';
        $this->database = 'mydatabase';
        $this->options = array(
            PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,    // 错误模式：抛出异常
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,          // 默认获取模式：以对象形式返回结果
            PDO::ATTR_EMULATE_PREPARES   => false,                   // 禁用模拟预处理，使用原生预处理
        );

        // 正确的连接方式：直接传递 $this->options 数组
        $this->connect = new PDO(
            "mysql:host=$this->host;dbname=$this->database",
            $this->username, // 用户名和密码参数不需额外引号
            $this->password,
            $this->options   // 正确：直接传递数组变量
        );

        // 可以在此处添加其他初始化逻辑，例如启动会话
        session_start();
    }

    // 示例：执行查询的方法
    public function executeQuery(string $query, array $data = [])
    {
        $statement = $this->connect->prepare($query);
        $statement->execute($data);
        return $statement;
    }

    // 示例：获取行数的方法
    public function getTotalRows(string $query, array $data = [])
    {
        $statement = $this->executeQuery($query, $data);
        return $statement->rowCount();
    }

    // 示例：重定向方法
    public function redirect(string $page)
    {
        header('Location: ' . $page);
        exit;
    }
}

// 实例化类并使用
try {
    $db = new DatabaseConnection();
    echo "数据库连接成功！<br>";

    // 示例使用
    // $stmt = $db->executeQuery("SELECT * FROM users WHERE id = ?", [1]);
    // $user = $stmt->fetch();
    // if ($user) {
    //     echo "用户ID 1: " . $user->name . "<br>";
    // }

} catch (PDOException $e) {
    echo "数据库连接失败: " . $e->getMessage();
}

?>