pg_result_status - PHP code example

PHP Function Pg_Result_Status

php function pg_result_status() - Returns the status of a query result parameter. If PGSQL_STATUS_LONG is specified, it returns the numeric result status; if PGSQL_STATUS_STRING is specified, it returns the command tag for that result.

pg_result_error_field() - Returns an individual field of an error report.

pg_send_query() - Sends one or more queries to PostgreSQL asynchronously, so script execution is not blocked while the queries are executing.

pg_prepare() - Prepares a SQL statement for later execution by pg_execute() or pg_send_execute(). This allows commands that will be used repeatedly to be parsed and planned once, rather than each time they are executed.

The database connection resource (used by pg_connect() and pg_pconnect()). If not present, the default connection will be used.

An array of parameter values to substitute for the $1, $2, etc. placeholders in the original prepared query string. The number of elements in the array must match the number of placeholders. Returns TRUE on success or FALSE on failure.

The PostgreSQL server version used by this connection. This information is only available if PHP was compiled with PostgreSQL 7.4 or later, and the pgsql.ignore_notice() setting is not enabled.

The PostgreSQL session ID of this connection, if any. This is only used when pg_send_query() or pg_prepare() are called, and not when pg_get_result() is used.

pg_result_status example

$a['param'] = new EnumStub($a['param']);

        return $a;
    }

    /** * @return array */
    public static function castResult($result, array $a, Stub $stub, bool $isNested)
    {
        $a['num rows'] = pg_num_rows($result);
        $a['status'] = pg_result_status($result);
        if (isset(self::RESULT_STATUS[$a['status']])) {
            $a['status'] = new ConstStub(self::RESULT_STATUS[$a['status']], $a['status']);
        }
        $a['command-completion tag'] = pg_result_status($result, \PGSQL_STATUS_STRING);

        if (-1 === $a['num rows']) {
            foreach (self::DIAG_CODES as $k => $v) {
                $a['error'][$k] = pg_result_error_field($result, $v);
            }
        }