Beispiel #1
0
 public function query($query_str)
 {
     if (pg_connection_status($this->dbRes) === PGSQL_CONNECTION_BAD) {
         if (!pg_connection_reset($this->dbRes)) {
             $this->error = 'Connection lost';
             $this->isConnected = false;
             return false;
         }
     }
     $this->numQueries++;
     $res = @pg_query($this->dbRes, $query_str);
     if (!$res) {
         $this->error = 'Query failed: ' . pg_last_error() . ' (' . $query_str . ')';
         return false;
     }
     return $res;
 }
Beispiel #2
0
 public function Reset()
 {
     return pg_connection_reset($this->connection);
 }
Beispiel #3
0
<?php

// connection function tests
include 'config.inc';
$db = pg_pconnect($conn_str);
var_dump($db);
if (pg_connection_status($db) != PGSQL_CONNECTION_OK) {
    echo "pg_connection_status() error\n";
}
if (!pg_connection_reset($db)) {
    echo "pg_connection_reset() error\n";
}
if (pg_connection_busy($db)) {
    echo "pg_connection_busy() error\n";
}
if (function_exists('pg_transaction_status')) {
    if (pg_transaction_status($db) != PGSQL_TRANSACTION_IDLE) {
        echo "pg_transaction_status() error\n";
    }
}
if (false === pg_host($db)) {
    echo "pg_host() error\n";
}
if (!pg_dbname($db)) {
    echo "pg_dbname() error\n";
}
if (!pg_port($db)) {
    echo "pg_port() error\n";
}
if (pg_tty($db)) {
    echo "pg_tty() error\n";