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.


$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.

$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.


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


General class for an abstracted MERGE query operation.


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;