php操作mysql封装类

class DB {
    private $host = 'localhost';
    private $port = 3306;
    private $user = 'root';
    private $password = '123456';
    private $dbname = 'test';
    private $pdo;

    public function __construct() {
        try {
            $dsn = "mysql:host={$this->host};port={$this->port};dbname={$this->dbname}";
            $this->pdo = new PDO($dsn, $this->user, $this->password);
        } catch (PDOException $e) {
            echo "数据库连接失败: " . $e->getMessage();
        }
    }

    // 其他数据库操作方法...
}

class DB {
    // ...省略其他代码...

    public function query($sql, $params = []) {
        try {
            $stmt = $this->pdo->prepare($sql);
            $stmt->execute($params);
            return $stmt->fetchAll(PDO::FETCH_ASSOC);
        } catch (PDOException $e) {
            echo "查询失败: " . $e->getMessage();
        }
    }

    // 其他数据库操作方法...
}