类 mysqli_result 的对象无法转换为字符串

2022-01-30 00:00:00 php mysqli

我收到错误:

mysqli_result 类的对象无法转换为字符串

Object of class mysqli_result could not be converted to string

这是我的代码:

$result = mysqli_query($con, "SELECT classtype FROM learn_users WHERE username='abcde'");

echo "my result <a href='data/$result.php'>My account</a>";

推荐答案

mysqli_query() 方法返回一个对象资源给你的 $result 变量,而不是一个字符串.

The mysqli_query() method returns an object resource to your $result variable, not a string.

您需要循环它然后访问记录.您只是不能直接将它用作您的 $result 变量.

You need to loop it up and then access the records. You just can't directly use it as your $result variable.

while ($row = $result->fetch_assoc()) {
    echo $row['classtype']."<br>";
}

相关文章