Php code for Online Quiz
One Question will appear on a screen when user select the option and click on next question another question appear on screen and after all opting the answer user will click on finish online test then quiz result report will be appear on screen .
Quiz.php
<? include("db_mysql_connect.php"); ?>
<div id="heading">Online Quiz</div>
<br />
<form name="quiz" method="post" action="quiz.php">
<? if($_POST["do"]=="finish")
{
$rans=$_POST["rans"];
$tq=$_POST["tq"];
$end=$_POST["end"];
$startposition=$_POST["startposition"];
echo "<table cellpadding='5px' align='center' style='border:1px solid silver' width='80%' bgcolor='green'>";
echo "<tr><td>Total Question Attempt</td><td>",$tq,"</td><tr>";
echo "<tr><td>Correct Answer</td><td>",$rans,"</td></tr>";
echo "<tr><td>Wrong Answer</td><td>",$tq-$rans,"</td></tr>";
echo "<tr><td>Correct Answer Percentage</td><td>",$rans/$tq*100,"%</td></tr>";
echo "<tr><td>Wrong Answer Percenntage</td><td>",($tq-$rans)/$tq*100,"%</td></tr>";
echo "</table><br><br>";
$query="select * from quiz where qid<='$end' and qid>='$startposition'";
echo "<table cellpadding='5px' align='center' style='border:1px solid silver'>";
echo "<tr><th colspan='4' id='heading'>Online Quiz Test Question</td></tr>";
$result=mysql_query($query);
while ($row = mysql_fetch_array($result)) {
echo "<tr><td>",$row[0],"</td><td colspan='2'>",$row[1],"</td></tr><tr><td></td>";
echo "<td colspan='2'>A. ",$row[2],"</td>";
echo "<td colspan='2'>B. ",$row[3],"</td></tr>";
echo "<tr><td></td><td colspan='2'>C. ",$row[4],"</td>";
echo "<td colspan='1'>D. ",$row[5],"</td></tr>";
echo "<tr><td colspan='4' align='right' style='color:orange'>Correct option is ",strtoupper($row[6]),"</td></tr>";
echo "<tr><td colspan='4' align='right' style='color:orange'><hr></td></tr>";
}
echo "</table>";
echo "<p align='right'><a href='#' onclick='window.print()'>Print</a></p>";
echo "<div style='visibility:hidden;display:none'>";
}
?>
<table cellpadding="5px" width="100%" style="border:1px solid silver">
<?
$start=$_POST["start"];
$s=$_POST["startposition"];
if($start==NULL)
{
$start=$_GET["start"];
$s=$_GET["start"];
}
$useropt=$_POST["useropt"];
$qid=$_POST["qid"];
$rans=$_POST["rans"];
$name=$_POST["name"];
$totalquestion=$_POST["totalquestion"];
if($start==NULL)
$query="select * from quiz where qid='1'";
else
{
$query="select * from quiz where qid='$start'";
}
$result=mysql_query($query);
while ($row = mysql_fetch_array($result)) {
echo "<tr><td>",$row[0],"</td><td colspan='2'>",$row[1],"</td></tr><tr><td></td><td colspan='2'><input type='radio' name='useropt' value='a' /> ",$row[2],"</td><td colspan='2'><input type='radio' name='useropt' value='b' /> ",$row[3],"</td></tr><tr><td></td><td colspan='2'><input type='radio' name='useropt' value='c' /> ",$row[4],"</td><td colspan='2'><input type='radio' name='useropt' value='d' /> ",$row[5],"</td></tr>";
echo "<tr ><td colspan='5' align='right'><input type='hidden' name='name' value='",$name,"'><input type='hidden' name='start' value='",$row[0]+1,"'><input type='hidden' name='qid' value='",$row[0],"'><input type='hidden' name='startposition' value='",$s,"'><input type='submit' value='Next Question'><input type='hidden' name='totalquestion' value='",$totalquestion+1,"'>";
echo "</td></tr>";
}
echo "<tr><td colspan='4'>";
$query="select woptcode from quiz where qid='$qid'";
$result=mysql_query($query);
while ($row = mysql_fetch_array($result)) {
if(strcmp($row[0],$useropt)==0)
{
echo "<input type='hidden' name='rans' value='",$rans+1,"'>";
$rans=$rans+1;
}
else
echo "<input type='hidden' name='rans' value='",$rans,"'>";
}
echo "</td></tr>";
?>
</table>
<center>
<br />
<br />
</form>
<form method="post" action="quiz.php">
<input type="hidden" name="do" value="finish" />
<input type="hidden" name="rans" value="<? echo $rans;?>" />
<input type="hidden" name="name" value="<? echo $name;?>" />
<input type="hidden" name="tq" value="<? echo $totalquestion;?>" />
<input type="hidden" name="end" value="<? echo $start-1;?>" />
<input type="hidden" name="startposition" value="<? echo $s;?>" />
<input type="submit" value="Finish Online Test" />
</form>
Quiz_Entry_Admin.php
<? if($_POST["do"]=="quiz")
{ include("db_mysql_connect.php");
$question=$_POST["question"];
$opt1=$_POST["opt1"];
$opt2=$_POST["opt2"];
$opt3=$_POST["opt3"];
$opt4=$_POST["opt4"];
$woptcode=$_POST["woptcode"];
$query="select * from quiz ";
$temp=1;
$result=mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$temp=$temp+1;
}
$query="insert into quiz values($temp,'$question','$opt1','$opt2','$opt3','$opt4','$woptcode')";
$result=mysql_query($query);
echo "successfully Saved";
}
?>
<form method="post" action="czone-stu-admin-login.php">
<table>
<tr>
<td colspan="2" id="heading">Online Quiz Test Question Entry Module</td>
</tr>
<tr>
<td>Enter Question here </td>
<td><input type="text" name="question" id="gunjan-textbox"/></td>
</tr>
<tr>
<td>Enter First option</td>
<td><input type="text" name="opt1" id="gunjan-textbox" /></td>
</tr>
<tr>
<td>Enter Second option</td>
<td><input type="text" name="opt2" id="gunjan-textbox" /></td>
</tr>
<tr>
<td>Enter Third option</td>
<td><input type="text" name="opt3" id="gunjan-textbox" /></td>
</tr>
<tr>
<td>Enter Fourth option</td>
<td><input type="text" name="opt4" id="gunjan-textbox" /></td>
</tr>
<tr>
<td>Select Right Option code</td>
<td><select name="woptcode" id="gunjan-textbox">
<option value="a">A</option>
<option value="b">B</option>
<option value="c">C</option>
<option value="d">D</option>
</select>
</td>
</tr>
<tr>
<td colspan="2"><input type="hidden" name="do" value="quiz" />
<input type="submit" value="SAVE QUESTION" />
</td>
</tr>
</table>
</form>
db_mysql_connect.php
<?
mysql_connect("localhost");
mysql_select_db("quiz") or die("database could not connect ");
?>
Mysql Table “Quiz”
CREATE TABLE `quiz` (`qid` int(5) default NULL,`Question` text,`opt1` text,`opt2` text,`opt3` text,`opt4` text,`woptcode` varchar(5) default NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;
