php - 使用 PHP printf 生成 sql 查询

Question

我尝试使用 printf 生成一个查询以在 MySQL 上执行:

$query = printf("INSERT INTO author VALUES (null,'%s','%s','%s',null,null,null,null,null)", 
    $command['pseudonym'],$command['name'],$command['surname']);
$result = $connection->query($query);

但结果是这个奇怪的错误:

INSERT INTO author VALUES (null,'pseudo','nome','cognome',null,null,null,null,null)
Database access failed: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version 
for the right syntax to use near '83' at line 1

生成的查询在 PhpMyadmin 中完美运行。我还尝试了一个没有 printf 的代码版本并且它有效:

$pseudo = $command['pseudonym'];
$name = $command['name'];
$surname = $command['surname'];
$query = "INSERT INTO author VALUES (null,'$pseudo','$name','$surname',null,null,null,null,null)";

使用printf的版本有什么问题？

Answer 1

你正在寻找 sprintf 因为你想存储查询字符串供以后使用。