<?phpclass pgsql {private $linkid; // PostgreSQL連接標識符private $host; // PostgreSQL服務器主機private $port; // PostgreSQL服務器主機端口private $user; // PostgreSQL用戶private $passwd; // PostgreSQL密碼private $db; // Postgresql數據庫private $result; // 查詢的結果private $querycount; // 已執行的查詢總數/* 類構造函數，用來初始化$host、$user、$passwd和$db字段。 */function __construct($host, $port ,$db, $user, $passwd) {$this->host = $host;$this->port = $port;$this->user = $user;$this->passwd = $passwd;$this->db = $db;}/* 連接Postgresql數據庫 */function connect(){try{$this->linkid = @pg_connect("host=$this->host port=$this->port dbname=$this->dbuser=$this->user password=$this->passwd");if (! $this->linkid)throw new Exception("Could not connect to PostgreSQL server.");}catch (Exception $e) {die($e->getMessage());}}/* 執行數據庫查詢。 */function query($query){try{$this->result = @pg_query($this->linkid,$query);if(! $this->result)throw new Exception("The database query failed.");}catch (Exception $e){echo $e->getMessage();}$this->querycount++;return $this->result;}/* 確定受查詢所影響的行的總計。 */function affectedRows(){$count = @pg_affected_rows($this->linkid);return $count;}/* 確定查詢返回的行的總計。 */function numRows(){$count = @pg_num_rows($this->result);return $count;}/* 將查詢的結果行作為一個對象返回。 */function fetchObject(){$row = @pg_fetch_object($this->result);return $row;}/* 將查詢的結果行作為一個索引數組返回。 */function fetchRow(){$row = @pg_fetch_row($this->result);return $row;}/* 將查詢的結果行作為一個關聯數組返回。 */function fetchArray(){$row = @pg_fetch_array($this->result);return $row;}/* 返回在這個對象的生存期內執行的查詢總數。這不是必須的，但是您也許會感興趣。 */function numQueries(){return $this->querycount;}}?>

<?php  include 'PGDB.php';  $PG = new pgsql("192.168.1.167", "5432", "postgis", "postgres", "post");  $PG->connect();  if(!$PG)  {    $db_error = "無法連接到PostGreSQL數據庫！";    echo $db_error;  }  else  {    echo "成功連接！";    $query = "select name from ex where gid = 2";    $result = $PG->query($query);    $row = $PG->fetchRow();    echo $row[0];  }?>