PDO::exec
Prepares and executes an SQL statement in a single function call, returning the number of rows affected by the statement.
Syntax
int PDO::exec ($statement)
Parameters
$statement: A string containing the SQL statement to execute.
Return Value
An integer reporting the number of rows affected.
Remarks
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.
Example
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;
?>