function getFormTitle($apiKey, $formID)
{
$jotformAPI = new JotForm($apiKey);
$form = $jotformAPI->getForm($formID);
$formTitle = $form['title'];
return $formTitle;
}
function getData($fields)
{
$apiKey = $fields['api'];
$jotform = new JotForm($apiKey);
$form = "";
$output = array();
$columns = array();
$includeForm = array_key_exists('includeForm', $fields);
if ($includeForm) {
array_push($columns, 'Form Name');
}
foreach ($fields as $field => $on) {
if (strpos($field, '_') === false) {
continue;
}
$question = explode('_', $field);
if ($question[0] != $form) {
$submissions = $jotform->getFormSubmissions($question[0]);
$form = $question[0];
if ($includeForm) {
$formInfo = $jotform->getForm($form);
$formName = $formInfo['title'];
}
}
foreach ($submissions as $key => $submission) {
$submission_id = $submission['id'];
if (array_key_exists('answers', $submission)) {
foreach ($submission['answers'] as $key => $answer) {
if (array_key_exists('text', $answer) && array_key_exists('answer', $answer)) {
$fieldTitle = $answer['text'];
$strippedTitle = preg_replace('/\\s+/', '', $fieldTitle);
if ($strippedTitle == $question[2]) {
$columnTitle = $fields['groupby'] == 'name' ? $fieldTitle : preg_replace('/control_/', '', $answer['type']);
if (!in_array($columnTitle, $columns)) {
array_push($columns, $columnTitle);
}
if (!array_key_exists($submission_id, $output)) {
$output[$submission_id] = array();
if ($includeForm) {
$output[$submission_id]['Form Name'] = $formName;
}
}
$text = is_array($answer['answer']) ? implode(' - ', $answer['answer']) : $answer['answer'];
if (array_key_exists($columnTitle, $output[$submission_id])) {
$output[$submission_id][$columnTitle] = $output[$submission_id][$columnTitle] . ' - ' . $text;
} else {
$output[$submission_id][$columnTitle] = $text;
}
}
}
}
}
}
}
createFile($output, $columns, $apiKey);
}
function jotform_mysqldump($apiKey, $formID)
{
// get a list of questions
$jotformAPI = new JotForm($apiKey);
$form = $jotformAPI->getForm($formID);
$formTitle = $form['title'];
$questions = $jotformAPI->getFormQuestions($formID);
$new_questions = array();
$ignored_fields = array("control_head", "control_button", "control_pagebreak", "control_collapse", "control_text");
$i = 0;
foreach ($questions as $q) {
if (!in_array($q['type'], $ignored_fields)) {
array_push($new_questions, $q);
$ordered_questions[$q['order']] = $i++;
}
}
$questions = $new_questions;
//print "<pre>";
//print_r( $questions );
// prepare CREATE TABLE code
$table = mysql_fieldname_format($formTitle);
$sql = "CREATE TABLE IF NOT EXISTS `" . $table . "` (\n";
$fields_sql = array();
$fields = array();
foreach ($ordered_questions as $order => $i) {
$mysql_type = "varchar(255)";
if ($questions[$i]['type'] == "control_textarea") {
$mysql_type = "text";
}
array_push($fields, $questions[$i]['text']);
array_push($fields_sql, "\t`" . mysql_fieldname_format($questions[$i]['text']) . "` " . $mysql_type);
}
$sql .= implode(",\n", $fields_sql);
$sql .= "\n);\n\n";
//print $sql;
// get submission data
$submissions = $jotformAPI->getFormSubmissions($formID);
//print_r($submissions);
foreach ($submissions as $s) {
$insert = "INSERT IGNORE INTO `{$table}` (\n";
$keys = array();
$values = array();
foreach ($fields as $k) {
//print "<li>$k".$s['fields'][$k];
array_push($keys, "`" . mysql_fieldname_format($k) . "`");
array_push($values, "'" . mysql_real_escape_string($s['fields'][$k]) . "'");
}
$insert .= implode(", ", $keys);
$insert .= "\n) VALUES (\n";
$insert .= implode(", ", $values);
$insert .= "\n);\n\n";
$sql .= $insert;
}
return $sql;
}
