Db::insertMultiple() 

\nn\t3::Db()->insertMultiple($tableName = '', $rows = [], $colOrder = []); 

Insert several lines into database.

use TYPO3\CMS\Core\Database\Connection;

$data = [
    ['title' => 'One', 'tstamp'=>123],
    ['title' => 'Two', 'tstamp'=>123],
];
$colOrder = [
    'tstamp' => Connection::PARAM_INT,
    'title' => Connection::PARAM_STR,
];

\nn\t3::Db()->insertMultiple('table', $data, $colOrder);
Copied!
@param string $tableName
@param array $rows
@param array $colOrder
@return boolean

Source Code 

public function insertMultiple ( $tableName = '', $rows = [], $colOrder = [] )
{
	$connection = $connection = $this->getConnection();
	if (!$rows) {
		return true;
	}
	$flattened = [];
	foreach ($rows as $row) {
		$insert = [];
		foreach ($colOrder as $col=>$type) {
			$insert[] = $row[$col] ?? '';
		}
		$flattened[] = $insert;
	}
	$result = $connection->bulkInsert(
		$tableName,
		$flattened,
		array_keys( $colOrder ),
		array_values( $colOrder ),
	);
	return $result;
}
Copied!