|
Последние активные темы форума |
|
PDO::exec
(no version information, might be only in CVS) PDO::exec --
Execute an SQL statement and return the number of affected rows
Описаниеlong PDO::exec ( string statement ) Внимание |
Эта функция является ЭКСПЕРИМЕНТАЛЬНОЙ.
Поведение этой функции, ее имя и относящаяся к ней документация
могут измениться в последующих версиях PHP без уведомления.
Используйте эту функцию на свой страх и риск. |
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().
Список параметров- statement
The SQL statement to prepare and execute.
Возвращаемые значения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.
Примеры
Пример 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
"
);
?>
|
Результат выполнения данного примера: Return number of rows that were deleted:
Deleted 1 rows. |
|
Смотрите такжеPDO::prepare() | PDO::query() | PDOStatement::execute() |
|