<form class="addedit" name="addeditquiz" id="addeditquiz" action="<?php
echo htmlspecialchars($_SERVER["PHP_SELF"]);
?>
" method="post" autocomplete="off">
<input type="hidden" name="quizquestionid" id="quizquestionid" value="<?php
echo $question['quizquestionid'];
?>
">
<div class="page-header">
<h1>Add/Edit Question</h1>
</div>
<li>
<label for="question">Question Name</label>
<? displayInput("questionName","text",$question["questionName"]);?>
</li>
<li>
<label for="question">Question</label>
<textarea name="question" cols="45" rows="4"><?php
echo $question["question"];
?>
</textarea>
</li>
<li>
<label for="questionImage">Image</label>
<input type="text" name="questionImage" id="questionImage" value="<?php
echo $question['questionImage'];
?>
">
<table>
<tr><td><label for="quizName">Quiz name: </label></td><td><?php
echo displayInput("quizName", "text", $quiz["quizName"]);
?>
</td></tr>
<tr><td><label for="status">Status</label></td><td><? displayDropDown($quizStatusItems,'status',$quiz['status']); ?></td></tr>
<tr><td>Created Date</td><td><?php
echo $quiz["createdDate"];
?>
</td></tr>
<tr><td><label for="availableDate">Available Date</label></td><td><?php
echo displayInput("availableDate", "date", $quiz["availableDate"]);
?>
</td></tr>
<tr><td><label for="endAvailableDate">End Date</label></td><td><?php
echo displayInput("endAvailableDate", "date", $quiz["endAvailableDate"]);
?>
</td></tr>
<tr><td><label for="active">Active</label></td><td><input type="checkbox" name="active" id="active" value="1"<? if ($quiz['active']==1) { echo " checked"; }?>></td></tr>
</table>
<h2>Questions in this quiz</h2>
<table>
<tr><td>Sort Order</td><td> </td><td>Delete Question</td></tr>
<?
$qlistSql="SELECT question,quizcontentid,sortOrder,quizContent.quizquestionid FROM quizContent INNER JOIN quizQuestion ON quizContent.quizquestionid = quizQuestion.quizquestionid WHERE quizContent.quizid=".$quizid;
$qQuestionList = $db->query($qlistSql)->fetchAll();
foreach($qQuestionList as $qqs){ ?>
<tr><td><input type="text" value="<?php
echo $qqs["sortOrder"];
?>
$qlistSql="SELECT question,questionType,quizContent.quizquestionid FROM quizContent INNER JOIN quizQuestion ON quizContent.quizquestionid = quizQuestion.quizquestionid WHERE quizContent.quizid=".$quizid." ORDER BY quizContent.sortOrder";
$qQuestionList = $db->query($qlistSql)->fetchAll();
foreach($qQuestionList as $qqs){
$qCount++;
?>
<h3><?php
echo $qCount;
?>
. <?php
echo $qqs["question"];
?>
</h3>
<ul>
<? if ($qqs['questionType'] == "text") { ?>
<li><? displayInput($codefieldName."question".$qqs['quizquestionid'],"text",""); ?></li>
<? } else if ($qqs['questionType'] == "true/false") { ?>
<li><? displayRadio($codefieldName."question".$qqs['quizquestionid'],"0|true")?><label for="0|true">True</label></li>
<li><? displayRadio($codefieldName."question".$qqs['quizquestionid'],"0|false")?><label for="0|false">False</label></li>
<? } else { ?>
<?
$answerList = $db->query("SELECT quizanswerid, answer from quizAnswer where quizquestionid=".$qqs['quizquestionid']." ORDER BY RAND()");
//$answerList = $db->select("quizAnswer",array("quizanswerid","answer"),array("quizquestionid"=>$qqs['quizquestionid'],"ORDER"=>"RAND()"));
$aCount=0;
foreach($answerList as $ans) {
$aCount++;
?>
<li><? displayRadio($codefieldName."question".$qqs['quizquestionid'],$ans['quizanswerid']."|".htmlentities($ans['answer']))?><label for="<?php
echo $ans['quizanswerid'];
?>
|<?php
