Saturday, 30 July 2011

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;

"Online Quiz" Php code is made for Distribution purpose;
Modify it as per your requirement.

style="display:inline-block;width:336px;height:280px"
data-ad-client="ca-pub-5656072117057856"
data-ad-slot="8835885279">



SHARE YOUR ARTICLE

If you have any article, photograph, video etc which you want to share with us through our blog. You can send email us at talkduo@gmail.com or click here

5 comments:

  1. thanks for sharing the code .

    ReplyDelete
  2. You can test your knowledge in various subjects like Computer Basics, Computer Hardware, Computer Software, php, javascript, html, software testing,etc at Computer quiz website.

    ReplyDelete
  3. hai..the code very helpful to me..thanks a lot..
    but how the czone-stu-admin-login.php function? just for admin login or what?

    ReplyDelete
  4. database could not connect am getting this message what should i do now

    ReplyDelete