正在获取SQLSTATE [HY093]:无效的参数编号:在第12行的E:\ wamp64 \ www \ social \ classes \ db.php中未绑定任何参数 [英] Getting SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in E:\wamp64\www\social\classes\db.php on line 12 error

问题描述

我正在创建一个社交网络的登录页面，但是当我登录时，出现上述错误.我的db.php是(我使用pdo):

I'm making a social network's login page but when I login a get the error above. My db.php is (i use pdo):

<?php
class DB {

    private static function connect() {
        $pdo = new PDO('mysql:host=127.0.0.1;dbname=social;charset=utf8', 'danny', 'password');
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        return $pdo;
    }

    public static function query($query, $params = array()) {
        $statement = self::connect()->prepare($query);
        $statement->execute($params);

        if (explode(' ', $query)[0] == 'SELECT') {
            $data = $statement->fetchAll();
            return $data;
        }
    }

}
?>

从

$user_id = DB::query('SELECT id 
                      FROM users 
                      WHERE email=:email')[0]['id']; 

DB::query('INSERT INTO login_tokens 
            VALUES(\'\', :token, :user_id)',        
        array(':token'=>sha1($token), ':user_id'=>$user_id)); 

推荐答案

您的课程有很多问题.修复它们:

Your class has many issues. to fix them:

class DB {

    protected static $pdo;

    public static function connect() {
        static::$pdo = new PDO('mysql:host=127.0.0.1;dbname=social;charset=utf8', 'danny', 'Dani2034');
        static::$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }

    public static function query($query, $params = array()) {
        $statement = self::$pdo->prepare($query);
        $statement->execute($params);
        return $statement;
    }
}

DB::connect(); // called only once

$user_id = DB::query('SELECT id FROM users WHERE email=?', array($email))->fetchColumn(); 
DB::query('INSERT INTO login_tokens VALUES(null, ?, ?)', array(sha1($token), $user_id)); 

这篇关于正在获取SQLSTATE [HY093]:无效的参数编号:在第12行的E:\ wamp64 \ www \ social \ classes \ db.php中未绑定任何参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！