$data['score'] = 'score'; $data['data'] = 'data'; // fputcsv($csv_output, $data); foreach ($_POST as $question_id => $answer) { $data = array(); $question_type = get_question_type($question_id); //$check = "SELECT * FROM results WHERE study_id = ".$study_id." AND subj_id = ".$subject_id." AND question_id = ".$question_id; //$result = mysql_query($check, $dbconnect); // if(mysql_num_rows($result) == 0){ $questionnaire_id = get_questionnaire_for_question($question_id); $data['subj_id'] = $subject_id; $data['response_id'] = $response_id; $data['study_id'] = $study_id; $data['questionnaire_id'] = $questionnaire_id; $data['question_id'] = $question_id; $data['question_name'] = get_question_name($question_id, 'ro'); $data['question_type'] = $question_type; $data['choice_id'] = null; $data['score'] = null; $data['data'] = null; if ($question_type == 'choice') { $choice_name = get_choice_name($answer, 'ro'); $query = "INSERT INTO results (`study_id`, `subj_id`, `questionnaire_id`, `question_id`, `choice_id`, `data`, `response_id`)\n\t\t\t\t\tVALUES ('" . $study_id . "', '" . $subject_id . "', '" . $questionnaire_id . "', '" . $question_id . "', '" . $answer . "', '" . $choice_name . "' , '" . $response_id . "') "; $result = mysql_query($query, $dbconnect); confirm_query($result); $data['choice_id'] = $answer; $data['score'] = get_choice_score($answer); } elseif ($question_type == 'text') { $query = "INSERT INTO results (`study_id`, `subj_id`, `questionnaire_id`, `question_id`, `data`, `response_id`)\n\t\t\t\t\t\t\t\t\t\tVALUES ('" . $study_id . "', '" . $subject_id . "', '" . $questionnaire_id . "', '" . $question_id . "', '" . mysql_real_escape_string(htmlspecialchars($answer)) . "', '" . $response_id . "') "; $result = mysql_query($query, $dbconnect); confirm_query($result);
// remove deleted choices foreach ($rel_choices as $choice_id) { if (!in_array((int) $choice_id, $sel_choices)) { $query = "DELETE from choices WHERE `choice_id` = '" . $choice_id . "' "; $result = mysql_query($query, $dbconnect); confirm_query($result); } } /* * intrebare noua */ } else { $query = "INSERT INTO questions (`questionnaire_id`,`name`,`type`)\n VALUES ('" . $questionnaire_id . "', '" . $question_name . "', '" . $question_type . "')"; if ($result = mysql_query($query, $dbconnect)) { $question_id = mysql_insert_id(); $question_name = get_question_name($question_id, $lang); $questionnaire_name = get_questionnaire_name($questionnaire_id, $lang); $mesaj[] = "{$question_name} was added to {$questionnaire_name}."; for ($index_c = 1; $index_c <= $_POST['number_of_choices_q' . $index_q]; $index_c++) { $choice["ro"] = htmlspecialchars($_POST["question_" . $index_q . "_choice_" . $index_c . "_ro"]); $choice["en"] = htmlspecialchars($_POST["question_" . $index_q . "_choice_" . $index_c . "_en"]); $choice_name = mysql_real_escape_string(json_encode($choice)); $choice_score = htmlspecialchars($_POST["question_" . $index_q . "_choice_" . $index_c . "_score"]); $query = "INSERT INTO choices (`question_id`, `name`, `score`)\n VALUES ('" . $question_id . "', '" . $choice_name . "', '" . $choice_score . "')"; $result = mysql_query($query, $dbconnect); confirm_query($result); } } } } for ($index_r = 1; $index_r <= 5; $index_r++) {
$query .= " AND `subj_id` = '$subject_id'"; } $result = mysql_query($query); confirm_query($result); while ($row = mysql_fetch_array($result)) { $subject_ids[] = $row['subj_id']; $question_ids[] = $row['question_id']; $header_data['subj_id'] = 'Subject id'; $header_data['subj_name'] = 'Subject name'; if($study_type == '360') { $header_data['rel_subj_name'] = 'Subject evaluated'; $header_data['relation'] = 'Relation'; } $header_data[$row['question_id']] = get_question_name($row['question_id'], $lang); } fputcsv($outstream, $header_data); $subject_ids = array_unique($subject_ids); foreach ($subject_ids as $subj_id) { $response_ids = array(); $query = "SELECT response_id FROM results WHERE `study_id` = '".$study_id."' AND `subj_id` = '".$subj_id."'"; $result = mysql_query($query); confirm_query($result); while ($row = mysql_fetch_assoc($result)) { $response_ids[] = $row['response_id']; } $response_ids = array_unique($response_ids);
__('Answer'); ?> </li> <li class="score"><?php __('Score'); ?> </li> </ul> </li> <?php $query = "SELECT * FROM results WHERE results.subj_id = " . $subject_id . " AND results.study_id = " . $study_id; $result = mysql_query($query, $dbconnect); while ($row = mysql_fetch_array($result)) { $question_name = get_question_name($row['question_id'], $lang); $question_type = get_question_type($row['question_id']); $questionnaire_name = get_questionnaire_name($row['questionnaire_id'], $lang); ?> <li> <ul class="grid"> <li class="title"> <?php echo $question_name; ?> </li> <li class="questionnaire_name"> <?php echo $questionnaire_name; ?> </li>