Jump to content

Edit History

ps8modules

ps8modules

If you want to get more information, you use, for example: 

$idlang = 1;
$idFeature = 14;
$idProduct = 222;

$getFeatureInfo = Db::getInstance()->getRow('
	SELECT a.id_feature_value, a.value as feature_value_name, c.name as feature_name FROM '._DB_PREFIX_.'feature_value_lang a 
	LEFT JOIN '._DB_PREFIX_.'feature_product b ON (a.id_feature_value = b.id_feature_value)
    LEFT JOIN '._DB_PREFIX_.'feature_lang c ON (c.id_feature = b.id_feature)
    WHERE b.id_feature = '.$idFeature.' AND b.id_product = '.$idProduct.' AND a.id_lang = '.$idLang.' AND c.id_lang = '.$idlang);

$featureName = $getFeatureInfo['feature_name'];
$featureValueName = $getFeatureInfo['feature_value_name'];
$featureValueId = $getFeatureInfo['id_feature_value'];

 

result:

obrazek.png.c27ba0a205078695041c50e8f39f0d5f.png

 

And you can play endlessly like this 😄

 

ps8modules

ps8modules

If you want to get more information, you use, for example: 

$idlang = 1;
$idFeature = 14;
$idProduct = 222;

$getFeatureInfo = Db::getInstance()->getRow('
	SELECT a.id_feature_value, a.value as feature_value_name, c.name as feature_name FROM '._DB_PREFIX_.'feature_value_lang a 
	LEFT JOIN '._DB_PREFIX_.'feature_product b ON (a.id_feature_value = b.id_feature_value)
    LEFT JOIN '._DB_PREFIX_.'feature_lang c ON (c.id_feature = b.id_feature)
    WHERE b.id_feature = '.$idFeature.' AND b.id_product = '.$idProduct.' AND a.id_lang = '.$idLang.' AND c.id_lang = '.$idlang);

$featureName = $getFeatureInfo['feature_name'];
$featureValueName = $getFeatureInfo['feature_value_name'];
$featureValueId = $getFeatureInfo['id_feature_value'];

 

result:

obrazek.png.c27ba0a205078695041c50e8f39f0d5f.png

ps8modules

ps8modules

If you want to get more information, you use, for example: 

$idlang = 1;
$idFeature = 14;
$idProduct = 222;

$getFeatureInfo = Db::getInstance()->getRow('
	SELECT a.id_feature_value, a.value as feature_value_name, c.name as feature_name FROM '._DB_PREFIX_.'feature_value_lang a 
	LEFT JOIN '._DB_PREFIX_.'feature_product b ON (a.id_feature_value = b.id_feature_value)
    LEFT JOIN '._DB_PREFIX_.'feature_lang c ON (c.id_feature = b.id_feature)
    WHERE b.id_feature = '.$idFeature.' AND b.id_product = '.$idProduct.' AND a.id_lang = '.$idLang.' AND c.id_lang = '.$idlang);

$featureName = $getFeatureInfo['feature_name'];
$featureValueName = $getFeatureInfo['feature_value_name'];
$featureValueId = $getFeatureInfo['id_feature_value'];

 

ps8modules

ps8modules

If you want to get more information, you use, for example: 

$idlang = 1;
$idFeature = 14;
$idProduct = 222;

$getFeatureInfo = Db::getInstance()->getRow('
	SELECT a.id_feature_value, a.value as feature_value_name, c.value as feature_name FROM '._DB_PREFIX_.'feature_value_lang a 
	LEFT JOIN '._DB_PREFIX_.'feature_product b ON (a.id_feature_value = b.id_feature_value)
    LEFT JOIN '._DB_PREFIX_.'feature_lang c ON (c.id_feature = b.id_feature)
    WHERE b.id_feature = '.$idFeature.' AND b.id_product = '.$idProduct.' AND a.id_lang = '.$idLang.' AND c.id_lang = '.$idlang);

$featureName = $getFeatureInfo['feature_name'];
$featureValueName = $getFeatureInfo['feature_value_name'];
$featureValueId = $getFeatureInfo['id_feature_value'];

 

×
×
  • Create New...