Criteria condition in yii

Question

I'am having ledger as a model which have a field name account_type.It holds the value credit and debit. If i give credit then it should goes to payment page. If i give debit then it should goes to receipt page. For this i need to give a condition in my actionPayment and actionReceipt. This is my actionPayment code. ``` public function actionPayment() { $criteria = new CDbCriteria(); $criteria->params=(array(':account_type'=>'credit')); $dataProvider=new CActiveDataProvider('Payments'); $this->render('index',array( 'dataProvider'=>$dataProvider, )); } ``` I want to display all the rows in payment page those which are given credit. I'am a beginner to yii. can anyone please help me to solve my problem? This is my view file. ``` id), array('view', 'id'=>$data->id)); ?>
account_type); ?>
refer_no); ?>

Accepted Answer

try this:

```
public function actionPayment()
{
    $criteria = new CDbCriteria();
    $criteria->condition = "account_type = :account_type";
    $criteria->params=(array(':account_type'=>'credit'));
    $dataProvider=new CActiveDataProvider('Payments',array(
        'criteria'=>$criteria,
    ));
    $this->render('index',array(
        'dataProvider'=>$dataProvider,
    )); 
}
```

Criteria condition in yii

Solution

Problem