yii2 增删改查 [ 2.0 版本 ]

$user= new User;         
$user->username =$username;  
$user->password =$password;  
$user->save()

Yii::$app->db->createCommand()->insert('user', [  
    'name' => 'test',  
    'age' => 30,  
])->execute();

Yii::$app->db->createCommand()->batchInsert('user', ['name', 'age'], [  
    ['test01', 30],  
    ['test02', 20],  
    ['test03', 25],  
])->execute();

$user = User::find()->where(['name'=>'test'])->one(); //获取name等于test的模型
$user->age = 40; //修改age属性值
$user->save(); //保存

$result = User::model()->updateAll(['age'=>40],['name'=>'test']);

Yii::$app->db->createCommand()->update('user', ['age' => 40], 'name = test')->execute();

$user = User::find()->where(['name'=>'test'])->one();

$user->delete();

$result = User::deleteAll(['age'=>'30']);

$result = User::deleteByPk(1);

Yii::$app->db->createCommand()->delete('user', 'age = 30')->execute();

$data = User::find()->where(['age'=> 23])->asArray()->one();

$data = User::find()->where(['age'=> 23])->asArray()->all();

$data = User::find()->where(['age'=> 23])->sum('age');