这种错误通常是由于尝试在mysqli_result对象上执行数组操作引起的。要解决这个问题,需要使用mysqli_fetch_array()函数将结果对象转换为数组。以下是一个示例代码,该代码从MySQL数据库中获取数据,将其转换为数组,并循环遍历结果:
$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT id, name, age FROM users";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
// Convert result object to array
$users = mysqli_fetch_all($result, MYSQLI_ASSOC);
// Loop through array
foreach ($users as $user) {
echo "ID: " . $user['id'] . ", Name: " . $user['name'] . ", Age: " . $user['age'] . "
";
}
} else {
echo "No results found";
}
mysqli_close($conn);
下一篇:不断变化的大数据和C#