php - 按字符串选择表(FROM)

Question

是否可以在 SELECT FROM sql 命令中使用动态值？

Database->prepare("SELECT bomb FROM ? WHERE id=?")
    ->execute($strTable,$strID);

结果:

Fatal error: Uncaught exception Exception with message Query error: 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...

Answer 1

没有。表名不能作为查询的参数。您需要先构建查询字符串，将表名连接起来。