Tuesday, December 30, 2014

Use BETWEEN AND Clause in Yii QueryBuilder


$command=Yii::app()->db->createCommand();
        $command->select('SUM(amount) AS sum');
        $command->from('sale_info');
        $command->where('user_id='.$_GET['users'].' AND ratingtyle="Initial"');
  $command->andWhere('created_date>:start', array(':start' => $_GET['startdate']));
  $command->andWhere('created_date<:end', array(':end' => $_GET['enddate']));
        echo 'Initial Fee: '.$command->queryScalar();

No comments:

Post a Comment