[!INCLUDEDriver_PHP_Download]

Prepares and executes an SQL statement in a single function call, returning the number of rows affected by the statement.

  
int PDO::exec ($statement)  

$statement: A string containing the SQL statement to execute.

An integer reporting the number of rows affected.

If $statement contains multiple SQL statements, the count of affected rows is reported for the last statement only.

PDO::exec does not return results for a SELECT statement.

The following attributes affect the behavior of PDO::exec:

• PDO::ATTR_DEFAULT_FETCH_MODE

• PDO::SQLSRV_ATTR_ENCODING

• PDO::SQLSRV_ATTR_QUERY_TIMEOUT

See PDO::setAttribute for more information.

Support for PDO was added in version 2.0 of the [!INCLUDEssDriverPHP].

This example deletes rows in Table1 that have 'xxxyy' in col1. The example then reports how many rows were deleted.

<?php  
   $c = new PDO( "sqlsrv:server=(local)");  
  
   $c->exec("use Test");  
   $ret = $c->exec("delete from Table1 where col1 = 'xxxyy'");  
   echo $ret;  
?>  

PDO Class
PDO