PHP. Руководство по PHP. 2005

PDOStatement::bindColumn

Пред.

След.

PDOStatement::bindColumn

(no version information, might be only in CVS)PDOStatement::bindColumn --

Bind a column to a PHP variable

Описание

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

Внимание

-Эта функция является ЭКСПЕРИМЕНТАЛЬНОЙ.

Поведение этой функции, ее имя и относящаяся к ней документация

могут измениться в последующих версиях PHP без уведомления.

Используйте эту функцию на свой страх и риск.

PDOStatement::bindColumn() arranges to have a

particular variable bound to a given column in the result-set from a

query. Each call to PDOStatement::fetch() or

PDOStatement::fetchAll() will update all the variables

that are bound to columns.

Замечание:

Since information about the columns is not always available to PDO until

the statement is executed, portable applications should call this

function after PDO::execute().

Список параметров

column

Number of the column (1-indexed) or name of the column in the result set.

If using the column name, be aware that the name should match the

case of the column, as returned by the driver.

param

Name of the PHP variable to which the column will be bound.

type

Data type of the parameter, specified by the PDO_PARAM_* constants.

Примеры

Пример 1. Binding result set output to PHP variables

Binding columns in the result set to PHP variables is an effective

way to make the data contained in each row immediately available to

your application. The following example demonstrates how PDO allows

you to bind and retrieve columns with a variety of options and with

intelligent defaults.


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

/* Bind by column number */
$stmt->bindColumn(1, $name);
$stmt->bindColumn(2, $colour);

/* Bind by column name */
$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

Смотрите также

PDOStatement::execute()

PDOStatement::fetch()

PDOStatement::fetchAll()

PDOStatement::fetchColumn()

PDO::setAttribute

PDOStatement::bindParam

Отвечу на любые вопросы. С уважением, Дмитрий Владимирович.

Ваше письмо	×