How Can I Count Number Of Category In Cart

[davelau]

I want to get the number of category that a customer put in cart via php code. 

 

any thoughts? 

 

Thanks!!

[sandipchandela]

public static function getProductCategories($id_product = '')

    {

        $ret = array();

 

        $row = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('

            SELECT `id_category` FROM `'._DB_PREFIX_.'category_product`

            WHERE `id_product` = '.(int)$id_product

        );

 

        if ($row)

            foreach ($row as $val)

                $ret[] = $val['id_category'];

 

        return $ret;

    }