Show all categories a product is in

Code: Select all

	$get_cats_id = "SELECT category_id
	FROM product_to_category
	WHERE product_id = '".$product_id."'";

$get_cats_res = mysql_query($get_cats_id);

while ($cats = mysql_fetch_array($get_cats_res, MYSQL_ASSOC))

	{
	$cat_id = $cats['category_id'];

	$get_cat_name = "SELECT name
		FROM category_description
		WHERE category_id = '".$cat_id."'";

	$get_name_res = mysql_query($get_cat_name);

	$name = mysql_fetch_array($get_name_res, MYSQL_ASSOC);

	$get_cat_url = "SELECT keyword
		FROM url_alias
		WHERE query = 'category_id=".$cat_id."'";

	$get_url_res = mysql_query($get_cat_url);

	$url = mysql_fetch_array($get_url_res, MYSQL_ASSOC);

	$get_par_id = "SELECT parent_id
		FROM category
		WHERE category_id = '".$cat_id."'";

	$get_par_res = mysql_query($get_par_id);

	$par = mysql_fetch_array($get_par_res, MYSQL_ASSOC);

	$get_par_url = "SELECT keyword
		FROM url_alias
		WHERE query = 'category_id=".$par['parent_id']."'";

	$get_purl_res = mysql_query($get_par_url);

	$purl = mysql_fetch_array($get_purl_res, MYSQL_ASSOC);


	echo "<a href=\"http://www.example.com/".$purl['keyword']."/".$url['keyword']."/\">".$name['name']."</a> ";


	mysql_free_result($get_name_res);

	mysql_free_result($get_url_res);

	mysql_free_result($get_par_res);

	mysql_free_result($get_purl_res);

	}

mysql_free_result($get_cats_res);

Code: Select all

public function getProductCategories($prodid) {
  $query = $this->db->query("SELECT category_id FROM " . DB_PREFIX . "product_to_category WHERE product_id = '" . $prodid . "'";)
  if($query->num_rows > 0) return $query->rows;
  return false;
}

Code: Select all

  $prodcategories = $this->model_catalog_category->getProductCategories($myproductidhere);
  $cats = array();
  if($prodcategories) {
    foreach($prodcategories as $prodcategory) {
        $cats[] = $prodcategory['category_id'];
    }
    $this->data['cats'] = $cats;
  }

Code: Select all

public function getProductCategories($prodid) {
$query = $this->db->query("SELECT category_id FROM " . DB_PREFIX . "product_to_category WHERE product_id = '" . $prodid . "'";)
if($query->num_rows > 0) return $query->rows;
return false;
}

Code: Select all

$prodcategories = $this->model_catalog_category->getProductCategories($product_id);
$cats = array();
if($prodcategories) {
foreach($prodcategories as $prodcategory) {
$cats[] = $prodcategory['category_id'];
}
$this->data['cats'] = $cats;

Code: Select all

<?php
   $this->load->model('catalog/category');
   $this->load->model('tool/seo_url'); 
   $query = $this->db->query("SELECT category_id
   FROM product_to_category
   WHERE product_id = '".$product_id."'");
   $prodcategories = $query->rows;
   foreach($prodcategories as $prodcategory){
	$category_id = $prodcategory['category_id'];
	$category_info = $this->model_catalog_category->getCategory($category_id);
      $caturl = $this->model_tool_seo_url->rewrite(HTTP_SERVER . 'index.php?route=product/category&path=' . $category_id); ?>
	<a href="<?php echo $caturl; ?>"><?php echo $category_info['name']; ?></a>
	<br />
<?php  }  ?>

Code: Select all

$query = $this->db->query("SELECT parent_id
   FROM category
   WHERE category_id = '".$category_id."'");
   $parentcategories = $query->rows;