无法将类mysqli_result的对象转换为字符串。-Objectofclassmysqli_resultcouldnotbeconvertedtostring

6  

The problem is that $uname is an object, not a string. You need to call one of $uname's methods to access the data.

问题是$uname是一个对象，而不是字符串。您需要调用$uname的一个方法来访问数据。

    function update_confirm_field($code) {

    $uname = $this->conn->query("SELECT usr FROM tz_members WHERE 
                     cOnfirm='".$code."'");

    while ($row = $uname->fetch_assoc()) { 

    $this->conn->query("UPDATE tz_members SET cOnfirm='yes' WHERE 
                     usr='".$row["usr"]."'");

    }

}

that should do it (or one of the above solutions).

应该这样做(或者上面的一个解决方案)。

1  

$uname returned by your first query is a mysql_result object, not a string. you must fetch the data from that result in order to use it in your second query.

您的第一个查询返回的$uname是一个mysql_result对象，而不是字符串。您必须从该结果中获取数据，以便在第二个查询中使用它。

while ($row = mysql_fetch_assoc($result)) {
    echo $row["usr"];
}

0  

The query method returns a pointer/object of the query result, it does not just directly dump the response. You need to do something like list($uname) = $uname->fetch_row;

查询方法返回查询结果的指针/对象，它不直接转储响应。您需要做一些类似列表($uname) = $uname->fetch_row;

0  

$updateQuery = "UPDATE tz_members SET cOnfirm='yes' WHERE usr= (SELECT usr FROM tz_members WHERE cOnfirm='".$code."')";

// Get name and update in the same query
$this->conn->query($updateQuery);