有什么方法可以打印mysqli-> execute()进行的实际查询? [英] Is there any way to print the actual query that mysqli->execute() makes?

问题描述

我有一个复杂的查询，其执行方式如下:

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\n", $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->error).至于获取查询的实际文本:这是不可能的.在使用准备好的语句时，该库使用的是一种特殊的协议，该协议不会为每个->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()进行的实际查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！