pg_result_error_field
You can use pg_set_error_verbosity() to retrieve SQLSTATUS from pg_last_error().
pg_result_error
(PHP 4 >= 4.2.0, PHP 5)
pg_result_error — Lit le message d'erreur associé à un résultat
Description
string pg_result_error
( resource $result
)
pg_result_error() retourne le message d'erreur associé au résultat result . Par conséquent, l'utilisateur a des chances d'obtenir un message d'erreur plus approprié que via pg_last_error().
La fonction pg_result_error_field() peut donner bien plus de détails sur les erreurs que pg_result_error().
Comme pg_query() retourne FALSE si la requête échoue, vous devez utiliser pg_send_query() et pg_get_result() pour récupérer la ressource de résultat.
Liste de paramètres
- result
-
Ressource résultat de requête PostgreSQL, retourné par pg_query(), pg_query_params() ou pg_execute() (entre autres).
Valeurs de retour
Retourne une chaîne de caractères s'il y a une erreur associée avec le paramètre result , FALSE autrement.
Exemples
Exemple #1 Exemple avec pg_result_error()
<?php
$dbconn = pg_connect("dbname=publisher") or die("Connexion impossible");
if (!pg_connection_busy($dbconn)) {
pg_send_query($dbconn, "select * from nexistepas;");
}
$res1 = pg_get_result($dbconn);
echo pg_result_error($res1);
?>
add a note
User Contributed Notespg_result_error
axon dot wp at wp dot pl
03-Mar-2006 01:20
03-Mar-2006 01:20
16-Mar-2004 01: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.