Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : PostgreSQL Functions : pg_result_error

pg_result_error

Get error message associated with result (PHP 4 >= 4.2.0, PHP 5)
string pg_result_error ( resource result )

Example 1968. pg_result_error() example

<?php
 $dbconn
= pg_connect("dbname=publisher") or die("Could not connect");

 if (!
pg_connection_busy($dbconn)) {
     
pg_send_query($dbconn, "select * from doesnotexist;");
 }
 
 
$res1 = pg_get_result($dbconn);
 echo
pg_result_error($res1);
?>

Code Examples / Notes » pg_result_error

axon dot wp

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

16-mar-2004 12: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.


Change Language


Follow Navioo On Twitter
pg_affected_rows
pg_cancel_query
pg_client_encoding
pg_close
pg_connect
pg_connection_busy
pg_connection_reset
pg_connection_status
pg_convert
pg_copy_from
pg_copy_to
pg_dbname
pg_delete
pg_end_copy
pg_escape_bytea
pg_escape_string
pg_execute
pg_fetch_all_columns
pg_fetch_all
pg_fetch_array
pg_fetch_assoc
pg_fetch_object
pg_fetch_result
pg_fetch_row
pg_field_is_null
pg_field_name
pg_field_num
pg_field_prtlen
pg_field_size
pg_field_table
pg_field_type_oid
pg_field_type
pg_free_result
pg_get_notify
pg_get_pid
pg_get_result
pg_host
pg_insert
pg_last_error
pg_last_notice
pg_last_oid
pg_lo_close
pg_lo_create
pg_lo_export
pg_lo_import
pg_lo_open
pg_lo_read_all
pg_lo_read
pg_lo_seek
pg_lo_tell
pg_lo_unlink
pg_lo_write
pg_meta_data
pg_num_fields
pg_num_rows
pg_options
pg_parameter_status
pg_pconnect
pg_ping
pg_port
pg_prepare
pg_put_line
pg_query_params
pg_query
pg_result_error_field
pg_result_error
pg_result_seek
pg_result_status
pg_select
pg_send_execute
pg_send_prepare
pg_send_query_params
pg_send_query
pg_set_client_encoding
pg_set_error_verbosity
pg_trace
pg_transaction_status
pg_tty
pg_unescape_bytea
pg_untrace
pg_update
pg_version
eXTReMe Tracker