Same name in this branch
  1. 10 core/lib/Drupal/Core/Database/Query/Insert.php \Drupal\Core\Database\Query\Insert::execute()
  2. 10 core/modules/mysql/src/Driver/Database/mysql/Insert.php \Drupal\mysql\Driver\Database\mysql\Insert::execute()
  3. 10 core/modules/pgsql/src/Driver/Database/pgsql/Insert.php \Drupal\pgsql\Driver\Database\pgsql\Insert::execute()
  4. 10 core/modules/sqlite/src/Driver/Database/sqlite/Insert.php \Drupal\sqlite\Driver\Database\sqlite\Insert::execute()
Same name and namespace in other branches
  1. 9 core/modules/mysql/src/Driver/Database/mysql/Insert.php \Drupal\mysql\Driver\Database\mysql\Insert::execute()

Executes the insert query.

Return value

int|null|string The last insert ID of the query, if one exists. If the query was given multiple sets of values to insert, the return value is undefined. If no fields are specified, this method will do nothing and return NULL. That That makes it safe to use in multi-insert loops.

Overrides Insert::execute

File

core/modules/mysql/src/Driver/Database/mysql/Insert.php, line 22

Class

Insert
MySQL implementation of \Drupal\Core\Database\Query\Insert.

Namespace

Drupal\mysql\Driver\Database\mysql

Code

public function execute() {
  if (!$this
    ->preExecute()) {
    return NULL;
  }

  // If we're selecting from a SelectQuery, finish building the query and
  // pass it back, as any remaining options are irrelevant.
  if (empty($this->fromQuery)) {
    $max_placeholder = 0;
    $values = [];
    foreach ($this->insertValues as $insert_values) {
      foreach ($insert_values as $value) {
        $values[':db_insert_placeholder_' . $max_placeholder++] = $value;
      }
    }
  }
  else {
    $values = $this->fromQuery
      ->getArguments();
  }
  $stmt = $this->connection
    ->prepareStatement((string) $this, $this->queryOptions);
  try {
    $stmt
      ->execute($values, $this->queryOptions);
    $last_insert_id = $this->connection
      ->lastInsertId();
  } catch (\Exception $e) {
    $this->connection
      ->exceptionHandler()
      ->handleExecutionException($e, $stmt, $values, $this->queryOptions);
  }

  // Re-initialize the values array so that we can re-use this query.
  $this->insertValues = [];
  return $last_insert_id;
}