Back to PhocacartRelated class

Method storeRelatedItemsById

public static
storeRelatedItemsById
(mixed $relatedString, mixed $productId)

Method storeRelatedItemsById - Source code

public static function storeRelatedItemsById($relatedString, $productId)
{
    if ((int) $productId > 0) {
        $db = Factory::getDBO();
        $query = ' DELETE ' . ' FROM #__phocacart_product_related' . ' WHERE product_a = ' . (int) $productId;
        $db->setQuery($query);
        $db->execute();
        if (isset($relatedString) && $relatedString != '') {
            $relatedArray = explode(",", $relatedString);
            $values = array();
            $valuesString = '';
            foreach ($relatedArray as $k => $v) {
                $values[] = ' (' . (int) $productId . ', ' . (int) $v . ')';
            }
            if (!empty($values)) {
                $valuesString = implode(',', $values);
                $query = ' INSERT INTO #__phocacart_product_related (product_a, product_b)' . ' VALUES ' . (string) $valuesString;
                $db->setQuery($query);
                $db->execute();
            }
        }
    }
}