Zend_Auth：不工作，getDbSelect() 为空

Question

我的身份验证失败，当我尝试 getDbSelect() 时，我什么也没得到......我做错了什么？

class AuthController extends Zend_Controller_Action
{
    protected $auth;

    public function init()
    {
        $db = $this->getInvokeArg("bootstrap")->getResource("db");
        $this->auth = new Zend_Auth_Adapter_DbTable($db, 'users', 'username', 'password', 'md5(?)');
    }
    public function loginAction()
    {
        if (isset($_POST["username"])) {
            $result = $this->auth
                ->setIdentity($this->getRequest()->getParam('username'))
                ->setCredential($this->getRequest()->getParam('password'));
            echo " > " . $this->auth->getDbSelect();die();
            $result = $this->auth
                ->setIdentity($this->getRequest()->getParam('username'))
                ->setCredential($this->getRequest()->getParam('password'))
                ->authenticate();
            if ($result->isValid()) {
                $this->_redirect("postLogin");
            }
        }
    }

更新1：

我也尝试过不使用MVC而使用我更熟悉的MySQL：

// setup auto loading
require_once 'Zend/Loader/Autoloader.php';
Zend_Loader_Autoloader::getInstance();

// setup db connection
$db = new Zend_Db_Adapter_Pdo_Mysql(array(
    'host'     => '127.0.0.1',
    'username' => 'root',
    'password' => '',
    'dbname'   => 'learnZendAuth'
));

// create authentication adapter
$auth = new Zend_Auth_Adapter_DbTable($db, 'users', 'username', 'password', 'md5(?)');

// do login if request is posted
if (isset($_POST) && !empty($_POST)) {
    // do authencation
    $result = $auth->setIdentity($_POST['username'])
         ->setCredential($_POST['password'])
         ->authenticate();

    // check authentication valid
    if ($result->isValid()) {
        // login success
        echo "successfully logged in as: " . $result->getIdentity();
    } else {
        // login fail
        echo "
";
        print_r($result->getMessages());
        echo "
";
    }
} else {
    // request not posted
    // see if already logged in
    if (Zend_Auth::getInstance()->hasIdentity()) {
        echo "already logged in as: " . Zend_Auth::getInstance()->getIdentity();
    }
}

我明白了

致命错误：未捕获的异常 'Zend_Auth_Adapter_Exception' 与 message '提供的参数 Zend_Auth_Adapter_DbTable 失败 请生成有效的sql语句 检查表名和列名 有效性。'在 C:\Program Files 中 (x86)\Zend\ZendServer\share\ZendFramework\library\Zend\Auth\Adapter\DbTable.php:414 堆栈跟踪：#0 C:\Program Files (x86)\Zend\ZendServer\share\ZendFramework\library\Zend\Auth\Adapter\DbTable.php(306): Zend_Auth_Adapter_DbTable->_authenticateQuerySelect(Object(Zend_Db_Select))

1 C:\Program Files (x86)\Zend\Apache2\htdocs\learnZf\index.php(23):

Zend_Auth_Adapter_DbTable->authenticate()

2 {main} 抛出在 C:\Program Files (x86)\Zend\ZendServer\share\ZendFramework\library\Zend\Auth\Adapter\DbTable.php

414行

Answer 1

尝试将 getDbSelect 移动到 is valid 语句中，
我通常也用来

$userInfo = $this->auth->getResultRowObject();

获取用户信息，从未见过这个 getDbSelect 方法

Answer 2

哦，我发现我做错了什么...

第一次尝试，我使用了Sqlite，它不支持md5（？）处理

第二次尝试，我指定了错误的列名...名称与用户名...