manniru
4/1/2018 - 7:22 AM

Insert multiple rows into db, using drupal 7 pdo

Insert multiple rows into db, using drupal 7 pdo

$values = array(
  array(
	'title' => 'Example',
	'uid' => 1,
	'created' => REQUEST_TIME,
  ),
  array(
	'title' => 'Example 2',
	'uid' => 1,
	'created' => REQUEST_TIME,
  ),
  array(
	'title' => 'Example 3',
	'uid' => 2,
	'created' => REQUEST_TIME,
  ),
);
$query = db_insert('node')->fields(array('title', 'uid', 'created'));
foreach ($values as $record) {
  $query->values($record);
}
$query->execute();