有没有办法打印 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.

这篇关于有没有办法打印 mysqli->execute() 所做的实际查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！