php man page for pg_result_status

Query: pg_result_status

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

PG_RESULT_STATUS(3)													       PG_RESULT_STATUS(3)

pg_result_status - Get status of query result

SYNOPSIS
mixed pg_result_status (resource $result, [int $type = PGSQL_STATUS_LONG])
DESCRIPTION
pg_result_status(3) returns the status of a result resource, or the PostgreSQL command completion tag associated with the result
PARAMETERS
o $result - PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others). o $type - Either PGSQL_STATUS_LONG to return the numeric status of the $result, or PGSQL_STATUS_STRING to return the command tag of the $result. If not specified, PGSQL_STATUS_LONG is the default.
RETURN VALUES
Possible return values are PGSQL_EMPTY_QUERY, PGSQL_COMMAND_OK, PGSQL_TUPLES_OK, PGSQL_COPY_OUT, PGSQL_COPY_IN, PGSQL_BAD_RESPONSE, PGSQL_NONFATAL_ERROR and PGSQL_FATAL_ERROR if PGSQL_STATUS_LONG is specified. Otherwise, a string containing the PostgreSQL command tag is returned.
EXAMPLES
Example #1 pg_result_status(3) example <?php // Connect to the database $conn = pg_pconnect("dbname=publisher"); // Execute a COPY $result = pg_query($conn, "COPY authors FROM STDIN;"); // Get the result status $status = pg_result_status($result); // Determine status if ($status == PGSQL_COPY_IN) echo "Copy began."; else echo "Copy failed."; ?> The above example will output: Copy began.
SEE ALSO
pg_connection_status(3). PHP Documentation Group PG_RESULT_STATUS(3)
Related Man Pages
pg_field_num(3) - php
pg_fetch_all(3) - php
pg_field_is_null(3) - php
pg_num_rows(3) - php
pg_result_status(3) - php
Similar Topics in the Unix Linux Community
echo command result