  |
189 | 189 | | } |
| |
190 | 190 | | |
| |
191 | 191 | | if ($this->hasKeywords()) { |
 |
192 | | - | foreach (explode(' ', $this->_keywords) as $keyword) { |
| |
193 | | - | $Qlisting->appendQuery('and (p.products_model like :keyword or pd.products_name like :keyword or pd.products_description like :keyword)'); |
| |
194 | | - | $Qlisting->bindValue(':keyword', '%' . $keyword . '%'); |
| |
195 | | - | $Qlisting->bindValue(':keyword', '%' . $keyword . '%'); |
| |
196 | | - | $Qlisting->bindValue(':keyword', '%' . $keyword . '%'); |
| |
197 | | - | } |
| |
| 192 | + | $Qlisting->prepareSearch($this->_keywords, array('pd.products_name', 'pd.products_description'), true); |
|
198 | 193 | | } |
| |
199 | 194 | | |
| |
200 | 195 | | if ($this->hasDateSet('from')) { |