有没有办法打印 mysqli->execute() 所做的实际查询?

时间:2023-03-06
本文介绍了有没有办法打印 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() 所做的实际查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

上一篇:mysqli 插入错误不正确的语法 下一篇:如何创建动态 WHERE 子句

相关文章