pg_result_status

Get status of query result (PHP 4 >= 4.2.0, PHP 5)
mixed pg_result_status ( resource result [, int type] )

Example 1970. pg_result_status() 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 to clipboard

Copy began.

Code Examples / Notes » pg_result_status

If on "accident" your program passes pg_result_status a variable that is NOT a actual pg resource, it will return an empty string. (This is important to know if you want to make sure a pg resource is "good" before attempting some operation on it).

0 = PGSQL_EMPTY_QUERY 1 = PGSQL_COMMAND_OK 2 = PGSQL_TUPLES_OK 3 = PGSQL_COPY_TO 4 = PGSQL_COPY_FROM 5 = PGSQL_BAD_RESPONSE 6 = PGSQL_NONFATAL_ERROR 7 = PGSQL_FATAL_ERROR

pg_result_status

Get status of query result (PHP 4 >= 4.2.0, PHP 5) mixed pg_result_status ( resource result [, int type] )

Example 1970. pg_result_status() example

Code Examples / Notes » pg_result_status

Change Language

Get status of query result (PHP 4 >= 4.2.0, PHP 5)
mixed pg_result_status ( resource result [, int type] )