Here is the code into controler of product/search.php
Code: Select all
[...}
$product_total = $this->model_catalog_product->getTotalProducts($filter_data);
$this->load->model('catalog/categories_search');
$categories_result = $this->model_catalog_categories_search->searchCategories(str_replace('-', '_', $filter_data['filter_name']));
$data['categories'] = array();
foreach ($categories_result as $category) {
if ($category['image']) {
$image = $this->model_tool_image->resize($category['image'], 512, 200);
} else {
$image = $this->model_tool_image->resize('placeholder.png', 512, 200);
}
$data['categories'][] = array(
'category_id' => $category['category_id'],
'image' => $image,
'name' => $category['name'],
);
}
Code: Select all
<?php class ModelCatalogCategoriesSearch extends Model {
public function searchCategories($term) {
$categories = [];
if (!empty($term)) {
$categories_sql = "SELECT * FROM " . DB_PREFIX . "category WHERE name LIKE '%" . $this->db->escape($term) . "%' ORDER BY name ASC;";
$categories_query = $this->db->query($categories_sql);
foreach ($categories_query->rows as $category) {
$categories[$category['category_id']] = $category;
}
}
return $categories;
}
}
Code: Select all
<?php if ($categories) { ?>
<?php foreach ($categories as $category) { ?>
<a href="index.php?route=product/category&path=<?php echo $category['category_id']; ?>">
<img src="<?php echo $category['image']; ?>"/>
<?php echo $category['name']; ?></a>
<?php } ?>
<?php } ?>