function webform_submission_update in Webform 5.2

Same name and namespace in other branches

1. 6.3 includes/webform.submissions.inc \webform_submission_update()
2. 6.2 webform_submissions.inc \webform_submission_update()
3. 7.4 includes/webform.submissions.inc \webform_submission_update()
4. 7.3 includes/webform.submissions.inc \webform_submission_update()

1 call to webform_submission_update()

webform_client_form_submit in ./webform.module

File

./webform_submissions.inc, line 25

This file is loaded when handling submissions, either submitting new, editing, or viewing. It also contains all CRUD functions for submissions.

Code

function webform_submission_update($node, $sid, $submitted) {

  // Update the submission data by first removing all this submissions data.
  db_query('DELETE FROM {webform_submitted_data} WHERE sid = %d', $sid);

  // Then re-add it to the database.
  foreach ($submitted as $cid => $value) {

    // Don't save pagebreaks as submitted data.
    if ($node->webform['components'][$cid]['type'] == 'pagebreak') {
      continue;
    }
    if (is_array($value)) {
      $delta = 0;
      foreach ($value as $k => $v) {
        db_query("INSERT INTO {webform_submitted_data} (nid, sid, cid, no, data) VALUES (%d, %d, %d, %d, '%s')", $node->nid, $sid, $cid, $delta, $v);
        $delta++;
      }
    }
    else {
      db_query("INSERT INTO {webform_submitted_data} (nid, sid, cid, no, data) VALUES (%d, %d, %d, %d, '%s')", $node->nid, $sid, $cid, 0, $value);
    }
  }
  return $sid;
}