zend-framework - Zend框架: How to do a DB select with multiple params?

Question

我只是想知道在Zend Framework中执行两个数据库值选择的语法是什么。示例:我想查找用户是否已经是组的成员:

$userId = 1;
$groupId = 2;
$db = Zend_Db_Table::getDefaultAdapter();
$select = new Zend_Db_Select($db);
$select->from('group_members')
    ->where('user_id = ?', $userId); //Right here. What do I do about group_id?
$result = $select->query();
$resultSet = $result->fetchAll();

Answer 1

您可以使用多个where子句，这些子句默认情况下将与在一起:

$select->from('group_members')
    ->where('user_id = ?', $userId)
    ->where('group_id = ?', $groupId);