PHP: PDOStatement::execute

Description

bool PDOStatement::execute ( [array input_parameters] )

警告

本函数是实验性的。本函数的行为，包括函数名称以及其它任何关于本函数的文档可能会在没有通知的情况下随 PHP 以后的发布而改变。使用本函数风险自担。

Execute the prepared statement. If the prepared statement included parameter markers, you must either:

call PDOStatement::bindParam() to bind PHP variables to the parameter markers: bound variables pass their value as input and receive the output value, if any, of their associated parameter markers
or pass an array of input-only parameter values

例子 1. Execute a prepared statement with bound variables


<?php

/* Execute a prepared statement by binding PHP variables */

$calories = 150;

$colour = 'red';

$sth = $dbh->prepare('SELECT name, colour, calories

    FROM fruit

    WHERE calories < :calories AND colour = :colour');

$sth->bindParam(':calories', $calories, PDO_PARAM_INT);

$sth->bindParam(':colour', $colour, PDO_PARAM_STR, 12);

$sth->execute();

?>

例子 2. Execute a prepared statement with an array of insert values


<?php

/* Execute a prepared statement by passing an array of insert values */

$calories = 150;

$colour = 'red';

$sth = $dbh->prepare('SELECT name, colour, calories

    FROM fruit

    WHERE calories < :calories AND colour = :colour');

$sth->bindParam(':calories', $calories, PDO_PARAM_INT);

$sth->bindParam(':colour', $colour, PDO_PARAM_STR, 12);

$sth->execute(array(':calories' => $calories, ':colour' => $colour));

?>

例子 3. Execute a prepared statement with question mark placeholders


<?php

/* Execute a prepared statement by binding PHP variables */

$calories = 150;

$colour = 'red';

$sth = $dbh->prepare('SELECT name, colour, calories

    FROM fruit

    WHERE calories < ? AND colour = ?');

$sth->bindParam(1, $calories, PDO_PARAM_INT);

$sth->bindParam(2, $colour, PDO_PARAM_STR, 12);

$sth->execute();

?>


	downloads \| documentation \| faq \| getting help \| mailing lists \| reporting bugs \| php.net sites \| links \| my php.net

search for in the