PHP Manual
PostgreSQL 函数
Returns the current in-transaction status of the server

pg_transaction_status

(PHP 5 >= 5.1.0, PHP 7)

pg_transaction_status — Returns the current in-transaction status of the server

说明

pg_transaction_status ( resource $connection ) : int

Returns the current in-transaction status of the server.

Caution

pg_transaction_status() will give incorrect results when using a PostgreSQL 7.3 server that has the parameter autocommit set to off. The server-side autocommit feature has been deprecated and does not exist in later server versions.

参数

connection: PostgreSQL database connection resource.

返回值

The status can be PGSQL_TRANSACTION_IDLE (currently idle), PGSQL_TRANSACTION_ACTIVE (a command is in progress), PGSQL_TRANSACTION_INTRANS (idle, in a valid transaction block), or PGSQL_TRANSACTION_INERROR (idle, in a failed transaction block). PGSQL_TRANSACTION_UNKNOWN is reported if the connection is bad. PGSQL_TRANSACTION_ACTIVE is reported only when a query has been sent to the server and not yet completed.

范例

Example #1 pg_transaction_status() example

 <?php
  $dbconn = pg_connect("dbname=publisher") or die("Could not connect");
  $stat = pg_transaction_status($dbconn);
  if ($stat === PGSQL_TRANSACTION_UNKNOWN) {
      echo 'Connection is bad';
  } else if ($stat === PGSQL_TRANSACTION_IDLE) {
      echo 'Connection is currently idle';
  } else {
      echo 'Connection is in a transaction state';
  }    
?>

php imap 函数 returns status information on a mailbox php mcve 函数 returns array of strings which represents the keys that can be used for response parameters on this transaction php maxdb 函数 commits the current transaction php maxdb 函数 returns the version of the maxdb server php maxdb 函数 returns the version of the maxdb server as an integer php maxdb 函数 gets the current system status php mssql 函数 returns the last message from the server php postgresql 函数 returns the name or oid of the tables field php postgresql 函数 returns the type id oid for the corresponding field number php postgresql 函数 looks up a current parameter setting of the server php postgresql 函数 submits a command to the server and waits for the result with the ability to pass parameters separately from the sql command text php postgresql 函数 returns the current in transaction status of the server php postgresql 函数 returns an array with client protocol and server version when available php session pgsql 函数 get current save handler status php svn 函数 creates and returns a transaction root php svn 函数 returns the status of working copy files and directories php xmlwriter 函数 returns current buffer php yp/nis 函数 returns the machine name of the master nis server for a map php hyperwave api 函数 returns statistics about database server php hyperwave api 函数 returns statistics about document cache server