PDO::exec --
Execute an SQL statement and return the number of affected rows
Syntax
long PDO::exec ( string statement )
Warning
This function is
EXPERIMENTAL. The behaviour of this function, the
name of this function, and anything else documented about this
function may change without notice in a future release of PHP.
Use this function at your own risk.
PDO::exec() prepares and executes an SQL statement in
a single function call, returning the number of rows affected by the
statement.
PDO::exec() 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().
For a SELECT statement that you need to issue multiple times, prepare
a PDOStatement object with PDO::prepare() and issue
the statement with PDOStatement::execute().
Parameters
statement
The SQL statement to prepare and execute.
Return Values
PDO::exec() returns the number of rows that were modified
or deleted by the SQL statement you issued. If no rows were affected,
PDO::exec() returns 0.
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("Return number of rows that were deleted:\n"); print("Deleted $count rows.\n"); ?>
The above example will output:
Return number of rows that were deleted:
Deleted 1 rows.
See Also
PDO::prepare()
PDO::query()
PDOStatement::execute()
Php pdo exec Function syntax tag
pdo exec php code on this is provided for your study purpose, it will guide you to know how create and design a website using php. use it to practice and train your self online
Php pdo exec syntax tutorial
php tutorial guide and code design are for easy learning and programming. The code practice section provided at the top is for practising of this syntax. Use the code section up to practice your php programming online. Learning php is very easy, all you need is to use the examples on this site and practice them to perfect your skills.