获取带有绑定参数的 PDO 查询字符串而不执行它

问题描述

是否可以在不先执行的情况下从带有绑定参数的 PDO 对象中获取查询字符串?我有类似于以下的代码(其中 $dbc 是 PDO 对象):

Is it possible to get a query string from a PDO object with bound parameters without executing it first? I have code similar to the following (where $dbc is the PDO object):

$query = 'SELECT * FROM users WHERE username = ?';
$result = $dbc->prepare($query);
$username = 'bob';
$result->bindParam(1, $username);
echo $result->queryString;

目前，这将输出一条 SQL 语句，例如:SELECT * FROM users WHERE username = ?".但是，我希望包含绑定参数，使其看起来像:'SELECT * FROM users WHERE username = 'bob'".有没有办法在不执行它或通过某些东西用参数替换问号的情况下做到这一点像 preg_replace?

Currently, this will echo out a SQL statement like: "SELECT * FROM users WHERE username = ?". However, I would like to have the bound parameter included so that it looks like: 'SELECT * FROM users WHERE username = 'bob'". Is there a way to do that without executing it or replacing the question marks with the parameters through something like preg_replace?

推荐答案

简而言之:没有.请参阅从 PDO 准备好的语句中获取原始 SQL 查询字符串

In short: no. See Getting raw SQL query string from PDO prepared statements

如果您只想模拟它，请尝试:

If you want to just emulate it, try:

echo preg_replace('?', $username, $result->queryString);

这篇关于获取带有绑定参数的 PDO 查询字符串而不执行它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！