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; }