[SOLVED] Related Product's link...

Code: Select all

http://demo.opencart.com/index.php?route=product/product&path=20_27&product_id=41

Code: Select all

http://demo.opencart.com/index.php?route=product/product&product_id=42

Code: Select all

'href'    	 => $this->url->link('product/product', 'product_id=' . $result['product_id']),

Code: Select all

'href'    	 => $this->url->link('product/product', 'product_id=' . $result['product_id'] . (isset($this->request->get['path']) ? '&path=' . $this->request->get['path'] : '')),

Code: Select all

}
?>

Code: Select all

	public function getCategoryPath($product_id) {
		$category = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_to_category WHERE product_id = '" . (int)$product_id . "'");
		
		if($category->num_rows){
			$path = array();
			foreach($category->rows as $paths){
				$path[0] = $paths['category_id'];
			}
			
			$parent = $this->db->query("SELECT * FROM " . DB_PREFIX . "category WHERE category_id = '" . (int)$path[0] . "'");

			$pid = $parent->row['parent_id'];
			
			$p = 1;
			if($pid>0){
				do{
					$path[$p] = $pid;
					
					$parent2 = $this->db->query("SELECT * FROM " . DB_PREFIX . "category WHERE category_id = '" . (int)$pid . "'");
					$pid = $parent2->row['parent_id'];
					$p++;
				}while($pid>0);
			}
		
			$path = array_reverse($path);
			
			$fullpath = '';
			
			foreach($path as $val){
				$fullpath .= '_'.$val;
			}
		
			return ltrim($fullpath, '_');
		}else{
			return '0';
		}
	}			

Code: Select all

$this->url->link('product/product', 'path=' . $this->model_catalog_product->getCategoryPath($product['product_id']) . '&product_id=' . $product['product_id'])