Skip to main content

Get related product on with same category,brand,gender

include('app/Mage.php');
Mage::app();
$product = Mage::getModel('catalog/product')->load(2122);
$ids = $product->getCategoryIds();
//echo '<pre>';
//print_r($ids);
$latest_cat_id = $ids[count($ids)-1];
$_category = Mage::getModel('catalog/category')->load($latest_cat_id);
$_gender=Mage::getResourceModel('catalog/product')->getAttributeRawValue(2122, 'gender');
$_brand_name=Mage::getResourceModel('catalog/product')->getAttributeRawValue(2122, 'brand_name');
$catagory_model = Mage::getModel('catalog/category')->load($latest_cat_id); 
    $collection = Mage::getResourceModel('catalog/product_collection');
$collection->addCategoryFilter($catagory_model);
$collection->addFieldToFilter('brand_name',$_brand_name );
$collection->addFieldToFilter('gender',$_gender );
    $collection->addAttributeToFilter('status',1);
$collection->addAttributeToSelect('*');
//echo '<pre>';
$i=1;
foreach ($collection as $product)
{
echo $i." )- ".$product->getName();
echo '<br/>';
$i++;
}

Comments

Popular posts from this blog

How to add tab in Customer Information in Magento Admin

Step 1) Override the file /app/code/core/Mage/Adminhtml/Block/Customer/Edit/Tabs.php, Inside _beforeToHtml() method, add the following code: $ this -> addTab ( 'Custom' , array (      'label'   = > Mage :: helper ( 'customer' ) -> __ ( 'Custom' ) ,      'class'   = >     'ajax' ,      'url'     = >     $ this -> getUrl ( '*/*/custom' , array ( '_current' = > true ) ) , ) ) ; Step 2)  Override the file /app/code/core/Mage/Adminhtml/controllers/CustomerController.php, Add the following code: public function customAction() { $this->_initCustomer(); $this->getResponse()->setBody( Mage::app()->getLayout()->createBlock('core/template')->setTemplate('custom/customer/tab/custom.phtml')->setCustomerId(Mage::registry('current_customer')->getId())         ->setUseAjax(true)-...

programaticaly Insert and select quary In magento

 INSERT QUERY include('../app/Mage.php'); Mage::app(); $write = Mage::getSingleton('core/resource')->getConnection('core_write'); $sql="INSERT INTO opd_uploads SET extension='$extension', sessionId='$sessionId', ip='$ip', status=1, dateTime=now()"; $write->query($sql); //lastInserted ID $imageId = $write->lastInsertId(); SELECT QUERY $read= Mage::getSingleton('core/resource')->getConnection('core_read');                   $value=$read->query("select * from opd_uploads WHERE id='".$imageRowId."'");          $row = $value->fetch();          $orgFilExt=$row['extension'];