Php code for Online Quiz

Php code for Online Quiz
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>
OUTPUT of Quiz.php

Fig-1

Fig-2
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>
OUTPUT of Quiz_Entry_Admin.php

Fig-3
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;