Implement Sum Query

Yii 1.1 General Discussion
1

I have a code

model:

public function SumDayaTampung(){

   $sumDT = Yii::app()->db->createCommand()


    ->select('sum(daya_tampung) as TotalDT')


    ->from('daya_tampung_s1')


    ->query();


   return $sumDT;


}

controller:

$sumDT= DayaTampungS1::model()->SumDayaTampung();

    $this->render('tabel311',array('sumDT'=>$sumDT));

view:

echo $sumDT->daya_tampung;

and I have an error in view:Property "CDbDataReader.daya_tampung" is not defined.

I really need help

2

using CDbCriteria


        $criteria = new CDbCriteria;

        $criteria->select = '(sum(daya_tampung)) as TotalDT';

        $sumDT =  DayaTampungS1::model()->find($criteria);

        return $sumDT;

and you can defind public property on DayaTampungS1 model


public $TotalDT;

display the output


echo $sumDT->TotalDT;

i hope it’s works

3

otherwise you can not use criteria you can follow the my second two step it’s works…on my last commnet

4

it`s working… thanks