mods/_standard/tests/results_quest_long.php

   1 <?php\r
   2 /****************************************************************/\r
   3 /* ATutor                                                                                                               */\r
   4 /****************************************************************/\r
   5 /* Copyright (c) 2002-2010                                      */\r
   6 /* Inclusive Design Institute                                   */\r
   7 /* http://atutor.ca                                                                                             */\r
   8 /*                                                              */\r
   9 /* This program is free software. You can redistribute it and/or*/\r
  10 /* modify it under the terms of the GNU General Public License  */\r
  11 /* as published by the Free Software Foundation.                                */\r
  12 /****************************************************************/\r
  13 // $Id$\r
  14 $page = 'tests';\r
  15 define('AT_INCLUDE_PATH', '../../../include/');\r
  16 require(AT_INCLUDE_PATH.'vitals.inc.php');\r
  17 \r
  18 authenticate(AT_PRIV_TESTS);\r
  19 $tid = intval($_REQUEST['tid']);\r
  20 $qid = intval($_GET['qid']);\r
  21 \r
  22 $_pages['mods/_standard/tests/results_quest_long.php']['title_var']  = 'view_responses';\r
  23 $_pages['mods/_standard/tests/results_quest_long.php']['parent'] = 'mods/_standard/tests/results_all_quest.php?tid='.$tid;\r
  24 \r
  25 $_pages['mods/_standard/tests/results_all_quest.php?tid='.$tid]['title_var']  = 'question_statistics';\r
  26 $_pages['mods/_standard/tests/results_all_quest.php?tid='.$tid]['parent']  = 'mods/_standard/tests/index.php';\r
  27 $_pages['mods/_standard/tests/results_all_quest.php?tid='.$tid]['children'] = array('mods/_standard/tests/results_all.php?tid='.$tid);\r
  28 \r
  29 $_pages['mods/_standard/tests/results_all.php?tid='.$tid]['title_var']  = 'mark_statistics';\r
  30 $_pages['mods/_standard/tests/results_all.php?tid='.$tid]['parent']  = 'mods/_standard/tests/results_all_quest.php';\r
  31 \r
  32 \r
  33 if ($_POST['back']) {\r
  34         header('Location: results_all_quest.php?tid='.$tid);\r
  35         exit;\r
  36 }\r
  37 \r
  38 require(AT_INCLUDE_PATH.'header.inc.php');\r
  39 \r
  40 $sql    = "SELECT title FROM ".TABLE_PREFIX."tests WHERE test_id=$tid";\r
  41 $result = mysql_query($sql, $db);\r
  42 $row = mysql_fetch_array($result);\r
  43 \r
  44 echo '<form method="post" action="'.$_SERVER['PHP_SELF'].'">';\r
  45 echo '<input type="hidden" name="tid" value="'.$tid.'">';\r
  46 \r
  47 echo '<div class="input-form">';\r
  48 echo '<h2>'.AT_print($row['title'], 'tests.title').'</h2>';\r
  49 \r
  50 echo '<br /><p>'._AT('response_text').' <strong>'.AT_print(urldecode($_GET['q']), 'tests_questions.question').'</strong></p>';\r
  51 \r
  52 //get the answers\r
  53 $sql = "SELECT count(*), A.answer\r
  54                 FROM ".TABLE_PREFIX."tests_answers A, ".TABLE_PREFIX."tests_results R\r
  55                 WHERE A.question_id=$qid AND R.result_id=A.result_id AND R.final_score<>'' AND R.test_id=$tid\r
  56                 GROUP BY A.answer\r
  57                 ORDER BY A.answer";\r
  58 \r
  59 $result = mysql_query($sql, $db);\r
  60 \r
  61 while ($row = mysql_fetch_assoc($result)) {\r
  62         if ($row['answer'] != -1 && $row['answer'] != '') {\r
  63                 echo '<div class="row">';\r
  64                 echo '-'.AT_print($row['answer'], 'tests_answers.answer');\r
  65                 echo '</div>';\r
  66         }\r
  67 } \r
  68 \r
  69 echo '<div class="row buttons">';\r
  70         echo '<input type="submit" value="'._AT('back').'" name="back" />';\r
  71 echo '</div>';\r
  72 \r
  73 echo '</div></form>';\r
  74 \r
  75 require(AT_INCLUDE_PATH.'footer.inc.php');\r
  76 ?>\r