Advertisement
Guest User

Untitled

a guest
Feb 2nd, 2016
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.45 KB | None | 0 0
  1. <form action="grades.php" method="post" id="quiz">
  2. <?php
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "root";
  6. $dbname = "qbank";
  7.  
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9. if ($conn->connect_error) {
  10. die("Connection failed: " . $conn->connect_error);
  11. }
  12.  
  13. $sql = "SELECT Question, AnswerA, AnswerB, AnswerC, AnswerD, AnswerE, CorrectAnswer FROM qbanktable ORDER BY RAND() LIMIT 1";
  14. $result = $conn->query($sql);
  15.  
  16.  
  17. ?>
  18.  
  19. <h3>
  20. <?php
  21.  
  22. $result = $conn->query($sql);
  23.  
  24. if ($result->num_rows > 0) {
  25. // output data of each row
  26. while($row = $result->fetch_assoc()) {
  27. echo $row["Question"];
  28. }
  29. }
  30. ?>
  31.  
  32. </h3>
  33. <p>&nbsp;</p>
  34. <div>
  35. <input type="radio" name="question-1-answers" id="question-1-answers-A" value="A" />
  36. <label for="question-1-answers-A">A)&nbsp;
  37. <?php
  38. $result = $conn->query($sql);
  39. if ($result->num_rows > 0) {
  40. while($row = $result->fetch_assoc()) {
  41. echo $row["AnswerA"];
  42. }
  43. }
  44. ?>
  45. </label>
  46. </div>
  47.  
  48. <div>
  49. <input type="radio" name="question-1-answers" id="question-1-answers-B" value="B" />
  50. <label for="question-1-answers-B3">B)&nbsp;
  51. <?php
  52. $result = $conn->query($sql);
  53. if ($result->num_rows > 0) {
  54. while($row = $result->fetch_assoc()) {
  55. echo $row["AnswerB"];
  56. }
  57. }
  58. ?>
  59. </label>
  60. </div>
  61.  
  62. <div>
  63. <input type="radio" name="question-1-answers" id="question-1-answers-C" value="C" />
  64. <label for="question-1-answers-C3">C)&nbsp;
  65. <?php
  66. $result = $conn->query($sql);
  67. if ($result->num_rows > 0) {
  68. while($row = $result->fetch_assoc()) {
  69. echo $row["AnswerC"];
  70. }
  71. }
  72. ?>
  73. </label>
  74. </div>
  75.  
  76. <div>
  77. <input type="radio" name="question-1-answers" id="question-1-answers-D" value="D" />
  78. <label for="question-1-answers-D3">D)&nbsp;
  79. <?php
  80. $result = $conn->query($sql);
  81. if ($result->num_rows > 0) {
  82. while($row = $result->fetch_assoc()) {
  83. echo $row["AnswerD"];
  84. }
  85. }
  86. ?>
  87. </label>
  88. </div>
  89. <div>
  90. <input type="radio" name="question-1-answers" id="question-1-answers-D" value="E" />
  91. <label for="question-1-answers-D3">E)&nbsp;
  92. <?php
  93. $result = $conn->query($sql);
  94. if ($result->num_rows > 0) {
  95. while($row = $result->fetch_assoc()) {
  96. echo $row["AnswerE"];
  97. }
  98. }
  99. ?>
  100. </label>
  101. </div>
  102. </ol>
  103.  
  104. <input type="submit" class="hvr-grow" value="SUBMIT" />
  105. </form>
  106.  
  107. <h1 class="results">
  108.  
  109.  
  110. <?php
  111.  
  112. $answer1 = $_POST['question-1-answers'];
  113.  
  114. if ($answer1 == $row["CorrectAnswer"]) {
  115.  
  116. echo "<img src=correct.svg";
  117. }
  118. else {
  119. echo "<img src=wrong.svg";
  120. }
  121.  
  122.  
  123.  
  124. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement