Advertisement
Guest User

Untitled

a guest
Feb 5th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.72 KB | None | 0 0
  1. function getQuizes($quizNo)
  2. {
  3. if($quizNo==NULL)
  4. {
  5. $quizNo=0;
  6. }
  7. require('database.php');
  8. $sql = "SELECT * FROM quiz LIMIT ".$quizNo.",1";
  9. $result = $conn->query($sql);
  10. while($row=$result->fetch_assoc())
  11. {
  12. echo $row['question'];
  13. }
  14. $quizNo++;
  15. $sql = "SELECT * FROM quiz";
  16. $result = $conn->query($sql);
  17. $rowcount=mysqli_num_rows($result);
  18.  
  19. if($quizNo>=$rowcount)
  20. {
  21. $quizNo=0;
  22. }
  23. return $quizNo;
  24. }
  25.  
  26. function getQuizes_answer1($quizNo)
  27. {
  28. include_once('database.php');
  29. if($quizNo!=0)
  30. {
  31. $quizNo--;
  32. }
  33. $sql = "SELECT * FROM quiz LIMIT ".$quizNo.",1";
  34. $result = $conn->query($sql);
  35. while($row=$result->fetch_assoc())
  36. {
  37. echo $row['answer1'];
  38. }
  39. $sql = "SELECT * FROM quiz";
  40. $result = $conn->query($sql);
  41. $rowcount=mysqli_num_rows($result);
  42. if($quizNo>=$rowcount)
  43. {
  44. $quizNo=0;
  45. }
  46. $conn->close();
  47. }
  48.  
  49. <?php
  50. $i = isset($_SESSION['next']) ? $_SESSION['next'] : NULL;
  51. if(isset($_POST['next']))
  52. {
  53. $i = getQuizes($i);
  54. $_SESSION['next'] = $i;
  55. ?>
  56. <div class="answers_block">
  57. <table>
  58. <tr>
  59. <td><?php getQuizes_answer1($i);?></td>
  60. </tr>
  61. </table>
  62. </div>
  63. <?php
  64. }
  65. ?>
  66. <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
  67. <input name="next" value="Next" type="submit" />
  68. </form>
  69.  
  70. <?php
  71. $servername = "localhost";
  72. $username = "root";
  73. $password = "";
  74. $database="quiz_db";
  75. // Create connection
  76. $conn = new mysqli($servername, $username, $password, $database);
  77. // Check connection
  78. if ($conn->connect_error) {
  79. die("Connection failed: " . $conn->connect_error);
  80. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement