Magento Expert Forum - Improve your Magento experience
-
Junior Member
Show Products on Homepage Using Magento Filter Collection By Attribute,Field
This tutorial will show you how to display new product, featured product, bestseller product or by attribute of product… on homepage.
Attachment 805
First, explain how Magento filter a collection. Use this to explain how Magento filter a collection by attribute, field in a model, so that people can learn to write their own collections.
addAttributeToFilter() is a function that can be called on a collection in Magento.
In short, it adds a condition to the WHERE part of the MySQL query used to extract a collection from the database.
For example:
$_products = Mage::getModel('catalog/product')->getCollection()
->addAttributeToSelect(array('name', 'product_url',
'small_image'))
->addAttributeToFilter('sku', array('like' => 'UX%'))
->load();
The above code would get a product collection, with each product having it’s name, url,
price and small image loaded in it’s data array. The product collection would be filtered and contain only products that have an SKU starting with UX.
Filtering
We can filter our collections with the addFieldToFilter() function. In SQL you can think of these as your WHERE clauses.
Lets say we want to get a product by the sku PRODUCT001
$products = Mage::getModel('catalog/product')->getCollection();
$products->addAttributeToFilter('sku','PRODUCT001');
$product = $products->getFirstItem();
Lets try the Greater Than conditional. Simply supply an array with the conditional type and value.
Products greater than $100:
$products = Mage::getModel('catalog/product')->getCollection();
$products->addAttributeToFilter('price', array('gt' => '100'));
Magento gives us lots of filter conditionals to choose from see: addAttributeToFilter Conditionals
Read full lesson at :http://www.magesolution.com/blog/sho...ion-attribute/
View more threads in the same category:
- Portable rv air conditioner
- Transforming Karachi's Skylines with Fiber Shades
- Unveiling the Power of E911 Solutions Enhancing Caller Identification
- List of Top 10 Interior Designers in Pakistan
- buy registered drivers license online(legitcleandocs.com)passport,IELTS certific
- Malaysia Visit Visa from Dubai
- Buy Passport,Driver License,Age & ID Card,(Whatsapp:.......: +1 (551) 239-2904) Visas
- 슬롯사이트 추천 - 인터넷슬롯링크 2024 best 온라인슬롯
- Buy Passport,Driver License,Age & ID Card,(Whatsapp:.......: +1 (551) 239-2904) Visas
- Buy Passport,Driver License,Age & ID Card,Visas and Undetected Counterfeit Money. Ema
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks