OpenCart 🇺🇦

$options = array();

$optionValueIds = explode(':', $productVar);
foreach($optionValueIds as $optionValueId) {
	$optionDetailsRow = $this->db->query("SELECT
		pov.product_option_id,
		pov.product_option_value_id,
		od.name,
		ovd.name as value,
		opt.type
	FROM `" . DB_PREFIX . "product_option_value` as pov,
		 `" . DB_PREFIX . "product_option` as po,
		 `" . DB_PREFIX . "option` as opt,
		 `" . DB_PREFIX . "option_value_description` as ovd,
		 `" . DB_PREFIX . "option_description` as od
	WHERE pov.product_option_value_id = '" . (int)$optionValueId . "' AND
		po.product_option_id = pov.product_option_id AND
		opt.option_id = pov.option_id AND
		ovd.option_value_id = pov.option_value_id AND ovd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND
		od.option_id = pov.option_id AND od.language_id = '" . (int)$this->config->get('config_language_id') . "'
	")->row;

	if(!empty($optionDetailsRow)) {
		$options[] = array(
			'product_option_id' => (int)$optionDetailsRow['product_option_id'],
			'product_option_value_id' => (int)$optionDetailsRow['product_option_value_id'],
			'name' => $optionDetailsRow['name'],
			'value' => $optionDetailsRow['value'],
			'type' => $optionDetailsRow['type']
		);
	}
}

return $options;