public function UpdateQuery::execute

public UpdateQuery::execute()

Executes the UPDATE query.

Return value

The number of rows affected by the update.

Overrides Query::execute

File

includes/database/query.inc, line 1152
Non-specific Database query code. Used by all engines.

Class

UpdateQuery
General class for an abstracted UPDATE operation.

Code

public function execute() {

  // Expressions take priority over literal fields, so we process those first
  // and remove any literal fields that conflict.
  $fields = $this->fields;
  $update_values = array();
  foreach ($this->expressionFields as $field => $data) {
    if (!empty($data['arguments'])) {
      $update_values += $data['arguments'];
    }
    unset($fields[$field]);
  }

  // Because we filter $fields the same way here and in __toString(), the
  // placeholders will all match up properly.
  $max_placeholder = 0;
  foreach ($fields as $field => $value) {
    $update_values[':db_update_placeholder_' . ($max_placeholder++)] = $value;
  }

  if (count($this->condition)) {
    $this->condition->compile($this->connection, $this);
    $update_values = array_merge($update_values, $this->condition->arguments());
  }

  return $this->connection->query((string) $this, $update_values, $this->queryOptions);
}

© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/includes!database!query.inc/function/UpdateQuery::execute/7.x