public function webform_exporter_delimited::add_row in Webform 7.4

Same name and namespace in other branches

1. 5.2 webform_export.inc \webform_exporter_delimited::add_row()
2. 6.3 includes/webform.export.inc \webform_exporter_delimited::add_row()
3. 6.2 webform_export.inc \webform_exporter_delimited::add_row()
4. 7.3 includes/webform.export.inc \webform_exporter_delimited::add_row()

Add a single row to the export file.

Parameters

$file_handle: A PHP file handle to the export file.

array $data: An array of formatted data for this row. One cell per item.

int $row_count: The current number of rows in the export file.

Overrides webform_exporter::add_row

1 method overrides webform_exporter_delimited::add_row()

webform_exporter_excel_delimited::add_row in includes/exporters/webform_exporter_excel_delimited.inc

Add a single row to the export file.

File

includes/exporters/webform_exporter_delimited.inc, line 27

Class

webform_exporter_delimited

Webform exporter for creating CSV/TSV delimited files.

Code

public function add_row(&$file_handle, array $data, $row_count) {
  foreach ($data as $key => $value) {

    // Escape inner quotes and wrap all contents in new quotes.
    $data[$key] = '"' . str_replace('"', '""', $data[$key]) . '"';

    // Remove <script> tags, which mysteriously cause Excel not to import.
    $data[$key] = preg_replace('!<(/?script.*?)>!', '[$1]', $data[$key]);
  }
  $row = implode($this->delimiter, $data) . $this->line_ending;
  @fwrite($file_handle, $row);
}