$query = $this->params['url']['term'];
$return_arr = array();
$products = $this->Product->find('all', array('fields' => array('DISTINCT (Product.product_name) AS product_name'),'conditions' => array('Product.product_name LIKE' => $query.'%')));
foreach($products as $product) {
$return_arr[] = $product['Product']['product_name'];
}
echo json_encode($return_arr);
}?>
public function suggestion() {
$this->autoRender = false;
$query = $this->params['url']['term'];
$return_arr = array();
$manufacturers = $this->Manufacturer->find('all', array('fields' => array('Manufacturer.manufacturer'),'conditions' => array('Manufacturer.manufacturer LIKE' => $query.'%')));
foreach($manufacturers as $manufacturer) {
$return_arr[] = $manufacturer['Manufacturer']['manufacturer'];
}
echo json_encode($return_arr);
}?>