mysql - Zend Framework - 和 where 子句

Question

我在 Zend Framework 上工作，在查询中遇到 1 个问题，我想从 tbl_user 获取用户 ID 并想使用 And in where 子句检查记录

here is my query
$sql=$this->select()->from(users)->where('email = ? ', trim($email) , 'password = ?', md5(trim($password)) );

当我打印查询时它会打印

select * from users where email = 'test@gmail.com';

我想像这样打印查询

select * from users where email = 'test@gmail.com' AND password='123456';

提前致谢

Answer 1

你很接近。你只需要调用 where() 方法两次:

$this->select()->from(users)->where('email = ?', trim($email))
                            ->where('password = ?', md5(trim($password)));