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

Parsing Domain Name From URL In PHP

To get Domain name from the url, we can use parse_url() php function. This would filter the domain name from the given url. $domain = str_ireplace ( 'www.' , '' , parse_url ( $url , PHP_URL_HOST )); This would return the google.com for both http://google.com and http://www.google.com

How to display Image in grid

Write this code in Grid.php:- $this->addColumn("data", array( "header" => Mage::helper("userdesign")->__("Design"), "index" => "image", 'align'     =>'center', 'renderer'  => 'userdesign/Adminhtml_Userdesign_Renderer_Image' )); Then make a "Renderer" folder in module( location - Grid.php) In Renderer Make a PHP file , Named Image.php and put this code <?php class Userdesign_Userdesign_Block_Adminhtml_Userdesign_Renderer_Image extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract{           public function render(Varien_Object $row)     { $designUrl=Mage::getBaseUrl('web').'design/designs/';         $html = '<img width="75" height="75" ';          $value = $row->getData('designId');       $html.= 'src="' . Mage::getBaseUrl('web')....