Get a collection of attribute text values

Question

I am looking to get a collection of attribute text values (not option values) from this particular table: catalog_product_entity_varchar given a particular attribute_id (and entity_type_id). Preferably I would like to use magento collection models and not include any other information apart what is on this table.

I would like to follow this up by querying a particular value from this table as well as using LIKE based wildcards queries.

Answer 1

You can build a query using sql rather than the normal magento collection with the follow snippet.

$resource = Mage::getSingleton('core/resource');
/** @var Magento_Db_Adapter_Pdo_Mysql $readConnection */
$readConnection = $resource->getConnection('core_read');
$results = $readConnection->fetchAssoc('SELECT * FROM catalog_product_entity_varchar');

Obviously you should select only column you need and add the appropriate where etc but this will give you an array with all the information you need. It might not be the "best" idea but it will be functioning.

Answer 2

<pre>
$attributes = Mage::getSingleton('eav/config')
    ->getEntityType(Mage_Catalog_Model_Product::ENTITY)
    ->getAttributeCollection()
    ->addSetInfo();
</pre>

It will give you the collection of all attribute. And Through getName() ,you will get the label of respective attribute.