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

Question

这是代码。当我执行它时，它显示错误消息“可捕获的 fatal error :类 mysqli_result 的对象无法转换为字符串”请帮我解决这个问题。

$sql = "SELECT dname FROM bdonor WHERE DID = 2";
$dname = $con->query($sql);
echo $dname;

Answer 1

您正在尝试将类 mysqli_result 转换为字符串(显然它会返回错误)，请尝试此操作..

$sql = "SELECT dname FROM bdonor WHERE DID = 2";
$result= $con->query($sql);
while($row = $result->fetch_array(MYSQLI_ASSOC))
       echo $row['dname '].'<br />'; // here is the output display line by line