PDO::exec – Execute an SQL Statement and Return the Number of Affected Rows

PDO::exec is a PHP method that executes a given SQL statement in a single function call and returns the number of rows affected by the operation.

Signature: int PDO::exec(string $statement) Parameter: $statement – the SQL statement to be prepared and executed.

Return value: The number of rows modified or deleted by the SQL statement; if no rows are affected, PDO::exec returns 0.

Example:

<?php
$dbh = new PDO('odbc:sample','db2inst1','ibmdb2');
/* Delete all rows from the FRUIT table where colour is 'red' */
$count = $dbh->exec("DELETE FROM fruit WHERE colour = 'red'");
/* Output the number of deleted rows */
print("Deleted $count rows.
");
?>