Zend DB fetchAll(): where clause array with IN operator

Question

I'm selecting records from a database using the equivalent of this query:

SELECT * FROM reports WHERE user_id IN (3, 6, 22);

The function calling fetchAll() has an argument that's an array of the user IDs, and this call works just fine:

$resultSet = $this->getDbTable()->fetchAll('user_id IN (' . implode(', ', $userIds) . ')');

However, I would like to use an array for the where clause because there will probably be other restrictions to the query later... and I can't figure it out for the life of me. I thought it would be some variation on the following:

$resultSet = $this->getDbTable()->fetchAll(array('user_id IN ?' => '(' . implode(', ', $userIds) . ')'));

But so far no dice. Can someone provide the correct syntax here?

Vladimir Mihailenco · Accepted Answer · 2010-02-17 21:02:23Z

23

$data = array(1, 2, 3);
$select->where('user_id IN (?)', $data);

answered Feb 17, 2010 at 21:02

Vladimir Mihailenco

3,3922 gold badges27 silver badges39 bronze badges

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

1 Comment

Cyranix Over a year ago

Well, it's for fetchAll() instead of where(), but that's the ticket. I had tried 'user_id IN (?)' before but associated it with the result from implode(), not just the array directly.

Fábio Paiva · Accepted Answer · 2014-01-23 18:06:55Z

2

In Zend 2

$data = array(1, 2, 3);
$select->where('user_id', $data);

answered Jan 23, 2014 at 18:06

Fábio Paiva

5694 silver badges7 bronze badges

Comments

susheel sahoo · Accepted Answer · 2016-08-08 10:04:34Z

0

$select = $this->getSql()->select();
$select->where("reports.user_id in ('3','6','22')"); 
$resultSet = $this->selectWith($select);             
//echo $select->getSqlString();die;
return $resultSet;

answered Aug 8, 2016 at 10:04

susheel sahoo

1072 silver badges8 bronze badges

1 Comment

Toby Speight Over a year ago

Although this code may help to solve the problem, providing additional context regarding why and/or how it answers the question would significantly improve its long-term value. Please edit your answer to add explanation, including what limitations and assumptions apply.

Collectives™ on Stack Overflow

Zend DB fetchAll(): where clause array with IN operator

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related