blocks|key|604988|text|我所知道的一种方式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|604989|$product->getResource()->getAttribute($attribute_code)
++++++++->getFrontend()->getValue($product)|code-block|syntax|javascript|604990|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

A way that I know of:

<pre><code>$product-&gt;getResource()-&gt;getAttribute($attribute_code)
 -&gt;getFrontend()-&gt;getValue($product)
</code></pre>

blocks|key|605030|text|如果不加载产品模型，似乎不可能获得价值。如果您查看一下文件app/code/core/Mage/Eav/Model/Entity/Attribute/Frontend/Abstract.php，就会看到该方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|605031|public+function+getValue(Varien_Object+$object)
{
++++$value+=+$object->getData($this->getAttribute()->getAttributeCode());
++++if+(in_array($this->getConfigField('input'),+array('select','boolean')))+{
++++++++$valueOption+=+$this->getOption($value);
++++++++if+(!$valueOption)+{
++++++++++++$opt+=+new+Mage_Eav_Model_Entity_Attribute_Source_Boolean();
++++++++++++if+($options+=+$opt->getAllOptions())+{
++++++++++++++++foreach+($options+as+$option)+{
++++++++++++++++++++if+($option['value']+==+$value)+{
++++++++++++++++++++++++$valueOption+=+$option['label'];
++++++++++++++++++++}
++++++++++++++++}
++++++++++++}
++++++++}
++++++++$value+=+$valueOption;
++++}
++++elseif+($this->getConfigField('input')=='multiselect')+{
++++++++$value+=+$this->getOption($value);
++++++++if+(is_array($value))+{
++++++++++++$value+=+implode(',+',+$value);
++++++++}
++++}
++++return+$value;
}|code-block|syntax|javascript|605032|正如你所看到的，这个方法需要加载的对象来获取数据(第三行)。|605033|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

It seems impossible to get value without loading product model. If you take a look at file app/code/core/Mage/Eav/Model/Entity/Attribute/Frontend/Abstract.php you'll see the method

<pre><code>public function getValue(Varien_Object $object)
{
 $value = $object-&gt;getData($this-&gt;getAttribute()-&gt;getAttributeCode());
 if (in_array($this-&gt;getConfigField('input'), array('select','boolean'))) {
 $valueOption = $this-&gt;getOption($value);
 if (!$valueOption) {
 $opt = new Mage_Eav_Model_Entity_Attribute_Source_Boolean();
 if ($options = $opt-&gt;getAllOptions()) {
 foreach ($options as $option) {
 if ($option['value'] == $value) {
 $valueOption = $option['label'];
 }
 }
 }
 }
 $value = $valueOption;
 }
 elseif ($this-&gt;getConfigField('input')=='multiselect') {
 $value = $this-&gt;getOption($value);
 if (is_array($value)) {
 $value = implode(', ', $value);
 }
 }
 return $value;
}
</code></pre>

As you can see this method requires loaded object to get data from it (3rd line).

blocks|key|605086|text|我想，您可以编写一个方法，直接通过sql完成此操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|605087|看起来像这样：|605088|变量：|605089|$store_id+=+1;
$product_id+=+1234;
$attribute_code+=+'manufacturer';|code-block|syntax|javascript|605090|查询：|605091|SELECT+value+FROM+eav_attribute_option_value+WHERE+option_id+IN+(
++++SELECT+option_id+FROM+eav_attribute_option+WHERE+FIND_IN_SET(
++++++++option_id,+
++++++++(SELECT+value+FROM+catalog_product_entity_varchar+WHERE
++++++++++++entity_id+=+'$product_id'+AND+
++++++++++++attribute_id+=+(SELECT+attribute_id+FROM+eav_attribute+WHERE
++++++++++++++++attribute_code='$attribute_code')
++++++++)
++++)+>+0)+AND
++++store_id='$store_id';|605092|您必须根据属性的字段(eav_attribute中的字段)从正确的表中获取值，因此至少需要进行一次额外的查询。|605093|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|V|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|X|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

You could write a method that would do it directly via sql I suppose.

Would look something like this:

Variables:

<pre><code>$store_id = 1;
$product_id = 1234;
$attribute_code = 'manufacturer';
</code></pre>

Query:

<pre><code>SELECT value FROM eav_attribute_option_value WHERE option_id IN (
 SELECT option_id FROM eav_attribute_option WHERE FIND_IN_SET(
 option_id, 
 (SELECT value FROM catalog_product_entity_varchar WHERE
 entity_id = '$product_id' AND 
 attribute_id = (SELECT attribute_id FROM eav_attribute WHERE
 attribute_code='$attribute_code')
 )
 ) &gt; 0) AND
 store_id='$store_id';
</code></pre>

You would have to get the value from the correct table based on the attribute's backend_type (field in eav_attribute) though so it takes at least 1 additional query.

blocks|key|820282|text|Mage::getResourceModel('catalog/product')->getAttributeRawValue($productId,+'attribute_code',+$storeId);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|820283|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>Mage::getResourceModel('catalog/product')-&gt;getAttributeRawValue($productId, 'attribute_code', $storeId);
</code></pre>

blocks|key|820313|text|您可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|820314|<?php+echo+$product->getAttributeText('attr_id')++?>+|code-block|syntax|javascript|820315|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

you can use 

<pre><code>&lt;?php echo $product-&gt;getAttributeText('attr_id') ?&gt; 
</code></pre>

blocks|key|605159|text|首先，我们必须确保加载了所需的属性，然后将其输出。使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|605160|$product+=+Mage::getModel('catalog/product')->load('<product_id>',+array('<attribute_code>'));
$attributeValue+=+$product->getResource()->getAttribute('<attribute_code>')->getFrontend()->getValue($product);|code-block|syntax|javascript|605161|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

First we must ensure that the desired attribute is loaded, and then output it. Use this:

<pre><code>$product = Mage::getModel('catalog/product')-&gt;load('&lt;product_id&gt;', array('&lt;attribute_code&gt;'));
$attributeValue = $product-&gt;getResource()-&gt;getAttribute('&lt;attribute_code&gt;')-&gt;getFrontend()-&gt;getValue($product);
</code></pre>

blocks|key|605204|text|您不必加载整个产品。Magentos集合是非常强大和智能的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|605205|$collection+=+Mage::getModel('catalog/product')->getCollection();
$collection->addAttributeToFilter('entity_id',+$product->getId());
$collection->addAttributeToSelect('manufacturer');
$product+=+$collection->getFirstItem();
$manufacturer+=+$product->getAttributeText('manufacturer');|code-block|syntax|javascript|605206|此时，您调用getFirstItem()，查询将被执行，并且结果乘积非常小：|605207|[status]+=>+1
[entity_id]+=>+38901
[type_id]+=>+configurable
[attribute_set_id]+=>+9
[manufacturer]+=>+492
[manufacturer_value]+=>+JETTE
[is_salable]+=>+1
[stock_item+(Varien_Object)]+=>+Array
++++(
++++++++[is_in_stock]+=>+1
++++)|605208|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You don't have to load the whole product.
Magentos collections are very powerful and smart.

<pre><code>$collection = Mage::getModel('catalog/product')-&gt;getCollection();
$collection-&gt;addAttributeToFilter('entity_id', $product-&gt;getId());
$collection-&gt;addAttributeToSelect('manufacturer');
$product = $collection-&gt;getFirstItem();
$manufacturer = $product-&gt;getAttributeText('manufacturer');
</code></pre>

At the moment you call getFirstItem() the query will be executed and the result product is very minimal:

<pre><code>[status] =&gt; 1
[entity_id] =&gt; 38901
[type_id] =&gt; configurable
[attribute_set_id] =&gt; 9
[manufacturer] =&gt; 492
[manufacturer_value] =&gt; JETTE
[is_salable] =&gt; 1
[stock_item (Varien_Object)] =&gt; Array
 (
 [is_in_stock] =&gt; 1
 )
</code></pre>

blocks|key|605213|text|尝尝这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|605214|+$attribute+=+$_product->getResource()->getAttribute('custom_attribute_code');
++++if+($attribute)
++++{
++++++++echo+$attribute_value+=+$attribute+->getFrontend()->getValue($_product);
++++}|code-block|syntax|javascript|605215|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this 

<pre><code> $attribute = $_product-&gt;getResource()-&gt;getAttribute('custom_attribute_code');
 if ($attribute)
 {
 echo $attribute_value = $attribute -&gt;getFrontend()-&gt;getValue($_product);
 }
</code></pre>

blocks|key|820456|text|如果您有一个名为my_attr的文本/文本区域属性，则可以通过以下方式获取它：product->getMyAttr();|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|820457|entityMap^0|13|L|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

If you have an text/textarea attribute named my_attr you can get it by:
<code>product-&gt;getMyAttr();</code>

blocks|key|605315|text|这个不错-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|605316|echo+$_product->getData('ATTRIBUTE_NAME_HERE');|code-block|syntax|javascript|605317|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This one works-

<pre><code>echo $_product-&gt;getData('ATTRIBUTE_NAME_HERE');
</code></pre>

blocks|key|605339|text|​|type|unstyled|depth|inlineStyleRanges|entityRanges|data|605340|$orderId+=+1;+//+YOUR+ORDER+ID
$items+=+$block->getOrderItems($orderId);
+
foreach+($items+as+$item)+{
++++$options+=+$item->getProductOptions();++++++++
++++if+(isset($options['options'])+&&+!empty($options['options']))+{++++++++
++++++++foreach+($options['options']+as+$option)+{
++++++++++++echo+'Title:+'+.+$option['label']+.+'<br+/>';
++++++++++++echo+'ID:+'+.+$option['option_id']+.+'<br+/>';
++++++++++++echo+'Type:+'+.+$option['option_type']+.+'<br+/>';
++++++++++++echo+'Value:+'+.+$option['option_value']+.+'<br+/>'+.+'<br+/>';
++++++++}
++++}
}|code-block|syntax|javascript|605341|605342|您将用于检索Magento+2中的value+product自定义选项购物车顺序的所有内容：https://www.mageplaza.com/how-get-value-product-custom-option-cart-order-magento-2.html|offset|length|605343|entityMap|0|LINK|mutability|MUTABLE|url|https://www.mageplaza.com/how-get-value-product-custom-option-cart-order-magento-2.html^0|0|0|0|1A|2F|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|G|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|W|8|@]|9|@$J|X|K|Y|1|Z]]|A|$]]|$1|L|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

<div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-html lang-html prettyprint-override"><code>$orderId = 1; // YOUR ORDER ID
$items = $block-&gt;getOrderItems($orderId);
 
foreach ($items as $item) {
 $options = $item-&gt;getProductOptions(); 
 if (isset($options['options']) &amp;&amp; !empty($options['options'])) { 
 foreach ($options['options'] as $option) {
 echo 'Title: ' . $option['label'] . '&lt;br /&gt;';
 echo 'ID: ' . $option['option_id'] . '&lt;br /&gt;';
 echo 'Type: ' . $option['option_type'] . '&lt;br /&gt;';
 echo 'Value: ' . $option['option_value'] . '&lt;br /&gt;' . '&lt;br /&gt;';
 }
 }
}</code></pre>
</div>
</div>


all things you will use to retrieve value product custom option cart order in Magento 2: <a href="https://www.mageplaza.com/how-get-value-product-custom-option-cart-order-magento-2.html" rel="nofollow noreferrer">https://www.mageplaza.com/how-get-value-product-custom-option-cart-order-magento-2.html</a>

blocks|key|820559|text|可以通过以下方式获取属性值|type|unstyled|depth|inlineStyleRanges|entityRanges|data|820560|$model+=+Mage::getResourceModel('catalog/product');
$attribute_value+=+$model->getAttributeRawValue($productId,+'attribute_code',+$storeId);|code-block|syntax|javascript|820561|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can get attribute value by following way

<pre><code>$model = Mage::getResourceModel('catalog/product');
$attribute_value = $model-&gt;getAttributeRawValue($productId, 'attribute_code', $storeId);
</code></pre>

How to get specific product attribute value if i know product ID without loading whole product?

Magento Product Attribute Get Value

在不加载整个产品的情况下知道产品ID，如何获取具体的产品属性值？

问Magento产品属性获取值
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Magento产品属性获取值EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Magento产品属性获取值
EN