如何回显MySQLi准备的语句? [英] How to echo a MySQLi prepared statement?

问题描述

此刻，我正在与MySQLi一起玩，试图弄清它们的工作原理.在我目前的项目中，我总是喜欢在编码时回显查询字符串，以确保一切正确，并快速调试我的代码.但是...如何使用准备好的MySQLi语句来做到这一点?

I'm playing around with MySQLi at the moment, trying to figure out how it all works. In my current projects I always like to echo out a query string while coding, just to make sure that everything is correct, and to quickly debug my code. But... how can I do this with a prepared MySQLi statement?

示例:

$id = 1;
$baz = 'something';

if ($stmt = $mysqli->prepare("SELECT foo FROM bar WHERE id=? AND baz=?")) {
  $stmt->bind_param('is',$id,$baz);
  // how to preview this prepared query before acutally executing it?
  // $stmt->execute();
}

我一直在浏览此列表(

I've been going through this list (http://www.php.net/mysqli) but without any luck.

编辑

好吧，如果在MySQLi中无法实现，也许我会坚持这样:

Well, if it's not possible from within MySQLi, maybe I'll stick with something like this:

function preparedQuery($sql,$params) {
  for ($i=0; $i<count($params); $i++) {
    $sql = preg_replace('/\?/',$params[$i],$sql,1);
  }
  return $sql;
}

$id = 1;
$baz = 'something';

$sql = "SELECT foo FROM bar WHERE id=? AND baz=?";

echo preparedQuery($sql,array($id,$baz));

// outputs: SELECT foo FROM bar WHERE id=1 AND baz=something

显然，它离完美还很远，因为它仍然是多余的—我想防止的事情—而且它也没有使我了解MySQLi对数据进行的处理.但是我想我可以通过这种方式快速查看是否所有数据都存在并且放置在正确的位置，与手动将变量放入查询中相比，这可以节省一些时间.许多变种人可能会感到痛苦.

Far from perfect obviously, since it's still pretty redundant — something I wanted to prevent — and it also doesn't give me an idea as to what's being done with the data by MySQLi. But I guess this way I can quickly see if all the data is present and in the right place, and it'll save me some time compared to fitting in the variables manually into the query — that can be a pain with many vars.

推荐答案

我不认为您可以-至少不是您希望的那样.您要么自己构建查询字符串并执行(即不使用语句)，要么查找或创建支持该功能的包装器.我使用的是 Zend_Db ，这就是我的做法:

I don't think you can - at least not in the way that you were hoping for. You would either have to build the query string yourself and execute it (ie without using a statement), or seek out or create a wrapper that supports that functionality. The one I use is Zend_Db, and this is how I would do it:

$id = 5;
$baz = 'shazam';
$select = $db->select()->from('bar','foo')
                       ->where('id = ?', $id)
                       ->where('baz = ?', $baz); // Zend_Db_Select will properly quote stuff for you
print_r($select->__toString()); // prints SELECT `bar`.`foo` FROM `bar` WHERE (id = 5) AND (baz = 'shazam')

这篇关于如何回显MySQLi准备的语句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！