PHP: pg_result_error

Описание

string pg_result_error ( resource result )

pg_result_error() returns any error message associated with the result resource. Therefore, the user has a better chance of getting the correct error message than with pg_last_error().

The function pg_result_error_field() can give much greater detail on result errors than pg_result_error().

Because pg_query() returns FALSE if the query fails, you must use pg_send_query() and pg_get_result() to get the result handle.

Список параметров

result: PostgreSQL query result resource, returned by pg_query(), pg_query_params() or pg_execute() (among others).
offset: Row to move the internal offset to in the result resource. Rows are numbered starting from zero.

Примеры

Пример 1. pg_result_seek() example

<?php // Connect to the database $conn = pg_pconnect("dbname=publisher"); // Execute a query $result = pg_query($conn, "SELECT author, email FROM authors"); // Seek to the 3rd row (assuming there are 3 rows) pg_result_seek($result, 2); // Fetch the 3rd row $row = pg_fetch_row($result); ?>

pg_result_error

axon dot wp at wp dot pl
02-Mar-2006 04:20


You can  use pg_set_error_verbosity() to retrieve SQLSTATUS from pg_last_error().

15-Mar-2004 04:12


Because pg_query() returns FALSE if the query fails, you must must use pg_send_query() and pg_get_result() to get the result handle.



PostgreSQL 7.4 introduced a new function called PQresultErrorField() that can be used to get SQLSTATE code from a query, which is far more useful than the error string returned from pg_result_error().

http://www.postgresql.org/docs/7.4/static/libpq-exec.html

http://www.postgresql.org/docs/7.4/static/errcodes-appendix.html



Here's a patch that adds the pg_result_error_field() function to PHP:

http://collapsed.net/patches/php-4.3.5RC3-pg_result_error_field.diff

(To apply the patch cd into your php-4.3.5RC directory and type: patch -p1 </path/to/php-4.3.5RC3-pg_result_error_field.diff)



Example code:

<?php

  if(!($db = pg_connect("user=foo password=bar dbname=foobar")))

    die("pg_connect");



  if(!pg_send_query($db, "SELECT foo FROM bar"))

    die("pg_send_query");



  if(!($result = pg_get_result($db)))

    die("pg_get_result");



  echo(pg_result_error($result) . "<br />\n");



  /* only available if you have patched php */

  if(function_exists("pg_result_error_field"))

  {

    $fieldcode = array(

      "PGSQL_DIAG_SEVERITY",        "PGSQL_DIAG_SQLSTATE",

      "PGSQL_DIAG_MESSAGE_PRIMARY", "PGSQL_DIAG_MESSAGE_DETAIL",

      "PGSQL_DIAG_MESSAGE_HINT",    "PGSQL_DIAG_STATEMENT_POSITION",

      "PGSQL_DIAG_CONTEXT",         "PGSQL_DIAG_SOURCE_FILE",

      "PGSQL_DIAG_SOURCE_LINE",     "PGSQL_DIAG_SOURCE_FUNCTION");



    foreach($fieldcode as $fcode)

    {

      printf("%s: %s<br />\n",

        $fcode,

        pg_result_error_field($result, constant($fcode)));

    }



    pg_free_result($result);

  }

?>



<?php pg_result_error_field($result, PGSQL_DIAG_SQLSTATE); ?>

Returns the SQLSTATE code.

pg_result_error

Описание

Список параметров

Возвращаемые значения

Примеры

Смотрите также