database->stderr

Returns the last database error message in a standard format.  The error number and error message are included.  The SQL statement that caused the error may optionally be included.

Syntax

string stderr ( [ boolean $showSQL ] )

$showSQL

is a flag.  If true then the error message will include the SQL statement that caused the error; otherwise the SQL statement will be omitted.  This parameter is optional and if omitted will default to false.

Examples

Example:

$query = "SELECT * FROM 'bad_table'";
$database->setQuery( $query );
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
  echo $database->stderr();
}

which would output:

DB function failed with error number 1064<br />
<font color="red">You have an error in your SQL syntax
          near ''bad_table'' at line 1 SQL=SELECT * FROM 'bad_table'</font>
 

which would render as:

Please report any errors on this page to the Developer Documentation Forum.