pdostatement.errorinfo(3) [php man page]

PDOSTATEMENT.ERRORINFO(3)						 1						 PDOSTATEMENT.ERRORINFO(3)

PDOStatement::errorInfo - Fetch extended error information associated with the last operation on the statement handle

SYNOPSIS

       public array PDOStatement::errorInfo (void  )

DESCRIPTION

RETURN VALUES

       PDOStatement.errorInfo(3) returns an array of error information about the last operation performed by this statement handle. The array con-
       sists of the following fields:

       +--------+---------------------------------------------------+
       |Element |						    |
       |	|						    |
       |	|		     Information		    |
       |	|						    |
       +--------+---------------------------------------------------+
       |   0	|						    |
       |	|						    |
       |	| SQLSTATE error code (a five  characters  alphanu- |
       |	| meric  identifier  defined  in the ANSI SQL stan- |
       |	| dard).					    |
       |	|						    |
       |   1	|						    |
       |	|						    |
       |	|	     Driver specific error code.	    |
       |	|						    |
       |   2	|						    |
       |	|						    |
       |	|	   Driver specific error message.	    |
       |	|						    |
       +--------+---------------------------------------------------+
EXAMPLES

       Example #1

	      Displaying errorInfo() fields for a PDO_ODBC connection to a DB2 database

	      <?php
	      /* Provoke an error -- the BONES table does not exist */
	      $sth = $dbh->prepare('SELECT skull FROM bones');
	      $sth->execute();

	      echo "
PDOStatement::errorInfo():
";
	      $arr = $sth->errorInfo();
	      print_r($arr);
	      ?>

	      The above example will output:

	      PDOStatement::errorInfo():
	      Array
	      (
		  [0] => 42S02
		  [1] => -204
		  [2] => [IBM][CLI Driver][DB2/LINUX] SQL0204N	"DANIELS.BONES" is an undefined name.  SQLSTATE=42704
	      )

SEE ALSO

       PDO.errorCode(3), PDO.errorInfo(3), PDOStatement.errorCode(3).

PHP Documentation Group 												 PDOSTATEMENT.ERRORINFO(3)

PDOSTATEMENT(3) 							 1							   PDOSTATEMENT(3)

The PDOStatement class

INTRODUCTION

	Represents a prepared statement and, after the statement is executed, an associated result set.

CLASS SYNOPSIS

       PDOStatement

       PDOStatementTraversable

       Properties

       o readonly string$queryString

       Methods

       o public bool PDOStatement::bindColumn (mixed  $column, mixed  &$param, [int  $type], [int  $maxlen], [mixed  $driverdata])

       o public  bool  PDOStatement::bindParam	(mixed	 $parameter, mixed  &$variable, [int  $data_type = PDO::PARAM_STR], [int  $length], [mixed
	 $driver_options])

       o public bool PDOStatement::bindValue (mixed  $parameter, mixed	$value, [int  $data_type = PDO::PARAM_STR])

       o public bool PDOStatement::closeCursor (void  )

       o public int PDOStatement::columnCount (void  )

       o public void PDOStatement::debugDumpParams (void  )

       o public string PDOStatement::errorCode (void  )

       o public array PDOStatement::errorInfo (void  )

       o public bool PDOStatement::execute ([array  $input_parameters])

       o public mixed PDOStatement::fetch ([int  $fetch_style], [int  $cursor_orientation = PDO::FETCH_ORI_NEXT], [int	$cursor_offset])

       o public array PDOStatement::fetchAll ([int  $fetch_style], [mixed  $fetch_argument], [array  $ctor_args = array()])

       o public mixed PDOStatement::fetchColumn ([int  $column_number])

       o public mixed PDOStatement::fetchObject ([string  $class_name = "stdClass"], [array  $ctor_args])

       o public mixed PDOStatement::getAttribute (int  $attribute)

       o public array PDOStatement::getColumnMeta (int	$column)

       o public bool PDOStatement::nextRowset (void  )

       o public int PDOStatement::rowCount (void  )

       o public bool PDOStatement::setAttribute (int  $attribute, mixed  $value)

       o public bool PDOStatement::setFetchMode (int  $mode)

PROPERTIES

	      o $queryString
		- Used query string.

PHP Documentation Group 													   PDOSTATEMENT(3)