The YII framework inserts data in batches. The yii framework inserts data in batches.
This article describes how to insert data in batches in the YII framework. We will share this with you for your reference. The details are as follows:
public function insertSeveral($table, $array_columns){ $sql = ''; $params = array(); $i = 0; foreach ($array_columns as $columns) { $names = array(); $placeholders = array(); foreach ($columns as $name => $value) { if (!$i) { $names[] = $this->_connection->quoteColumnName($name); } if ($value instanceof CDbExpression) { $placeholders[] = $value->expression; foreach ($value->params as $n => $v) $params[$n] = $v; } else { $placeholders[] = ':' . $name . $i; $params[':' . $name . $i] = $value; } } if (!$i) { $sql = 'INSERT INTO ' . $this->_connection->quoteTableName($table) . ' (' . implode(', ', $names) . ') VALUES (' . implode(', ', $placeholders) . ')'; } else { $sql .= ',(' . implode(', ', $placeholders) . ')'; } $i++; } return $this->setText($sql)->execute($params);}$rows = array( array('id' => 1, 'name' => 'John'), array('id' => 2, 'name' => 'Mark'));$command = Yii::app()->db->createCommand();$command->insertSeveral('users', $rows);