PHP operation Postgresql encapsulation class and complete application example

This article mainly introduces the PHP operation Postgresql encapsulation class, and analyzes the common connection, query, statistics and other operation encapsulation techniques and usage methods of PHP for Postgresql database in the form of examples. Friends in need can refer to the following

The examples in this article describe the PHP operation of Postgresql encapsulation classes and applications. I share it with you for your reference. The details are as follows:

This class encapsulates some commonly used functions. The original post also contains transaction processing content. Let’s learn more about it later.

Class file definition:

<?php
class 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->db
user=$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;
}
}
?>

The tested php was released together, and another php in the LAN was also tested. With a postgresql server, I feel that the query speed is very fast, and querying postgregis data is also very good.

<?php
  include &#39;PGDB.php&#39;;
  $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];
  }
?>

Related recommendations:

postgreSQL php and client

The above is the detailed content of PHP operation Postgresql encapsulation class and complete application example. For more information, please follow other related articles on the PHP Chinese website!