php - PDO "Invalid parameter number: parameter was not defined"但它是

Question

基本上我正在做的是一个用户类，它在构造函数中执行 MySQL 查询来检索所有用户数据并存储它，如下所示:

public function __construct($data, $type = 'id')
{
    $this->details = Beam::$db->row("SELECT * FROM users WHERE $type = :param", ['param' => $data]);
    if(!empty($this->details)) $this->exists = true;
}

这是 row() 方法:

public function row($query, $params = null, $fetchmode = PDO::FETCH_ASSOC)
{
    $this->init($query, $params);
    return $this->statementQuery->fetch($fetchmode);
}

还有init()，其中绑定(bind)参数并执行查询:

public function init($query, $parameters = '')
    {
        try {
                $this->statementQuery = $this->pdo->prepare($query);

                if(!empty($parameters))
                {
                    foreach($parameters as $key => $value)
                    {
                        $this->bind($key, $value);
                    }
                }

                if(!empty($this->parameters))
                {
                    foreach($this->parameters as $key => &$value)
                    {
                        $this->statementQuery->bindParam($key, $value);
                    }
                }

                $this->success = $this->statementQuery->execute();

            }

        catch(PDOException $e)
        {
            throw new SystemException($e->getMessage() . ' in query: ' . $query, (int) $e->getCode());
        }

        $this->parameters = array();
    }

它应该可以工作，我已经多次测试了所有内容，并在各处使用dies()进行了调试，但似乎我多次实例化该类，就会发生错误。它在我的所有代码中被多次调用。我有什么遗漏的吗？

错误:

SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in query: SELECT * FROM users WHERE id = :param

我还尝试通过 ::debugDumpParams() 调试打印 PDO 中设置的所有参数，所有参数都没有问题，我什至 var_dump $this->statementQuery->fetch($fetchmode) 来自 row() 方法，它返回应有的所有内容...

PS:之后我使用此方法绑定(bind)数组 ['param' => $data]:

    public function bind($param, $value)
    {
        $this->parameters[':' . $param] = $value;
    }

我从哪里调用该类的一些示例:

登录方法。当用户登录时调用。它失败了。

public static function login($user, $password)
    {
        $user = new User($user, Beam::$con->auth['type']);

            if($user->exists == true)
            {
                $user_ip       = $_SERVER['REMOTE_ADDR'];
                $user_browser  = $_SERVER['HTTP_USER_AGENT'];
                $user_id       = $user->details["id"];
                $username      = $user->details["username"];
                $user_mail     = $user->details["mail"];
                $user_password = $user->details["password"];

                if(self::verify($password, $user_password))
                {
                    $_SESSION['user_id']       = $user_id;
                    $_SESSION['username']      = $username;
                    $_SESSION['user_mail']     = $user_mail;
                    $_SESSION['user_checksum'] = hash('sha512', $user_password . $user_ip . $user_browser);

                    Beam::$db->bind("l", time());
                    Beam::$db->bind("u", $user_id);
                    Beam::$db->query("UPDATE user_info SET login_timestamp = :l WHERE user_id = :u");

                return true;
            }
            else
            {
                return false;
            }
        }
        else
        {
            return false;
        }
    }

此函数检查用户是否已登录。几乎在每个文件中都会仅针对经过身份验证的用户调用它。

public static function status()
    {
        if(isset($_SESSION["user_id"], $_SESSION["username"], $_SESSION["user_checksum"]))
        {
            $user = new User($_SESSION["user_id"], "id");

            if($user->exists)
            {
                $user_id          = $_SESSION['user_id'];
                $user_checksum    = $_SESSION['user_checksum'];
                $username         = $_SESSION['username'];
                $user_ip          = $_SERVER['REMOTE_ADDR'];
                $user_browser     = $_SERVER['HTTP_USER_AGENT'];
                $user_password    = $user->details["password"];

                switch($user_checksum)
                {
                    default:
                    $checksum_verify = hash('sha512', $user_password . $user_ip . $user_browser);
                    break;

                    case "facebook":
                    $checksum_verify = "facebook";
                    break;
                }

                if($checksum_verify == $user_checksum)
                {
                    return true;
                }
            }
            else
            {
                return false;
            }
        }
        else
        {
            return false;
        }
    }

Answer 1

您需要对查询中使用的参数使用相同的名称。在本例中，您使用了“:param”，因此这就是您在传递参数数组时需要使用的内容。

改变

['param' => $data]

至

[':param' => $data]

它应该可以工作。