Advertisement
Guest User

Untitled

a guest
Jan 19th, 2016
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.81 KB | None | 0 0
  1. <?php
  2. session_start();
  3. include "dbFunctions.php";
  4. IF (isset($_SESSION['parent_nric'])){
  5. $theNRIC = $_SESSION['parent_nric'];
  6.  
  7. $query = "SELECT student.student_id, cca.cca_id, cca.cca_name, cca.cca_size, cca_category.category_id, cca_category.category_name FROM choices, student, parent, cca, cca_category WHERE student.student_id = choices.student_id and choices.cca_id=cca.cca_id AND cca.category_id=cca_category.category_id and student.parent_nric = parent.parent_nric and parent.parent_nric='".$theNRIC."'";
  8. $result = mysqli_query($link, $query) or die('Error querying database');
  9. $row = mysqli_fetch_array($result);
  10.  
  11. // create sql query
  12. $categoryQuery = "SELECT * FROM cca_category";
  13.  
  14. // execute sql query
  15. $categoryResult1 = mysqli_query($link, $categoryQuery) or die('Error querying database');
  16. $categoryResult2 = mysqli_query($link, $categoryQuery) or die('Error querying database');
  17. $categoryResult3 = mysqli_query($link, $categoryQuery) or die('Error querying database');
  18.  
  19. ?>
  20.  
  21. <!DOCTYPE html>
  22. <html lang="en">
  23.  
  24. <head>
  25.  
  26. <meta charset="utf-8">
  27. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  28. <meta name="viewport" content="width=device-width, initial-scale=1">
  29. <meta name="description" content="">
  30. <meta name="author" content="">
  31.  
  32. <title>CCA Registration System</title>
  33.  
  34. <!-- Bootstrap Core CSS -->
  35. <link href="css/bootstrap.min.css" rel="stylesheet">
  36.  
  37. <!-- Custom CSS -->
  38. <link href="css/shop-homepage.css" rel="stylesheet">
  39. <script language="javascript" type="text/javascript">
  40. function showCCADropDown1() {
  41. var str1 = document.getElementById("choice1").value;
  42. if (window.XMLHttpRequest) {
  43. // code for IE7+, Firefox, Chrome, Opera, Safari
  44. xmlhttp = new XMLHttpRequest();
  45. } else {
  46. // code for IE6, IE5
  47. xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
  48. }
  49. xmlhttp.onreadystatechange = function () {
  50. if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
  51. document.getElementById("ajaxDiv1").innerHTML = xmlhttp.responseText;
  52. }
  53. };
  54. xmlhttp.open("GET", "getCCADropDown.php?cat_id=" + str1, true);
  55. xmlhttp.send();
  56. }
  57. function showCCADropDown2() {
  58. var str2 = document.getElementById("choice2").value;
  59. if (window.XMLHttpRequest) {
  60. // code for IE7+, Firefox, Chrome, Opera, Safari
  61. xmlhttp = new XMLHttpRequest();
  62. } else {
  63. // code for IE6, IE5
  64. xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
  65. }
  66. xmlhttp.onreadystatechange = function () {
  67. if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
  68. document.getElementById("ajaxDiv2").innerHTML = xmlhttp.responseText;
  69. }
  70. };
  71. xmlhttp.open("GET", "getCCADropDown.php?cat_id=" + str2, true);
  72. xmlhttp.send();
  73. }
  74. function showCCADropDown3() {
  75. var str3 = document.getElementById("choice3").value;
  76. if (window.XMLHttpRequest) {
  77. // code for IE7+, Firefox, Chrome, Opera, Safari
  78. xmlhttp = new XMLHttpRequest();
  79. } else {
  80. // code for IE6, IE5
  81. xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
  82. }
  83. xmlhttp.onreadystatechange = function () {
  84. if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
  85. document.getElementById("ajaxDiv3").innerHTML = xmlhttp.responseText;
  86. }
  87. };
  88. xmlhttp.open("GET", "getCCADropDown.php?cat_id=" + str3, true);
  89. xmlhttp.send();
  90. }
  91. </script>
  92.  
  93.  
  94. <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  95. <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  96. <!--[if lt IE 9]>
  97. <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
  98. <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
  99. <![endif]-->
  100.  
  101. </head>
  102.  
  103. <body>
  104.  
  105. <!-- Navigation -->
  106. <nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
  107. <div class="container">
  108. <!-- Brand and toggle get grouped for better mobile display -->
  109. <div class="navbar-header">
  110. <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
  111. <span class="sr-only">Toggle navigation</span>
  112. <span class="icon-bar"></span>
  113. <span class="icon-bar"></span>
  114. <span class="icon-bar"></span>
  115. </button>
  116. <a class="navbar-brand" href="#">CCA Registration System</a>
  117. </div>
  118. <!-- Collect the nav links, forms, and other content for toggling -->
  119. <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
  120. <ul class="nav navbar-nav">
  121. <li>
  122. <a href="#">Browse CCA</a>
  123. </li>
  124. <li>
  125. <a href="parent_cca_choice.php">CCA Choices</a>
  126. </li>
  127. <li>
  128. <a href="parent_edit_maintain_personal_information.php">Maintain Personal Information</a>
  129. </li>
  130. <li>
  131. <a href="parent_maintain_student_information.php">Maintain Student Information</a>
  132. </li>
  133. <li>
  134. <a href="logout.php">Logout</a>
  135. </li>
  136. </ul>
  137. </div>
  138. <!-- /.navbar-collapse -->
  139. </div>
  140. <!-- /.container -->
  141. </nav>
  142. <center>
  143. <br>
  144. <br>
  145. <br>
  146. <!-- Page Content -->
  147. <h3><u>Add CCA Choices</u></h3>
  148. <br>
  149. <form role="form" method="post" action="do_parent_submit_cca_choice.php">
  150. <div style="width:350px;">
  151. <label for="category1">1st Choice:</label>
  152. <select class="form-control" id="choice1" name="choice1" onchange="showCCADropDown1()">
  153. <option value="0">All Category</option>
  154. <?php
  155. while ($categoryRow1 = mysqli_fetch_assoc($categoryResult1)) {
  156. ?>
  157. <option value ="<?php echo $categoryRow1['category_id']; ?>">
  158. <?php echo $categoryRow1['category_name']; ?>
  159. </option>
  160. <?php
  161. }
  162. ?>
  163. </select>
  164. <div id='ajaxDiv1'></div>
  165. </div>
  166. <br>
  167. <div class="row">
  168. <div style="width:350px;">
  169. <label for="category2">2nd Choice:</label>
  170. <select class="form-control" id="choice2" name="choice2" onchange="showCCADropDown2()">
  171. <option value="0">All Category</option>
  172. <?php
  173. while ($categoryRow2 = mysqli_fetch_assoc($categoryResult2)) {
  174. ?>
  175. <option value ="<?php echo $categoryRow2['category_id']; ?>">
  176. <?php echo $categoryRow2['category_name']; ?>
  177. </option>
  178. <?php
  179. }
  180. ?>
  181. </select>
  182. <div id='ajaxDiv2'></div>
  183. </div>
  184. </div>
  185. <br>
  186. <div class="row">
  187. <div style="width:350px;">
  188. <label for="category3">3rd Choice:</label>
  189. <select class="form-control" id="choice3" name="choice3" onchange="showCCADropDown3()">
  190. <option value="0">All Category</option>
  191. <?php
  192. while ($categoryRow3 = mysqli_fetch_assoc($categoryResult3)) {
  193. ?>
  194. <option value ="<?php echo $categoryRow3['category_id']; ?>">
  195. <?php echo $categoryRow3['category_name']; ?>
  196. </option>
  197. <?php
  198. }
  199. ?>
  200. </select>
  201. <div id='ajaxDiv3'></div>
  202. </div>
  203. </div>
  204. <br>
  205. <input type="hidden" id="student_id" name="student_id" value="<?php echo $row['student_id'] ?>" />
  206. <input type="submit" Value="Submit Choices" class="btn btn-info btn-lg"/>
  207. </form>
  208. <?php }else {
  209. echo"you are unable to view this page";
  210. }
  211. ?>
  212.  
  213.  
  214. </center>
  215.  
  216. <!-- Footer -->
  217. <!-- Footer -->
  218. <footer>
  219. <div class="row">
  220. <div class="col-lg-12">
  221. <p>Copyright &copy; 4 Aces</p>
  222. </div>
  223. </div>
  224. </footer>
  225.  
  226. </div>
  227. <!-- /.container -->
  228.  
  229. <!-- jQuery -->
  230. <script src="js/jquery.js"></script>
  231.  
  232. <!-- Bootstrap Core JavaScript -->
  233. <script src="js/bootstrap.min.js"></script>
  234.  
  235. </body>
  236.  
  237. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement