Get connection is busy or not
(PHP 4 >= 4.2.0, PHP 5)
bool pg_connection_busy ( resourceconnection )
pg_connection_busy() determines whether or not a connection
is busy. If it is busy, a previous query is still executing.
If pg_get_result() is used on the connection, it will be blocked.
Parameters
connection
PostgreSQL database connection resource.
Return Values
Returns TRUE if the connection is busy, FALSE otherwise.
<?php
$dbconn = pg_connect("dbname=publisher") or die("Could not connect"); $bs = pg_connection_busy($dbconn);
if ($bs) {
echo 'connection is busy';
} else {
echo 'connection is not busy';
} ?>