带PHP的PDO语句的MySQL

Question

What is wrong with the following code, because my data is missing, and there are returned records :

     $db_stmt = new PDOStatement();
    $db_stmt = $this->db->prepare("SELECT id_translation AS ID, content AS Label FROM ?");        
    $language = "language_translation_" . $request->request_object->language; 
    $db_stmt->bindParam(1, $language);        
    $db_stmt->execute();        
    while ($obj = $db_stmt->fetchObject()){
        $response->response_list[] = $obj;
        unset($obj);
    }

Edit : I am creating a web service to get some data from a mysql database. I test my service with a rest client. (I don't need to echo !!!)

Answer 1

i think you cannot bind a parameter to a table name. please try something like

$db_stmt = $this->db->prepare("SELECT id_translation AS ID, content AS Label FROM `$language`");

Hope this helps.