mysqli_stmt::bind_result

mysqli_stmt_bind_result

(PHP 5, PHP 7)

mysqli_stmt::bind_result -- mysqli_stmt_bind_result — Binds variables to a prepared statement for result storage

说明

面向对象风格

mysqli_stmt::bind_result ( mixed &$var1 [, mixed &$... ] ) : bool

过程化风格

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

Binds 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:

Note that all columns must be bound after mysqli_stmt_execute() and 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.

参数

stmt

仅以过程化样式：由 mysqli_stmt_init() 返回的 statement 标识。

var1

The variable to be bound.

返回值

成功时返回 TRUE， 或者在失败时返回 FALSE。

范例

Example #1 面向对象风格

<?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();

?>

Example #2 过程化风格

<?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 maxdb 函数 binds variables to a prepared statement as parametersphp maxdb 函数 binds variables to a prepared statement for result storagephp mysql xdevapi 函数 bind prepared statement variables as parametersphp 别名和过时的 mysqli 函数 mysqli stmt result metadata 的别名php mysqli stmt used to modify the behavior of a prepared statementphp mysqli stmt binds variables to a prepared statement as parametersphp mysqli stmt binds variables to a prepared statement for result storagephp mysqli stmt closes a prepared statementphp mysqli stmt seeks to an arbitrary row in statement result setphp mysqli stmt fetch results from a prepared statement into the bound variablesphp mysqli stmt frees stored result memory for the given statement handlephp mysqli stmt gets a result set from a prepared statementphp mysqli stmt reads the next result from a multiple queryphp mysqli stmt return the number of rows in statements result setphp mysqli stmt returns the number of parameter for the given statementphp mysqli stmt prepare an sql statement for executionphp mysqli stmt resets a prepared statementphp mysqli stmt returns result set metadata from a prepared statementphp mysqli stmt transfers a result set from a prepared statementphp sqlite3stmt executes a prepared statement and returns a result set object
关注编程学问公众号