pg_last_error

pg_last_error

Get the last error message string of a connection

string **pg_last_error**  $connection

returns the last error message

for a given . pg_last_error``connection

Error messages may be overwritten by internal PostgreSQL (libpq) function calls. It may not return an appropriate error message if multiple errors occur inside a PostgreSQL module function.

Use , , and for better error handling. pg_result_error``pg_result_error_field``pg_result_status``pg_connection_status

Opmerking: > This function used to be called . pg_errormessage

connection

A containing the last error message on the given . string``connection

Voorbeeld: example

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

  // Query that fails
  $res = pg_query($dbconn, "select * from doesnotexist");
  
  echo pg_last_error($dbconn);
?>

pg_result_error``pg_result_error_field