$mysqli_stmt->bind_result($id, $username, $age)

<?php
header("Content-type:text/html;charset=utf-8");
$mysqli = new mysqli('localhost', 'root', '', 'test');
if ($mysqli->errno) {
    die('Connect Error ' . $mysqli->error);
}
$mysqli->set_charset('UTF8');
$sql = "SELECT id,username,age FROM user WHERE id>=?";
$mysqli_stmt = $mysqli->prepare($sql);
$id = 5;
$mysqli_stmt->bind_param('i', $id);
if ($mysqli_stmt->execute()) {
    //bind_result 绑定结果集中的值到变量
    $mysqli_stmt->bind_result($id, $username, $age);
    //遍历结果集
    while ($mysqli_stmt->fetch()) {
        echo '编号: ' . $id, '<br/>';
        echo '用户名: ' . $username, '<br/>';
        echo '年龄: ' . $age, '<br/>';
        echo "<hr/>";
    }
}
$mysqli_stmt->free_result();
$mysqli_stmt->close();
$mysqli->close();

?>

Paste_Image.png