pg_result_status

    (PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)

    pg_result_status — Get status of query result

    Descrição

    pg_result_status(PgSql\Result$result, int$mode = PGSQL_STATUS_LONG): string|int

    pg_result_status() returns the status of the PgSql\Result instance, or the PostgreSQL command completion tag associated with the result

    Parâmetros

    result

    Uma instância de PgSql\Result, retornada por pg_query(), pg_query_params() ou pg_execute() (entre outras).

    mode

    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.

    Valor Retornado

    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.

    Registro de Alterações

    VersãoDescrição
    8.1.0 O parâmetro result agora espera uma instância de PgSql\Result; anteriormente, um resource era esperado.

    Exemplos

    Exemplo #1 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.";

    ?>

    O exemplo acima produzirá:

    Copy began.

    Veja Também

    To Top