1 query.inc public MergeQuery::fields(array $fields, array $values = array())

Sets common field-value pairs in the INSERT and UPDATE query parts.

This method should only be called once. It may be called either with a single associative array or two indexed arrays. If called with an associative array, the keys are taken to be the fields and the values are taken to be the corresponding values to set. If called with two arrays, the first array is taken as the fields and the second array is taken as the corresponding values.

Parameters

array $fields: An array of fields to insert, or an associative array of fields and values. The keys of the array are taken to be the fields and the values are taken to be corresponding values to insert.

array $values: An array of values to set into the database. The values must be specified in the same order as the $fields array.

Return value

MergeQuery: The called object.

File

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

Class

MergeQuery
General class for an abstracted MERGE query operation.

Code

public function fields(array $fields, array $values = array()) {
  if ($values) {
    $fields = array_combine($fields, $values);
  }
  foreach ($fields as $key => $value) {
    $this->insertFields[$key] = $value;
    $this->updateFields[$key] = $value;
  }
  $this->needsUpdate = TRUE;
  return $this;
}