|
|
 |
PDO::prepare (no version information, might be only in CVS) PDO::prepare --
Prepares a statement for execution and returns a statement object
说明PDOStatement PDO::prepare ( string statement [, array driver_options] ) | 警告 | 本函数是实验性的。本函数的行为，包括函数名称以及其它任何关于本函数的文档可能会在没有通知的情况下随
PHP 以后的发布而改变。使用本函数风险自担。 |
Prepares an SQL statement to be executed by the
PDOStatement::execute() method. The SQL statement can
contain zero or more named (:name) or question mark (?) parameter markers
for which real values will be substituted when the statement is executed.
You cannot use named and question mark parameter markers within the same
SQL statement.
Calling PDO::prepare() and PDOStatement::execute()
for statements that will be issued multiple times with different parameter
values optimizes the performance of your application and helps prevent SQL
injection attacks.
参数
- statement
This must be a valid SQL statement for the target database server.
- driver_options
This array holds one or more key=>value pairs to set
attribute values for the PDOStatement object that this method
returns. You would most commonly use this to set the
PDO_ATTR_CURSOR value to
PDO_CURSOR_SCROLL to request a scrollable cursor.
返回值
If the database server successfully prepares the statement,
PDO::prepare() returns a PDOStatement object.
例
例子 1. Prepare an SQL statement with named parameters |
<?php
$sql = 'SELECT name, colour, calories
FROM fruit
WHERE calories < :calories AND colour = :colour';
$sth = $dbh->prepare($sql, array(PDO_ATTR_CURSOR, PDO_CURSOR_FWDONLY));
$sth->execute(array(':calories' => 150, ':colour' => 'red'));
$red = $sth->fetchAll();
$sth->execute(array(':calories' => 175, ':colour' => 'yellow'));
$yellow = $sth->fetchAll();
?>
|
|
例子 2. Prepare an SQL statement with question mark parameters |
<?php
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < ? AND colour = ?');
$sth->execute(array(150, 'red'));
$red = $sth->fetchAll();
$sth->execute(array(175, 'yellow'));
$yellow = $sth->fetchAll();
?>
|
|
参见
| PDO::exec() | | PDO::query() | | PDOStatement::execute() |
| |
PDO::lastInsertId