Zend Framework: How to do a DB select with multiple params?

Question

I'm just wondering what the syntax is to do a db select in Zend Framework where two values are true. Example: I want to find if a user is already a member of a group:

$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();

Adam Franco · Accepted Answer · 2009-12-04 03:39:10Z

17

You can use multiple where clauses which will be ANDed together by default:

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

edited Dec 4, 2009 at 3:39

answered Dec 4, 2009 at 2:41

Adam Franco

87.5k5 gold badges39 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Andrew Over a year ago

I'm getting an exception when trying to do the first example: SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)

Adam Franco Over a year ago

Strange, I've used both techniques in the past against MySQL using the PDO adapter. I guess I'll need to set up a table to test. It may be that your database type or adapter doesn't support the syntax I suggested.

Adam Franco Over a year ago

What database/adapter combination are you using?

Andrew Over a year ago

I was able to get the second one working. There's nothing wrong with your code in the second one. I realized my problem was that I was handling the result wrong.

Adam Franco Over a year ago

I've now tested the first version and found it was resulting in the following SQL: SELECT group_members.* FROM group_members WHERE (user_id = 1, 1 AND group_id = 1, 1) BTW: You can use print $select->__toString(); to output example SQL from the statement. Anyway, it seems that passing and array of parameters actually doesn't work with Zend_Db_Select (I must have been confusing this with using PDO directly), so I've removed that invalid part of the answer.

Mohit Padalia · Accepted Answer · 2013-02-09 15:16:45Z

5

Just In case someone wants to add an OR condition to a select with multiple params

$select = $db->select()
         ->from('products',
                array('product_id', 'product_name', 'price'))
         ->where('price < ?', $minimumPrice)
         ->orWhere('price > ?', $maximumPrice);

For more view the Zend Select manual Docs: zend.db.select

edited Feb 9, 2013 at 15:16

answered Jan 11, 2013 at 7:03

Mohit Padalia

1,57913 silver badges11 bronze badges

Collectives™ on Stack Overflow

Zend Framework: How to do a DB select with multiple params?

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related