Home  >  Article  >  Backend Development  >  新手提问:YII框架怎么排序

新手提问:YII框架怎么排序

WBOY
WBOYOriginal
2016-06-06 20:32:531179browse

<code>public function actionIndex($id)
    {

        $this->pageTitle = Yii::t('zh_CN', 'PAGE_TITLE_PRODUCT');

        $current_product_category_model = ProductCategory::model()->findByPk($id);


        $criteria = new CDbCriteria();
        $criteria->limit = 5;
        $product_category = ProductCategory::model()->findAll($criteria);

        $product_sub_category = ProductSubCategory::model()->findAll('product_category_id=:product_category_id', array(':product_category_id' => $id));

        $products = Product::model()->findAll('product_status="online" AND product_category_id=:product_category_id', array(':product_category_id' => $id));
        $this->render("index", array(
            "products" => $products,
            "current_product_category_model" => $current_product_category_model,
            "product_category" => $product_category,
            "product_sub_category" => $product_sub_category,
        ));
    }
</code>

$criteria->order = 'id desc'; 我知道,但是只能对$product_category进行排序,我想对$products也进行排序 怎么排 多谢

回复内容:

<code>public function actionIndex($id)
    {

        $this->pageTitle = Yii::t('zh_CN', 'PAGE_TITLE_PRODUCT');

        $current_product_category_model = ProductCategory::model()->findByPk($id);


        $criteria = new CDbCriteria();
        $criteria->limit = 5;
        $product_category = ProductCategory::model()->findAll($criteria);

        $product_sub_category = ProductSubCategory::model()->findAll('product_category_id=:product_category_id', array(':product_category_id' => $id));

        $products = Product::model()->findAll('product_status="online" AND product_category_id=:product_category_id', array(':product_category_id' => $id));
        $this->render("index", array(
            "products" => $products,
            "current_product_category_model" => $current_product_category_model,
            "product_category" => $product_category,
            "product_sub_category" => $product_sub_category,
        ));
    }
</code>

$criteria->order = 'id desc'; 我知道,但是只能对$product_category进行排序,我想对$products也进行排序 怎么排 多谢

哥,你都会对$product_category排序了,那你把对$product_category排序的代码套到$products上不就o了吗?

<code> $products = Product::model()->findAll(new CDbCriteria(array(
      "condition" => 'product_status="online" AND product_category_id=:product_category_id',
      "order" => "id desc",
      "params" => array(':product_category_id' => $id)
   )));
</code>
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn