新手提问：YII框架怎么排序-PHPチュートリアル-php.cn

回复内容：

ホームページ

バックエンド開発

PHPチュートリアル

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

Jun 06, 2016 pm 08:32 PM

php yii

<code>public function actionIndex($id)
    {
 
        $this-&gt;pageTitle = Yii::t('zh_CN', 'PAGE_TITLE_PRODUCT');
 
        $current_product_category_model = ProductCategory::model()-&gt;findByPk($id);
 
 
        $criteria = new CDbCriteria();
        $criteria-&gt;limit = 5;
        $product_category = ProductCategory::model()-&gt;findAll($criteria);
 
        $product_sub_category = ProductSubCategory::model()-&gt;findAll('product_category_id=:product_category_id', array(':product_category_id' =&gt; $id));
 
        $products = Product::model()-&gt;findAll('product_status="online" AND product_category_id=:product_category_id', array(':product_category_id' =&gt; $id));
        $this-&gt;render("index", array(
            "products" =&gt; $products,
            "current_product_category_model" =&gt; $current_product_category_model,
            "product_category" =&gt; $product_category,
            "product_sub_category" =&gt; $product_sub_category,
        ));
    }
</code>

ログイン後にコピー

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

回复内容：

<code>public function actionIndex($id)
    {
 
        $this-&gt;pageTitle = Yii::t('zh_CN', 'PAGE_TITLE_PRODUCT');
 
        $current_product_category_model = ProductCategory::model()-&gt;findByPk($id);
 
 
        $criteria = new CDbCriteria();
        $criteria-&gt;limit = 5;
        $product_category = ProductCategory::model()-&gt;findAll($criteria);
 
        $product_sub_category = ProductSubCategory::model()-&gt;findAll('product_category_id=:product_category_id', array(':product_category_id' =&gt; $id));
 
        $products = Product::model()-&gt;findAll('product_status="online" AND product_category_id=:product_category_id', array(':product_category_id' =&gt; $id));
        $this-&gt;render("index", array(
            "products" =&gt; $products,
            "current_product_category_model" =&gt; $current_product_category_model,
            "product_category" =&gt; $product_category,
            "product_sub_category" =&gt; $product_sub_category,
        ));
    }
</code>

ログイン後にコピー

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

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

<code> $products = Product::model()-&gt;findAll(new CDbCriteria(array(
      "condition" =&gt; 'product_status="online" AND product_category_id=:product_category_id',
      "order" =&gt; "id desc",
      "params" =&gt; array(':product_category_id' =&gt; $id)
   )));
</code>