yii\db\QueryBuilder::batchInsert PHP Method

    public function batchInsert($table, $columns, $rows)
    {
        if (empty($rows)) {
            return '';
        }
        $schema = $this->db->getSchema();
        if (($tableSchema = $schema->getTableSchema($table)) !== null) {
            $columnSchemas = $tableSchema->columns;
        } else {
            $columnSchemas = [];
        }
        $values = [];
        foreach ($rows as $row) {
            $vs = [];
            foreach ($row as $i => $value) {
                if (isset($columns[$i], $columnSchemas[$columns[$i]]) && !is_array($value)) {
                    $value = $columnSchemas[$columns[$i]]->dbTypecast($value);
                }
                if (is_string($value)) {
                    $value = $schema->quoteValue($value);
                } elseif ($value === false) {
                    $value = 0;
                } elseif ($value === null) {
                    $value = 'NULL';
                }
                $vs[] = $value;
            }
            $values[] = '(' . implode(', ', $vs) . ')';
        }
        foreach ($columns as $i => $name) {
            $columns[$i] = $schema->quoteColumnName($name);
        }
        return 'INSERT INTO ' . $schema->quoteTableName($table) . ' (' . implode(', ', $columns) . ') VALUES ' . implode(', ', $values);
    }

 /**
  * Generates a batch INSERT SQL statement.
  * For example,
  *
  * ```php
  * $connection->createCommand()->batchInsert('user', ['name', 'age'], [
  *     ['Tom', 30],
  *     ['Jane', 20],
  *     ['Linda', 25],
  * ])->execute();
  * ```
  *
  * Note that the values in each row must match the corresponding column names.
  *
  * @param string $table the table that new rows will be inserted into.
  * @param array $columns the column names
  * @param array $rows the rows to be batch inserted into the table
  * @return string the batch INSERT SQL statement
  */
 public function batchInsert($table, $columns, $rows)
 {
     if (empty($rows)) {
         return '';
     }
     // SQLite supports batch insert natively since 3.7.11
     // http://www.sqlite.org/releaselog/3_7_11.html
     $this->db->open();
     // ensure pdo is not null
     if (version_compare($this->db->pdo->getAttribute(\PDO::ATTR_SERVER_VERSION), '3.7.11', '>=')) {
         return parent::batchInsert($table, $columns, $rows);
     }
     $schema = $this->db->getSchema();
     if (($tableSchema = $schema->getTableSchema($table)) !== null) {
         $columnSchemas = $tableSchema->columns;
     } else {
         $columnSchemas = [];
     }
     $values = [];
     foreach ($rows as $row) {
         $vs = [];
         foreach ($row as $i => $value) {
             if (!is_array($value) && isset($columnSchemas[$columns[$i]])) {
                 $value = $columnSchemas[$columns[$i]]->dbTypecast($value);
             }
             if (is_string($value)) {
                 $value = $schema->quoteValue($value);
             } elseif ($value === false) {
                 $value = 0;
             } elseif ($value === null) {
                 $value = 'NULL';
             }
             $vs[] = $value;
         }
         $values[] = implode(', ', $vs);
     }
     foreach ($columns as $i => $name) {
         $columns[$i] = $schema->quoteColumnName($name);
     }
     return 'INSERT INTO ' . $schema->quoteTableName($table) . ' (' . implode(', ', $columns) . ') SELECT ' . implode(' UNION SELECT ', $values);
 }