How to use delete(), insert() and save() methods in YII2?

1.	How to use delete(), insert() and save() methods in YII2?
Answer» 1. delete() $connection->createCommand()->delete('tbl_user', 'status = 1') ->EXECUTE(); 2. SAVE() $model = NEW Admin; $model->name = 'YII2'; $model->email = '[email PROTECTED]'; $model->save(); // this is equivalent to $model->insert(); 3. insert() $connection->createCommand()->insert('tbl_user', [ 'name' => 'yii', 'status' => 1, ]) ->execute();

Answer»

1. delete()

$connection->createCommand()->delete('tbl_user', 'status = 1') ->EXECUTE();

$model = NEW Admin;
$model->name = 'YII2';
$model->email = '[email PROTECTED]';
$model->save(); // this is equivalent to $model->insert();

3. insert()

$connection->createCommand()->insert('tbl_user',
[
'name' => 'yii',
'status' => 1,
])
->execute();

Discussion