php - 我想打印带参数的 PHP 查询

Question

我有以下代码

$name = 'myname';
$mail = 'my@mail.it';
$qwt = "INSERT INTO `agenz` (`name`, `email`) VALUES (?,?)";
$result = $connessione->prepare($qwt);
$result->bind_param('ss', $name, $mail); 
$result->execute(); 

我要打印查询

"INSERT INTO `agenz` (`name`, `email`) VALUES ('myname','my@mail.it')"

用于创建日志。那么该怎么做呢？

谢谢。

Answer 1

像下面这样尝试 fullQuery:

$name = 'myname';
$mail = 'my@mail.it';
$qwt = "INSERT INTO `agenz` (`name`, `email`) VALUES (?,?)";
$result = $connessione->prepare($qwt);
$result->bind_param('ss', $name, $mail); 
$result->execute(); 

echo $result->fullQuery;

或

$result->debugQuery();
var_dump($result->debugBindedVariables());

如果你想得到错误

var_dump($result->errno);