yii用法

作者: gurlan | 来源:发表于2021-05-25 13:54 被阅读0次

yii输出sql 1.0和2.0都可以用

$query = User::find()->where(['id'=>[1,2,3,4])->select(['username'])
echo $query->createCommand()->getRawSql();

between写法

      $criteria = new CDbCriteria(array('order' => 'day desc'));
      $criteria->addBetweenCondition('day', $startDate, $endDate);
        $query = TotalData::model()->findAllByAttributes([], $criteria);
        $data = [];
        foreach ($query as $v) {
            $data[] = $v->getAttributes();
        }

相关文章

网友评论

      本文标题:yii用法

      本文链接:https://www.haomeiwen.com/subject/xmoqsltx.html