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)