Hi Ralph,
$adapter = new Zend_Auth_Adapter_DbTable($db, 'users', 'username',
'password');
$adapter->setIdentity('rschindler')
->setCredential('my password', 'PASSWORD(?)');
$result = $adapter->authenticate();
I got the above working quickly and easily, nice work.
I had been starting to work with Zend_Auth and Zend_Acl and was
partly following some of the pointers put together by Simon Mundy.
On that note, In his implementation...
http://www.nabble.com/Zend_Auth_Adapter_Db-Table--tf3269367s16154.html
...the identity is returned as a Zend_Db_Table_Row object rather than
a string. I've mentioned before that I find the former much more
useful and a few others echoed the same sentiment and I wonder if it
could be possible here. It is especially relevant if you also do a
strict check as to do something as simple as return a "Welcome back
Ralph Schindler, your last login was on 6th March 2007" message,
would require 3 queries.
I'm not sure what Zend_Auth_Adapter_DbTable_Select returns so perhaps
this is possible there?
Thanks,
Nick