php - SQLSTATE[42000] : Syntax error or access violation: 1064 PDO

Question

我每次使用我的 Mysql PDO 类时都会得到这个:

SQLSTATE[42000]: Syntax error or access violation: 1064 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 '? WHERE ?' at line 1

代码如下:

function mysql_execute_safe_search($table, $where, $query){
    global $db;

    try{
        $preparedQuery = $db->prepare("SELECT * FROM ? WHERE ?");

        $preparedQuery->execute([$table, $where, $query]);
        return $preparedQuery->fetchAll(PDO::FETCH_ASSOC);
    } 

    catch(PDOException $Exception){

        echo $Exception->getMessage();

        return;
    }
}

我是这样执行的:

$search_query = mysql_execute_safe_search("people", "name", "Nathan");

Answer 1

不能绑定(bind)表名:

$preparedQuery = $db->prepare("SELECT * FROM yourtable WHERE ?");