load multiple attributers using load() Magento

Question

I am using this code but it's not working with multiple parameter. I want only use load() function in magento. You can see below code any please help me.

$attributes = array('entity_id'=> 1684, 'advertise_id'=> 283);
$model= Mage::getModel('catalog/product')->load($attributes);

Thanks for support in advance.

Answer 1

Based upon your comments, I gather you are trying to iterate over a collection of products IDs and trying to get the 'advertise_id' column. In that case, I'd strongly suggest against load method. Using of load inside a loop will be like killing your mySql with your own hands.

You should try with this code :

$collection = Mage::getModel('catalog/product')->getCollection()
    ->addAttributeToSelect('advertise_id')
    ->addIdFilter($idArray);

foreach($collection as $key => $value) {
    var_dump($value->getData('advertise_id'));
}

Where $idArray is simply the array containing all the IDs of products you are trying to access.

Answer 2

Hello if you want to load your model with out using primary key column you can use

Mage::getModel('catalog/product')->load("your data",'column_name'); 

Answer 3

If you are not in product page, you should load product by id.

$_product = Mage::getModel('catalog/product')->load($id)

From this product object, you can get your custom attribute value

$_product->getAdvertiseId();

Answer 4

you have to load through a collection:

$product = Mage::getModel('catalog/product')
  ->getCollection()
  ->addAttributeToFilter('entity_id', 1684)
  ->addAttributeToFilter('advertise_id', 283)
  ->setPage(1, 1)
  ->getFirstItem();

if ($product->getId()) {
  ...
}

Hope it helps.

EDIT

To solve the problem of advertise_id attribute not belonging to flat table, try this snippet:

$attribute = Mage::getSingleton('eav/config')
  ->getAttribute('catalog_product', 'advertise_id');

$productCollection = Mage::getModel('catalog/product')
  ->getCollection();

$productCollection
  ->getSelect()
  ->join(
    array('attributeTable' => $attribute->getBackend()->getTable()), 
    'e.entity_id = attributeTable.entity_id', 
    array('advertise_id' => 'attributeTable.value')
  )
  ->where("attributeTable.attribute_id = ?", $attribute->getAttributeId())
  ->where("attributeTable.value = ?", 283)
;  

$product = productCollection
  ->addIdFilter(1684)
  ->setPage(1, 1)
  ->getFirstItem();

if ($product->getId()) {
  ...
}