$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
