ZF2身份验证

public function authenticate()
{       
    $this->authAdapter = new AuthAdapter($this->dbAdapter,'usertable','username','password'
    );  

    $this->authAdapter->setIdentity($this->userName)
                ->setCredential($this->password)
                ->setCredentialTreatment('MD5(?)');
    $result = $this->authAdapter->authenticate();
    return $result;
}

当我使用zf2和doctrine构建我的身份验证时,我创建了授权插件并自定义了 this adapter,用于传递额外的列进行身份验证.
你可能需要继续进行类似的指导.

$adapter = new AuthAdapter($db,'users','password','MD5(?)'
                           );

// get SELEct object (by referencE)
$SELEct = $adapter->getDbSELEct();
$SELEct->where('active = "TRUE"');

// authenticate,this ensures that users.active = TRUE
$adapter->authenticate();

Reference

更改后,您的代码应该看起来像这样.

public function authenticate()
{       
    $this->authAdapter = new AuthAdapter($this->dbAdapter,'password'
    );  

    $SELEct = $this->authAdapter->getDbSELEct();
    $SELEct->where('status= "1"');
    $this->authAdapter->setIdentity($this->userName)
                ->setCredential($this->password)
                ->setCredentialTreatment('MD5(?)');
    $result = $this->authAdapter->authenticate();
    return $result;
}