Yii queryScalar() with mysql queries?

本文关键字：mysql queries with queryScalar Yii | 更新日期: 2023-09-27

我想为登录用户的匹配id和电子邮件找到用户角色。下面是我的wbuser类

我收到以下错误

Error 500
CDbCommand failed to execute the SQL statement: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

这是我的代码

<?php
class WebUser extends CWebUser {
    public $role;
    public $role2;
    public function getRole2() {
        if ($this->role2 === null) {
            // Here you need to get User role
            $this->role2 = Yii::app()->db->createCommand("SELECT email FROM {{students}} WHERE id=:id AND role=1")->queryScalar(array(':id' => Yii::app()->user->id));
        }
        return $this->role2;
    }
    public function getRole(){
        if ($this->role === null) {
            // Here you need to get User role
            $this->role = Yii::app()->db->createCommand("SELECT role FROM {{students}} WHERE id=:id AND email=':email'")->queryScalar(array(':id' => Yii::app()->user->id,':email' => $this->role2,));
       } 
        return $this->role;
    }
}

尝试这种方式

$this->role2 = Yii::app()->db->createCommand()
->select('email')
->from( '{{students}}' )
->where('id=:id AND role=1', array(':id'=>$id));
->queryScalar();

对于第二个查询，尝试

$this->role2 = Yii::app()->db->createCommand()
->select('role')
->from( '{{students}}')
->where('id=:id AND email=:email', array(':id'=>$id, ':email'=> $this->role2));
->queryScalar();