新手提问：YII框架怎么排序-php教程-PHP中文网

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

php中文网

发布： 2016-06-06 20:32:53

原创

1328人浏览过

<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了吗？

GPT-MINUS1

通过在文本中随机地用同义词替换单词来愚弄GPT

查看详情

<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>

登录后复制