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

mysqli_stmt_bind_result

(PHP 5)mysqli_stmt_bind_result

(no version information, might be only in CVS)stmt->bind_result -- Binds variables to a prepared statement for result storage

Description

Procedural style:bool mysqli_stmt_bind_result (mysqli_stmt stmt, mixed &var1 [, mixed &...])

Object oriented style (method):class mysqli_stmt {

bool bind_result (mixed &var1 [, mixed &...])

}

mysqli_stmt_bind_result() is used to associate (bind) columns in the result

set to variables. When mysqli_stmt_fetch() is called to fetch data, the MySQL

client/server protocol places the data for the bound columns into the specified variables

var1,....

Замечание:

Note that all columns must be bound prior to calling mysqli_stmt_fetch().

Depending on column types bound variables can silently change to the corresponding PHP type.

A column can be bound or rebound at any time, even after a result set has been partially retrieved.

The new binding takes effect the next time mysqli_stmt_fetch() is called.

Примеры

Пример 1. Object oriented style


<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

if (mysqli_connect_errno()){
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

/* prepare statement */
if ($stmt = $mysqli->prepare("SELECT Code, Name FROM Country ORDER BY Name LIMIT 5")){
$stmt->execute();

/* bind variables to prepared statement */
$stmt->bind_result($col1, $col2);

/* fetch values */
while ($stmt->fetch()){
printf("%s %s\n", $col1, $col2);
}

/* close statement */
$stmt->close();
}
/* close connection */
$mysqli->close();

?>

Пример 2. Procedural style


<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

/* check connection */
if (!$link){
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

/* prepare statement */
if ($stmt = mysqli_prepare($link, "SELECT Code, Name FROM Country ORDER BY Name LIMIT 5")){
mysqli_stmt_execute($stmt);

/* bind variables to prepared statement */
mysqli_stmt_bind_result($stmt, $col1, $col2);

/* fetch values */
while (mysqli_stmt_fetch($stmt)){
printf("%s %s\n", $col1, $col2);
}

/* close statement */
mysqli_stmt_close($stmt);
}

/* close connection */
mysqli_close($link);
?>

Результат выполнения данного примера:

AFG Afghanistan

ALB Albania

DZA Algeria

ASM American Samoa

AND Andorra

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

mysqli_stmt_bind_result

Description

Возвращаемые значения

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

Примеры

Ваше письмо	×