magento从类别获得产品，order by rand（） [英] magento get products from category, order by rand()

问题描述

我有以下：

$products = Mage::getModel('catalog/product')
    ->getCollection()
    ->addAttributeToSort('id', 'RAND()')
    ->addAttributeToSelect('small_image')
    ->addCategoryFilter(Mage::getModel('catalog/category')->load($catId));

但我需要通过id订购 RAND（），我该怎么做呢？ （代码显示我没有运气试过）

But I need to order by id RAND(), how can I do this? (The code shows how I've tried with no luck)

推荐答案

Magento集合不接受参数， 。在这种情况下，您应该得到 Zend_Db_Select 对象并向其添加订单指令。

Magento collection do not accept parameters other then one of selected attribute. In this case you should get Zend_Db_Select object and add order instruction to it.

$products = Mage::getModel('catalog/product')
    ->getCollection()
    ->addAttributeToSort()
    ->addAttributeToSelect('small_image')
    ->addCategoryFilter(Mage::getModel('catalog/category')->load());
$products->getSelect()->order(new Zend_Db_Expr('RAND()'));

要查看将执行什么查询，您可以使用此构造

To see what query will be executed you may use this construnction

$products->load(true, true); // first parameter show sql query in output, second show sql query in var/log/syslog

这篇关于magento从类别获得产品，order by rand（）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！