在mysqli中存储和遍历查询结果

我已经解决了这个问题：

$query = "SELECt name FROM usertable WHERe id = ?";$stmt = $mysqli->prepare($query);$stmt->bind_param('i', $id);$id= $_GET['id'];$stmt->execute();$result = $stmt->get_result();$stmt->free_result();$stmt->close();while ($row = $result->fetch_array(MYSQLI_NUM)) {    echo $row[0]." ";}

只需使用

get_result()

fetch_array()