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); foreach($response_ids as $response_id){ $query = "SELECT * FROM results WHERE `study_id`='".$study_id."' AND `subj_id`='".$subj_id."' AND `response_id`='".$response_id."'"; $result = mysql_query($query); confirm_query($result); while ($row = mysql_fetch_assoc($result)) { $data['subj_id'] = $subj_id; $data['subj_name'] = get_subj_name($subj_id); if($study_type == '360') { $data['rel_subj_name'] = get_subj_name(get_rel_subj_id($subj_id, $response_id)); $data['relation'] = $relatii[get_relation($subj_id, $response_id)]; } $data[$row['question_id']] = $row['data']; } fputcsv($outstream, $data); } } fclose($outstream); } ?>
if ($action == "add") { $mesaj = array(); $query = "INSERT INTO liste (`name`, `desc`, `public`)\n VALUES ('" . $list_name . "', '" . $list_desc . "', '" . $list_public . "')"; $result = mysql_query($query, $dbconnect); confirm_query($result); $list_id = mysql_insert_id(); if (mysql_affected_rows() == 1) { $list_name = get_list_name($list_id, $lang); $mesaj[] = "List {$list_name} has been created."; } foreach ($sel_subjects as $subj_id) { $query = "INSERT INTO rel_subj_list (`list_id`, `subj_id`) VALUES ('" . $list_id . "', '" . $subj_id . "')"; $result = mysql_query($query, $dbconnect); confirm_query($result); if (mysql_affected_rows() == 1) { $subj_name = get_subj_name($subj_id); $mesaj[] = "Subject {$subj_name} has been added to list."; } } $_SESSION["mesaj"] = $mesaj; //output_message(); exit; redirect("view_list.php?list_id=" . $list_id); redirect("manage_lists.php"); } /* end add list */ /* delete list*/ if ($action == "delete") { $mesaj = array(); $list_name = get_list_name($list_id, $lang); $query = "DELETE FROM liste WHERE list_id = '" . $list_id . "'"; $result = mysql_query($query, $dbconnect);
<?php require_once("../includes/header.php") ?> <?php if(isset($_GET["quest_id"]) && isset($_GET["subj_id"]) && isset($_GET["study_id"])) { $quest_id = $_GET["quest_id"]; $subject_id = $_GET["subj_id"]; $subject_name = get_subj_name($subject_id); $quest_name = get_questionnaire_name($quest_id, $lang); $study_id = $_GET["study_id"]; $study_name = get_study_name($study_id, $lang); ?> <h1 class="quest"><?php __("Scoring")?> - <?php echo $quest_name ?></h1> <p><strong><?php __("Subject name") ?></strong>: <?php echo $subject_name; ?></p> <div id="list_details"> <ul> <? $query = "SELECT * FROM results WHERE results.subj_id = ".$subject_id." AND results.study_id = ".$study_id.' AND questionnaire_id='.$quest_id; $result = mysql_query($query, $dbconnect); $quest = array(); while($row = mysql_fetch_assoc($result)) { $quest[] = $row; } //urat dar repede if ($quest_id == 4 || $quest_id == 7)// E-RIBS & M-RIBS { $max = 5; $map = array(
// if (mysql_numrows($tester) == 0) { $subj = mysql_fetch_array($tester); $sub_neevaluati[] = $rel_subject_id; } } if (count($sub_neevaluati) != 0) { ?> <p><strong><em><?php __('Person being evaluated.'); ?> </em></strong></p> <select name="sub_evaluat"> <?php foreach ($sub_neevaluati as $subj_id) { $subject_name = get_subj_name($subj_id) . "<br />"; ?> <option value="<?php echo $subj_id; ?> "><?php echo $subject_name; ?> </option> <?php } ?> </select> <?php } else { ?>
$mesaj[] = "{$subj_first_name} {$subj_last_name} was added to database."; } foreach ($sel_lists as $list_id) { $query = "INSERT INTO rel_subj_list (`list_id`, `subj_id`) VALUES ('" . $list_id . "', '" . $subj_id . "')"; $result = mysql_query($query, $dbconnect); if (mysql_affected_rows() == 1) { $list_name = get_list_name($list_id, $lang); $mesaj[] = "Subject has been added to list {$list_name}."; } } $_SESSION["mesaj"] = $mesaj; redirect("view_subject.php?subj_id=" . $subj_id); } // delete subject if ($action == "delete") { $subj_name = get_subj_name($subj_id, $lang); $mesaj = array(); $query = "DELETE FROM subjects WHERE subj_id = '" . $subj_id . "' "; //echo $query; exit; $result = mysql_query($query, $dbconnect); confirm_query($result); if (mysql_affected_rows() == 1) { $mesaj[] = "Subject {$subj_name} has been deleted."; } $query = "DELETE FROM rel_subj_list WHERE subj_id = '" . $subj_id . "' "; $result = mysql_query($query, $dbconnect); confirm_query($result); if (mysql_affected_rows() >= 1) { $mesaj[] = "Relations to {$subj_name} were removed."; } $_SESSION["mesaj"] = $mesaj;
$list_id = $row["list_id"]; $subjects = get_subj_for_list($list_id); while ($subject = mysql_fetch_array($subjects)) { $subj_ids[] = $subject["subj_id"]; } } if (!empty($subj_ids)) { $subj_ids = array_unique($subj_ids); foreach ($subj_ids as $subj_id) { ?> <li> <a href="view_subject.php?subj_id=<?php echo $subj_id; ?> "><?php echo get_subj_name($subj_id); ?> </a> <?php $check = "SELECT * FROM results WHERE study_id = " . $study_id . " AND subj_id = " . $subj_id; $result = mysql_query($check, $dbconnect); if (mysql_num_rows($result) == 0) { ?> <a href="../fill.php?data=<?php echo base64_encode(implode(',', array($study_id, $subj_id))); ?> "><?php __("[fill]"); ?> </a>