Yii2 activerecord bulk insert

Activerecord batch insert in yii2

Yii::$app->db
->createCommand()
->batchInsert('table_name', ['column1','column2', 'column3','column4','column5'],$data)
->execute();

Source: devprofessor.com

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();

Source: yiiframework.com

Similar codes

5 votes337 views2 answers
Check if array value exists in another array php
PHP
0 vote319 views5 answers
Wordpress png img src= image.png
PHP
10 votes333 views3 answers
Get firstwod php
PHP
5 votes327 views1 answer
Redirect wordpress
PHP
0 vote344 views1 answer
Mysql_fetch_array php
PHP
25 votes328 views2 answers
Php switch 2 variables
PHP
2 votes327 views1 answer
Find word in text in laravel
PHP
12 votes310 views3 answers
Uninstall php ubuntu
PHP
3 votes315 views1 answer
Laravel 7 error npm run dev
PHP
2 votes307 views1 answer
Command to run php file on chrome
PHP