Yii2 查询不返回列总和 [英] Yii2 Query does not return column sum

问题描述

我有这个代码，例如:

$rows = Category::find()
->select('id_category, SUM(p.comments * 10) AS num')
->leftJoin('post p', 'p.id = post_id')
->groupBy('id_category')
->one();

存在:$rows->id_category但这不存在:$rows->num

推荐答案

您的 Category 模型中需要一个名为num"的字段，否则您将无法访问该值.以这种方式添加公共变量 $num

You need a field named 'num' in your Category model otherwise you can't access to this value. add the public var $num this way

class Category extends \yii\db\ActiveRecord
{

    public $num;

    /**
    * @inheritdoc
    */
    public static function tableName()

这篇关于Yii2 查询不返回列总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！