PHP PDO 连接 PostgreSQL 数据库类

当然可以！下面是一个连接到 PostgreSQL 数据库的简单 PDO 类的示例：\n\nphp\nclass Database\n{\n private $host = 'localhost';\n private $dbname = 'your_database_name';\n private $username = 'your_username';\n private $password = 'your_password';\n private $db;\n\n public function __construct()\n {\n $dsn = "pgsql:host={$this->host};dbname={$this->dbname}";\n\n try {\n $this->db = new PDO($dsn, $this->username, $this->password);\n $this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n } catch (PDOException $e) {\n die("Database connection failed: " . $e->getMessage());\n }\n }\n\n public function query($sql)\n {\n return $this->db->query($sql);\n }\n\n // 如果需要执行预处理语句，可以添加以下方法：\n public function prepare($sql)\n {\n return $this->db->prepare($sql);\n }\n\n public function execute($statement, $params)\n {\n return $statement->execute($params);\n }\n}\n\n\n使用上述类连接到 PostgreSQL 数据库：\n\nphp\n$database = new Database();\n\n// 执行查询语句\n$result = $database->query("SELECT * FROM your_table");\n\n// 遍历结果集\nwhile ($row = $result->fetch(PDO::FETCH_ASSOC)) {\n // 打印每一行的数据\n print_r($row);\n}\n\n// 执行预处理语句\n$statement = $database->prepare("INSERT INTO your_table (column1, column2) VALUES (:value1, :value2)");\n$params = array(':value1' => 'value1', ':value2' => 'value2');\n$database->execute($statement, $params);\n\n\n请确保将 your_database_name 替换为实际的数据库名称，并使用正确的用户名和密码进行连接。