Zend_Auth login using either username or email as identityColumn

Question

I'm using Zend_Auth with a "Database Table Authentication". What I want to do is allow the user to login with either a username or email address as the "identityColumn". How would I allow both. I'm stuck.

Answer 1

Authenticate twice (if needed) with 2 different Zend_Auth_Adapter_DbTable objects and add some logic to determine if the login is username or email by guessing if what type of login user provided so that you save one query for most of the cases.

Answer 2

Extend and implement your own Auth Adapter and use query like "WHERE username = ? or email = ?" to get Auth result :)