Yii最详细数据库增删改查及其他操作

1.批量增加数据或单条增加: ($codeArrays 是一个二维数组)

$codeArrays = [[$user_id,time(),'1',$member_id,'','兑换码兑换会员']];
$res = \Yii::$app->db->createCommand()->batchInsert('szdato_qyx_user_member',
		['user_id', 'addtime', 'endtime', 'member_id', 'vip_end_time','remarks'], 	$codeArrays)
  		->execute();

2.更新数据:

 $arrcode = $UserCardvipList::find()->where(['redeem_code' => $redeemCode])->one();
 $arrcode->status  = 1;
 $arrcode->bindingtime = $bindtime;
 $arrcode->user_id = $user_id;
 $res = $arrcode->save();

3.批量更新：

$res = UserCardvip::updateAll(['is_delete'=>1],['id'=>$datas]);

4.搜数据：

$sql = "SELECT group_concat(name)  as classification_config_info 
        FROM   szdato_qyx_class