Alex (SirShurf) Frenkel's Blog

Practicly each time I am working with Zend_Db_Select (with Table or without it) I am searching for how easy to group orWhere elements.

After lot’s of searching and try and error’s I have come to this code:

if (false !== $this->_customSearchKeyword) {

$searchFields = array(‘p.photo_name’, ‘p.photo_desc’);

$keywordWhere = array();

if (!empty($searchFields)) {

foreach ($searchFields as $searchField) {

$searchField = $db0->quoteIdentifier($searchField);
$keywordWhere[] = ‘(‘ . $db0->quoteInto(“$searchField = ?”,

$this->_customSearchKeyword) . ‘)’;

}
$select->where( implode(‘ OR ‘, $keywordWhere) );

}

}

I hope that would be of some help to somebody 🙂 more then me I mean