(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.1.0)
PDOStatement::bindParam — 锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷指锟斤拷锟侥憋拷锟斤拷锟斤拷
$parameter
, mixed &$variable
[, int $data_type = PDO::PARAM_STR
[, int $length
[, mixed $driver_options
]]] ) : bool锟斤拷一锟斤拷PHP锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷预锟斤拷锟斤拷锟絊QL锟斤拷锟斤拷械亩锟接︼拷锟斤拷锟秸嘉伙拷锟斤拷锟斤拷屎锟秸嘉伙拷锟斤拷锟� 锟斤拷同锟斤拷 PDOStatement::bindValue() 锟斤拷锟剿憋拷锟斤拷锟斤拷为锟斤拷锟矫憋拷锟襟定ｏ拷锟斤拷只锟斤拷 PDOStatement::execute() 锟斤拷锟斤拷锟矫碉拷时锟斤拷锟饺★拷锟街碉拷锟�
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷只锟斤拷锟侥凤拷式锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷询锟斤拷一些锟斤拷锟斤拷支锟街碉拷锟矫存储锟斤拷锟教诧拷锟斤拷为锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷荩锟揭恍┲э拷锟斤拷锟轿拷锟斤拷锟�/锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷确锟斤拷锟斤拷锟斤拷锟斤拷纸锟斤拷崭锟斤拷潞锟斤拷锟斤拷锟捷★拷
parameter锟斤拷锟斤拷锟斤拷识锟斤拷锟斤拷锟斤拷锟斤拷使锟斤拷锟斤拷锟斤拷占位锟斤拷锟斤拷预锟斤拷锟斤拷锟斤拷洌︼拷锟斤拷锟斤拷锟� :name 锟斤拷式锟侥诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷使锟斤拷锟绞猴拷占位锟斤拷锟斤拷预锟斤拷锟斤拷锟斤拷洌︼拷锟斤拷锟�1锟斤拷始锟斤拷锟斤拷锟侥诧拷锟斤拷位锟矫★拷
variable锟襟定碉拷 SQL 锟斤拷锟斤拷锟斤拷锟斤拷 PHP 锟斤拷锟斤拷锟斤拷锟斤拷
data_type
使锟斤拷 PDO::PARAM_* 锟斤拷锟斤拷锟斤拷确锟斤拷指锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵★拷要锟斤拷一锟斤拷锟芥储锟斤拷锟斤拷锟叫凤拷锟斤拷一锟斤拷 INOUT 锟斤拷锟斤拷锟斤拷锟斤拷要为 data_type 锟斤拷锟斤拷使锟矫帮拷位锟斤拷锟斤拷锟斤拷锟饺ワ拷锟斤拷锟� PDO::PARAM_INPUT_OUTPUT 位锟斤拷
length锟斤拷锟斤拷锟斤拷锟酵的筹拷锟饺★拷为锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟芥储锟斤拷锟教碉拷 OUT 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷确锟斤拷锟斤拷锟矫此筹拷锟饺★拷
driver_options
锟缴癸拷时锟斤拷锟斤拷 TRUE锟斤拷 锟斤拷锟斤拷锟斤拷失锟斤拷时锟斤拷锟斤拷 FALSE锟斤拷
Example #1 执锟斤拷一锟斤拷使锟斤拷锟斤拷锟斤拷占位锟斤拷锟斤拷预锟斤拷锟斤拷锟斤拷锟�
<?php
/* 通锟斤拷锟襟定碉拷 PHP 锟斤拷锟斤拷执锟斤拷一锟斤拷预锟斤拷锟斤拷锟斤拷锟� */
$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();
?>
Example #2 执锟斤拷一锟斤拷使锟斤拷锟绞猴拷占位锟斤拷锟斤拷预锟斤拷锟斤拷锟斤拷锟�
<?php
/* 通锟斤拷锟襟定碉拷 PHP 锟斤拷锟斤拷执锟斤拷一锟斤拷预锟斤拷锟斤拷锟斤拷锟� */
$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();
?>
Example #3 使锟斤拷 INOUT 锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟芥储锟斤拷锟斤拷
<?php
/* 使锟斤拷 INOUT 锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟芥储锟斤拷锟斤拷 */
$colour = 'red';
$sth = $dbh->prepare('CALL puree_fruit(?)');
$sth->bindParam(1, $colour, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 12);
$sth->execute();
print("After pureeing fruit, the colour is: $colour");
?>