PDO::exec

 

DownloadDownload PHP Driver

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

  
int PDO::exec ($statement)  

Parameters

$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 Microsoft Drivers for PHP for SQL Server.

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

Community Additions

ADD
Show: