pdo.exec(3) [php man page]

PDO.EXEC(3)								 1							       PDO.EXEC(3)

PDO
::exec - Execute an SQL statement and return the number of affected rows

SYNOPSIS

       public int PDO::exec (string  $statement)

DESCRIPTION

       PDO.exec(3) executes an SQL statement in a single function call, returning the number of rows affected by the statement.

       PDO.exec(3)  does  not return results from a SELECT statement. For a SELECT statement that you only need to issue once during your program,
       consider issuing PDO.query(3). For a statement that you need to issue multiple times, prepare a PDOStatement object with PDO.prepare(3) and
       issue the statement with PDOStatement.execute(3).

PARAMETERS

	      o $statement
		- The SQL statement to prepare and execute.  Data inside the query should be properly escaped.

RETURN VALUES

       PDO.exec(3) returns the number of rows that were modified or deleted by the SQL statement you issued. If no rows were affected, PDO.exec(3)
       returns 0.

       Warning

	      This function may return Boolean FALSE, but may also return a non-Boolean value which evaluates to FALSE. Please read the section on
	      Booleans for more information. Use the === operator for testing the return value of this function.

	The following example incorrectly relies on the return value of PDO.exec(3), wherein a statement that affected 0 rows results in a call to
       die(3):

       <?php
       $db->exec() or die(print_r($db->errorInfo(), true));
       ?>

EXAMPLES

       Example #1

	      Issuing a DELETE statement

	       Count the number of rows deleted by a DELETE statement with no WHERE clause.

	      <?php
	      $dbh = new PDO('odbc:sample', 'db2inst1', 'ibmdb2');

	      /* Delete all rows from the FRUIT table */
	      $count = $dbh->exec("DELETE FROM fruit WHERE colour = 'red'");

	      /* Return number of rows that were deleted */
	      print("Deleted $count rows.
");
	      ?>

	      The above example will output:

	      Deleted 1 rows.

SEE ALSO

       PDO.prepare(3), PDO.query(3), PDOStatement.execute(3).

PHP Documentation Group 													       PDO.EXEC(3)

PDO.ERRORINFO(3)							 1							  PDO.ERRORINFO(3)

PDO
::errorInfo - Fetch extended error information associated with the last operation on the database handle

SYNOPSIS

       public array PDO::errorInfo (void  )

DESCRIPTION

RETURN VALUES

       PDO.errorInfo(3)  returns  an  array of error information about the last operation performed by this database handle. The array consists 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.	    |
       |	|						    |
       +--------+---------------------------------------------------+
       Note

	       If the SQLSTATE error code is not set or there is no driver-specific error, the elements following element 0 will be set to NULL.

       PDO.errorInfo(3) only retrieves error information for operations performed directly on the database handle. If you  create  a  PDOStatement
       object through PDO.prepare(3) or PDO.query(3) and invoke an error on the statement handle, PDO.errorInfo(3) will not reflect the error from
       the statement handle. You must call PDOStatement.errorInfo(3) to return the error information for an operation performed  on  a	particular
       statement handle.

EXAMPLES

       Example #1

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

	      <?php
	      /* Provoke an error -- bogus SQL syntax */
	      $stmt = $dbh->prepare('bogus sql');
	      if (!$stmt) {
		  echo "
PDO::errorInfo():
";
		  print_r($dbh->errorInfo());
	      }
	      ?>

	      The above example will output:

	      PDO::errorInfo():
	      Array
	      (
		  [0] => HY000
		  [1] => 1
		  [2] => near "bogus": syntax error
	      )

SEE ALSO

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

PHP Documentation Group 													  PDO.ERRORINFO(3)