public function searchAction($keyword) { $terms = explode(" ", $keyword); $termCounter = 0; $conditions = ''; $bind = array(); foreach ($terms as $term) { if ($conditions != '') { $conditions .= ' AND '; } $termCounter++; $conditions .= ' (name like ?' . $termCounter . ' OR builder like ?' . $termCounter . ') '; $bind[$termCounter] = '%' . $term . '%'; } $data = Estate::find(array('conditions' => $conditions, 'bind' => $bind, 'limit' => 15)); $json = array(); foreach ($data as $row) { $json[] = $row->getDataAsArray(); } echo json_encode($json); }