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

php sql zend-db
Cyranix picture Cyranix · Feb 17, 2010 · Viewed 16.9k times · Source

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?

Answer

Vladimir Mihailenco picture Vladimir Mihailenco · Feb 17, 2010 
$data = array(1, 2, 3);
$select->where('user_id IN (?)', $data);

Related questions

How update a database table record in Zend?

I am using select like this and it is fetching record successfully: $table = new Bugs(); $select = $table->select(); $select->where('bug_status = ?', 'NEW'); $rows = $table->fetchAll($select); But Now I want to update same record. For …

Read More
Complex WHERE clause with Zend_Db using multiple AND OR operators

I want to generate this complex WHERE clause in Zend_Db: SELECT * FROM 'products' WHERE status = 'active' AND ( attribute = 'one' OR attribute = 'two' OR [...] ) ; I've tried this: $select->from('product'); $select->where('status = ?', $status); $select->where(…

Read More
SQL: Insert only new rows/records into a table?

I'm parsing a json feed routinely and need to insert only the newest users from the feed and ignore existing users. I think what I need is ON DUPLICATE KEY UPDATE or INSERT IGNORE based on some searching but I'm …

Read More