有没有办法打印 mysqli->execute() 所做的实际查询?
我有一个像这样执行的复杂查询:
I have a complex query that gets executed like this:
if ($stmt = $dbi->prepare($pt_query)) {
$stmt->bind_param('ssssssssi', $snome,$scognome,$ssocieta,$svia,$slocalita,$sprovincia,$scap,$stelefono,$sfax,$uid);
$stmt->execute();
echo $dbi->error;
$stmt->close();
} else {
printf("Error -> %s
", $dbi->error);
}
这件事失败了，没有任何错误，它根本没有更新数据库.由于在此之前有大量数据需要处理，我想知道是否有任何方法可以显示 mysqli 正在执行的实际查询，以便了解问题出在哪里.
This thing is failing without any error, it simply doesn't update the database. Since there is a ton of data that gets treated before this thing I would like to know if there is any way to show the actual query that mysqli is executing in order to understand where the problem is.
谢谢.
推荐答案
如果你的语句失败，你应该检查 $stmt->error(而不是 $dbi->错误).至于获取查询的实际文本:这是不可能的.使用准备好的语句时，库使用了一种特殊协议，该协议不会为每个 ->execute() 调用生成实际的查询字符串.
If your statement is failing, you should check $stmt->error (as opposed to $dbi->error). As far as getting the actual text of the query: it's not possible. When using prepared statements, the library is using a special protocol that doesn't generate an actual query string for each ->execute() call.
相关文章