动态更改PDO语句中的列名 [英] Dynamically change column name in PDO statement
问题描述
是否可以在准备好的MySQL语句中将列名作为参数传递?请看以下示例:
Is it possible pass a column name as parameter in a prepared MySQL statement? Take the following example:
UPDATE Images
SET :placement = :imageURL
WHERE ID = :titleID;
PDO在每个参数周围添加'
,因此上方的中线变为:
PDO adds '
around each parameter, so the middle line above becomes:
SET 'Homepage' = '1.jpg'
哪个MySQL不喜欢.有没有一种方法可以在PDO语句中包含字段名的参数并接受它们?
Which MySQL doesn't like. Is there a way to include parameters for fieldnames in PDO statements and have them accepted?
否则,我猜我将不得不编写一些不同的PDO语句,这取决于所选择的内容(?).
Otherwise I guess I'll have to write several different PDO statements, depending on what's been chosen(?).
推荐答案
您将需要执行以下操作:
You would need to do something like this:
$column = 'someColumn';
$stmt = $db->prepare("UPDATE tableName SET {$column} = :columnValue WHERE ID = :recordId");
参数化占位符仅用于值.
Parameterized placeholders are only for values.
我建议您阅读问题上发表的@YourCommonSense评论.
I would suggest you read the comment @YourCommonSense posted on your question.
这篇关于动态更改PDO语句中的列名的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!