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 resultSYNOPSISmixed pg_result_status (resource $result, [int $type = PGSQL_STATUS_LONG])DESCRIPTIONpg_result_status(3) returns the status of a result resource, or the PostgreSQL command completion tag associated with the resultPARAMETERSo $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 VALUESPossible 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.EXAMPLESExample #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 ALSOpg_connection_status(3). PHP Documentation Group PG_RESULT_STATUS(3)
Related Man Pages |
---|
pg_fetch_result(3) - php |
pg_field_num(3) - php |
pg_fetch_all_columns(3) - php |
pg_last_error(3) - php |
pg_last_oid(3) - php |
Similar Topics in the Unix Linux Community |
---|
echo command result |