pg_connection_busy - PHP code example

PHP Function pg_connection_busy()

The function pg_connection_busy() checks if the server is busy buffering asynchronous commands. It basically calls libpq's PQconsumeInput() and then PQisBusy() (both documented in Asynchronous Command Processing). It is not related to the server being busy overall with other connections, but rather if a queue of pending queries is running at the moment.

Most PostgreSQL functions expect a connection parameter. If not specified, the last connected database instance is used. pg_connect() opens a new connection to a PostgreSQL database. If connect_type is PGSQL_CONNECT_FORCE_NEW, a new connection is created even if the connect_string is identical to an existing one.

pg_prepare() prepares a single SQL statement to be executed with pg_execute() or pg_send_execute(). A prepared statement can be reused by executing it again, and thus is faster to execute than a raw SQL command. Unlike pg_prepare(), it does not require a pre-specified set of parameter types.

pg_sql_int_type() converts an integer value into a PHP binary string. It also supports conversion from float to int and vice versa.

pg_connection_busy example

return $a;
    }

    /** * @return array */
    public static function castLink($link, array $a, Stub $stub, bool $isNested)
    {
        $a['status'] = pg_connection_status($link);
        $a['status'] = new ConstStub(\PGSQL_CONNECTION_OK === $a['status'] ? 'PGSQL_CONNECTION_OK' : 'PGSQL_CONNECTION_BAD', $a['status']);
        $a['busy'] = pg_connection_busy($link);

        $a['transaction'] = pg_transaction_status($link);
        if (isset(self::TRANSACTION_STATUS[$a['transaction']])) {
            $a['transaction'] = new ConstStub(self::TRANSACTION_STATUS[$a['transaction']], $a['transaction']);
        }

        $a['pid'] = pg_get_pid($link);
        $a['last error'] = pg_last_error($link);
        $a['last notice'] = pg_last_notice($link);
        $a['host'] = pg_host($link);
        $a['port'] = pg_port($link);