# To send results by e-mail, all you have to do is set your e-mail address here:
$GLOBALS['~file_name~_form_recipient'] = 'fixme@example.com';
~}~~opt_db {~
-# To save results to a database, you'll need to create the ~table_name~ table
-# (the file ~file_name~.sql should help with this), and create the file
-# 'code/db_connect.php' which calls db_connect() see:
-# code/wfpl/examples/db_connect.php
+# To save results to a database, you'll need to create the ~table_name~ table.
+# The file ~file_name~.sql should help with this
#
# if you rename any of the database fields, you'll need to update this:
-
define('~file_name upper~_DB_FIELDS', '~db_fields~');
~}~~upload_settings {~
# Set this to the path to your uploads directory. It can be relative to the
require_once('code/wfpl/email.php');~uploads_include {~
require_once('code/wfpl/upload.php');~}~
+$GLOBALS['~file_name~_field_to_caption'] = array(~name_to_caption {~
+ '~name~' => '~caption phpsq~'~ sep {~,~}~~}~
+);
+
function ~file_name~_get_fields() {
$data = array();
~formats {~
function ~file_name~_csv_download() {
require_once('code/wfpl/csv.php');
$rows = db_get_rows('~table_name~', 'id,'.~file_name upper~_DB_FIELDS, 'order by id');
- array_unshift($rows, explode(',', 'id,'.~file_name upper~_DB_FIELDS));
+ $fields = explode(',', 'id,'.~file_name upper~_DB_FIELDS);
+ $header = array();
+ foreach ($fields as $field) {
+ if (isset($GLOBALS['~file_name~_field_to_caption'][$field])) {
+ $header[] = $GLOBALS['~file_name~_field_to_caption'][$field];
+ } else {
+ $header[] = $field;
+ }
+ }
+ array_unshift($rows, $header);
array2d_to_csv_download($rows, '~file_name~.csv');
}