Back to PhocacartCategoryMultiple class

Method getCategoriesByProducts

public static
getCategoriesByProducts
(mixed $productsA)

Method getCategoriesByProducts - Source code

public static function getCategoriesByProducts($productsA)
{
    $productsS = '';
    $categories = '';
    if (!empty($productsA)) {
        $productsS = implode(',', $productsA);
        $db = Factory::getDBO();
        $query = ' SELECT pc.product_id, c.id, c.alias, c.title FROM #__phocacart_categories AS c' . ' LEFT JOIN #__phocacart_product_categories AS pc ON c.id = pc.category_id' . ' WHERE pc.product_id IN (' . $productsS . ')';
        $db->setQuery($query);
        $categories = $db->loadAssocList();
    }
    return $categories;
}