pg_transaction_status

Returns the current in-transaction status of the server. (PHP 5 >= 5.1.0)
int pg_transaction_status ( resource connection )

Example 1979. 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';

  }    
?>

Code Examples / Notes » pg_transaction_status

This function is implemented in C, so there's no way to mimic it in SQL for older versions of PHP. But you can mimic some of the functionality by using a wrapper which keeps track of when you begin and commit/rollback transactions.

pg_transaction_status

Returns the current in-transaction status of the server. (PHP 5 >= 5.1.0) int pg_transaction_status ( resource connection )

Example 1979. pg_transaction_status() example

Code Examples / Notes » pg_transaction_status

Change Language

Returns the current in-transaction status of the server. (PHP 5 >= 5.1.0)
int pg_transaction_status ( resource connection )