Get product category ID

Code: Select all

public function getTotalProductsByCategoryId($category_id = 0) {

Code: Select all

//MOD START
//check if product is in given category list
public function isProductInCategories($categories_id=array(), $product_id=null) {

$categories_id = implode(',',(array)$categories_id);

$sql = "SELECT 1 FROM " . DB_PREFIX . "product_to_category p2c WHERE p2c.product_id = '".(int)$product_id."' AND p2c.category_id IN (" . $categories_id . ")";

$query = $this->db->query($sql);
				
return (bool)$query->num_rows;
} 
//MOD END

Code: Select all

$product_info = $this->model_catalog_product->getProduct($product_id);

Code: Select all

// MOD START
$catlist = array(51,52,53);
$this->data['isProductInCategories'] = $this->model_catalog_product->isProductInCategories($catlist, $product_id); 
// MOD END   

Code: Select all

<?php
// MOD START
if ( $isProductInCategories )
/* do things here*/
// MOD END
?>

Code: Select all

//To match multiples cat :
$catlist = array(1,4,5,6);

Code: Select all

//To match one unique cat :
$catlist = array(4);

Code: Select all

$sql = "SELECT p.product_id, (SELECT

Code: Select all

$sql = "SELECT p.product_id, " . (!empty($data['filter_category_id']) ? (!empty($data['filter_sub_category']) ? "`cp`.`path_id` AS `category_id`," : "`p2c`.`category_id` AS `category_id`,") : "") . " (SELECT

Code: Select all

if (isset ($this->request->get['path'])) {
		    $path = $this->request->get['path'];
		    $cats = explode('_', $path);
		    $data['cat_id'] = $cats[count($cats) - 1];
}

Code: Select all

<?php if (isset($cat_id) && $cat_id == '20'){ ?>
 <!-- My content here… -->
<?php } ?>

Code: Select all

if (isset ($this->request->get['path'])) {
		    $path = $this->request->get['path'];
		    $cats = explode('_', $path);
		    $data['cat_id'] = $cats[count($cats) - 1];
		}