PHP PDO准备SELECT语句 - PHP PDO Prepared SELECT Statement

PHP PDO Prepared SELECT Statement

本文关键字：语句 SELECT 准备 PDO PHP | 更新日期: 2023-09-27

我试图用php中的PDO做一个准备好的SELECT语句。这是我的声明：

    # named placeholders 
    $STH = $DBH->("SELECT * FROM `highscore_ranked` WHERE DeviceID = :deviceid ORDER BY Points DESC LIMIT 0 , 10");
    $STH->bindValue(':deviceid', $DeviceIDClear);
    # setting the fetch mode
    $STH->setFetchMode(PDO::FETCH_ASSOC);
    $STH->execute();

但我得到了错误：

 PHP Parse error:  syntax error, unexpected '(', expecting T_STRING or T_VARIABLE or '{' or '$'

在这条线上：

 $STH = $DBH->("SELECT * FROM `highscore_ranked` WHERE DeviceID = :deviceid ORDER BY Points DESC LIMIT 0 , 10");

我不知道这条线路出了什么问题。

您忘记了方法的名称！！！！

$STH = $DBH->prepare("SELECT * FROM `highscore_ranked` WHERE DeviceID = :deviceid ORDER BY Points DESC LIMIT 0 , 10");