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



 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,
        ));
    }

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

yii php

我叫呵呵. 8 years, 10 months ago

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


 $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)
   )));

月亮我弄弯滴 answered 8 years, 10 months ago

Your Answer