Guest User

Untitled

a guest
Jan 6th, 2018
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.24 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="utf-8">
  5. <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  6. <meta name="description" content="">
  7. <meta name="author" content="">
  8. <title>Past Paper Website</title>
  9.  
  10. <!-- Bootstrap core CSS -->
  11. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.3/css/bootstrap.min.css" integrity="sha384-Zug+QiDoJOrZ5t4lssLdxGhVrurbmBWopoEl+M6BdEfwnCJZtKxi1KgxUyJq13dy" crossorigin="anonymous">
  12.  
  13. <!-- Custom styles for this template -->
  14. <link href="cover.css" rel="stylesheet">
  15. <!-- AJAX Code -->
  16. <script>
  17. function showUser(str) {
  18. if (str == "") {
  19. document.getElementById("txtHint").innerHTML = "";
  20. return;
  21. } else {
  22. if (window.XMLHttpRequest) {
  23. // code for IE7+, Firefox, Chrome, Opera, Safari
  24. xmlhttp = new XMLHttpRequest();
  25. } else {
  26. // code for IE6, IE5
  27. xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
  28. }
  29. xmlhttp.onreadystatechange = function() {
  30. if (this.readyState == 4 && this.status == 200) {
  31. document.getElementById("txtHint").innerHTML = this.responseText;
  32. }
  33. };
  34. xmlhttp.open("GET","Ajax_bootstrap_0.php?q="+str,true);
  35. xmlhttp.send();
  36. }
  37. }
  38.  
  39.  
  40.  
  41.  
  42. function runUser(str) {
  43. if (str == "") {
  44. document.getElementById("show").innerHTML = "";
  45. return;
  46. } else {
  47. if (window.XMLHttpRequest) {
  48. // code for IE7+, Firefox, Chrome, Opera, Safari
  49. xmlhttp = new XMLHttpRequest();
  50. } else {
  51. // code for IE6, IE5
  52. xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
  53. }
  54. xmlhttp.onreadystatechange = function() {
  55. if (this.readyState == 4 && this.status == 200) {
  56. document.getElementById("show").innerHTML = this.responseText;
  57. }
  58. };
  59. xmlhttp.open("GET","Ajax_bootstrap.php?second="+str,true);
  60. xmlhttp.send();
  61. }
  62. }
  63. </script>
  64.  
  65. <style type="text/css">
  66. body { background: #404040 !important; } /* Adding !important forces the browser to overwrite the default style applied by Bootstrap */
  67. </style>
  68. <style type="text/css">
  69. body {
  70. overflow-x:hidden;
  71. }
  72.  
  73. </style>
  74.  
  75. </head>
  76.  
  77. <body>
  78.  
  79. <nav class="navbar navbar-expand-lg navbar-dark #404040">
  80. <a class="navbar-brand" href="#">Past Paper Website</a>
  81. <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
  82. <span class="navbar-toggler-icon"></span>
  83. </button>
  84. <div class="collapse navbar-collapse" id="navbarNav">
  85. <ul class="navbar-nav">
  86. <li class="nav-item active">
  87. <a class="nav-link" href="#">Home <span class="sr-only">(current)</span></a>
  88. </li>
  89. <li class="nav-item">
  90. <a class="nav-link" href="#">Areas to improve</a>
  91. </li>
  92. <li class="nav-item">
  93. <a class="nav-link" href="#">Add Paper</a>
  94. </li>
  95. </ul>
  96. </div>
  97. </nav>
  98.  
  99. <div class="site-wrapper">
  100. <div class="site-wrapper-inner">
  101.  
  102. <!-- Dropdown -->
  103. <form>
  104. <div class="form-group row">
  105. <div class="col-sm-2"></div>
  106. <label for="chooseyear" class="col-sm-1 col-form-label">Subject</label>
  107. <div class="col-sm-7">
  108. <div class="col-sm-2"></div>
  109. <select class="form-control" name="users" onchange="showUser(this.value)" id="chooseyear">
  110. <option value="">Select a Subject:</option>
  111.  
  112. <?php
  113. $extract="Done";
  114. include("database_info.php");
  115. $servername = servername;
  116. $username = username;
  117. $password = password;
  118. $dbname = dbname;
  119. // Create connection
  120. $conn = new mysqli($servername, $username, $password, $dbname);
  121.  
  122. // Check connection
  123. if ($conn->connect_error) {
  124. die("" . $conn->connect_error);
  125. }
  126. echo "";
  127.  
  128. $sql = "SELECT DISTINCT Subject FROM Papers";
  129. $result = $conn->query($sql);
  130. if ($result->num_rows > 0) {
  131. while($row = $result->fetch_assoc()) {
  132. echo "<option value=".$row["Subject"].">".$row["Subject"]."</option>", "n";
  133. }
  134. }
  135. $conn->close();
  136. ?>
  137. </div>
  138. </select>
  139. </form>
  140. </div>
  141. </div>
  142. <br>
  143. <!-- Table -->
  144. <div id="txtHint"><b>Select a Subject</b></div>
  145.  
  146. </div>
  147. <div class="mastfoot">
  148. <div class="inner">
  149. </div>
  150. </div>
  151. </div>
  152. </div>
  153.  
  154. <!-- Bootstrap core JavaScript
  155. ================================================== -->
  156. <!-- Placed at the end of the document so the pages load faster -->
  157. <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
  158. <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
  159. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.3/js/bootstrap.min.js" integrity="sha384-a5N7Y/aK3qNeh15eJKGWxsqtnX/wWdSZSKp+81YjTmS15nvnvxKHuzaWwXHDli+4" crossorigin="anonymous"></script>
  160. </body>
  161. </html>
Add Comment
Please, Sign In to add comment