OpenCart系統之獲取某個商品的頂級分類ID
如下這個Model的方法是獲取某個商品的分類,任意取出一個即可:public function getProductCategory($product_id) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_to_category WHERE product_id = '".$product_id."' LIMIT 0, 1");
return $query->row;
}
下面的方法是獲取該商品的頂級分類ID:
public function getTopestCategoryID($category_id) {
$query = $this->db->query("SELECT category_id, parent_id FROM " . DB_PREFIX . "categoryWHERE category_id = '".$category_id."'");
if($query->row['parent_id'] == 0) {
return $query->row['category_id'];
}else{
$this->getTopestCategoryID($query->row['parent_id']);
}
} 楼主,太爱你了。
static/image/common/sigline.gif
殖装
頁:
[1]