php yii2 builk insert code example
Example 1: activerecord batch insert in yii2
Yii::$app->db
->createCommand()
->batchInsert('table_name', ['column1','column2', 'column3','column4','column5'],$data)
->execute();
Example 2: yii2 activerecord bulk insert
// It's usually much easier to use DAO instead of ActiveRecord
// table name, column names, column values
Yii::$app->db->createCommand()->batchInsert('users', ['name', 'age'], [
['Tom', 30],
['Jane', 20],
['Linda', 25],
])->execute();