PDO 参数化查询 - 重用命名占位符?

2021-12-26 00:00:00 php pdo

本质上,我有一个值,我必须在我的 SQL 查询中调用几次.因此,是否可以在语句中重用相同的命名占位符,例如SELECT :Param FROM Table WHERE Column = :Param,然后简单的 bindValue(":Param"),并且有两个 :Params 的值?

In essence, I have a value that I have to call a couple times in my SQL query. Thus, is it possible to reuse the same named placeholder in the statement e.g. SELECT :Param FROM Table WHERE Column = :Param, then simply bindValue(":Param"), and have the value be there for both :Params?

推荐答案

PDO::prepare 指出您不能在准备好的语句中两次使用同名的命名参数标记",所以我想那是不行的.

PDO::prepare states that "you cannot use a named parameter marker of the same name twice in a prepared statement", so I guess that's a no then.

相关文章