PDOStatement::bindColumn

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.1.0)

PDOStatement::bindColumn — 锟斤拷一锟叫碉拷一锟斤拷 PHP 锟斤拷锟斤拷

说锟斤拷

PDOStatement::bindColumn ( mixed $column , mixed &$param [, int $type [, int $maxlen [, mixed $driverdata ]]] ) : bool

锟斤拷锟斤拷一锟斤拷锟截讹拷锟侥憋拷锟斤拷锟襟定碉拷一锟斤拷锟斤拷询锟斤拷锟斤拷锟斤拷懈锟斤拷锟斤拷锟斤拷小锟矫匡拷蔚锟斤拷锟� PDOStatement::fetch() 锟斤拷 PDOStatement::fetchAll() 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫绑定碉拷锟叫的憋拷锟斤拷锟斤拷

Note:

锟斤拷锟斤拷锟街达拷锟角� PDO 锟叫癸拷锟叫碉拷锟斤拷息锟斤拷锟斤拷锟斤拷锟角匡拷锟矫ｏ拷锟斤拷锟斤拷植锟斤拷应锟斤拷应锟斤拷 PDOStatement::execute() 之锟斤拷 锟斤拷锟矫此猴拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷

锟斤拷锟角ｏ拷锟斤拷使锟斤拷 PgSQL 锟斤拷锟斤拷 时锟斤拷要锟斤拷锟杰帮拷一锟斤拷 LOB 锟斤拷锟斤拷为锟斤拷锟斤拷应锟矫筹拷锟斤拷锟斤拷锟斤拷诘锟斤拷锟� PDOStatement::execute() 之前 锟斤拷锟矫此凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 OID 锟斤拷为一锟斤拷锟斤拷锟斤拷锟斤拷锟截★拷

锟斤拷锟斤拷

column

锟斤拷锟斤拷锟斤拷械锟斤拷泻牛锟斤拷锟�1锟斤拷始锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟绞癸拷锟斤拷锟斤拷锟斤拷锟阶拷锟斤拷锟斤拷锟接︼拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷氐锟斤拷锟斤拷锟斤拷锟叫⌒达拷锟斤拷锟揭伙拷隆锟�

param

锟斤拷锟襟定碉拷锟叫碉拷 PHP 锟斤拷锟斤拷锟斤拷锟斤拷

type

通锟斤拷 PDO::PARAM_* 锟斤拷锟斤拷指锟斤拷锟侥诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵★拷

maxlen

预锟斤拷锟斤拷锟斤拷示锟斤拷

driverdata

锟斤拷锟斤拷锟侥匡拷选锟斤拷锟斤拷锟斤拷

锟斤拷锟斤拷值

锟缴癸拷时锟斤拷锟斤拷 TRUE锟斤拷 锟斤拷锟斤拷锟斤拷失锟斤拷时锟斤拷锟斤拷 FALSE锟斤拷

锟斤拷锟斤拷

Example #1 锟窖斤拷锟斤拷锟斤拷锟斤拷锟襟定碉拷 PHP 锟斤拷锟斤拷

锟襟定斤拷锟斤拷锟斤拷械锟斤拷械锟絇HP锟斤拷锟斤拷锟斤拷一锟斤拷使每锟叫帮拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷应锟矫筹拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫碉拷锟斤拷效锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟绞撅拷锟� PDO 锟斤拷锟斤拷锟矫讹拷锟斤拷选锟斤拷锟饺笔≈碉拷蠖ê图锟斤拷锟斤拷小锟�

<?php
function readData($dbh) {
  $sql = 'SELECT name, colour, calories FROM fruit';
  try {
    $stmt = $dbh->prepare($sql);
    $stmt->execute();

    /*  通锟斤拷锟叫号帮拷  */
    $stmt->bindColumn(1, $name);
    $stmt->bindColumn(2, $colour);
    
    /*  通锟斤拷锟斤拷锟斤拷锟斤拷  */
    $stmt->bindColumn('calories', $cals);

    while ($row = $stmt->fetch(PDO::FETCH_BOUND)) {
      $data = $name . "\t" . $colour . "\t" . $cals . "\n";
      print $data;
    }
  }
  catch (PDOException $e) {
    print $e->getMessage();
  }
}
readData($dbh);
?>

锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�

apple   red     150
banana  yellow  175
kiwi    green   75
orange  orange  150
mango   red     200
strawberry      red     25

锟轿硷拷