Guest User

Untitled

a guest
Feb 11th, 2019
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.11 KB | None | 0 0
  1. $sql = "SELECT
  2. s.Title AS Subject,
  3. s.Subject_ID AS Subject_ID,
  4. c.Title AS Course,
  5. c.Course_ID AS Course_ID
  6. FROM
  7. subjects s
  8. LEFT JOIN courses c ON s.Subject_ID = c.Subject_ID
  9. WHERE s.Faculty_ID = $faculty";
  10.  
  11. $res = mysql_query( $sql );
  12. while ( $row = mysql_fetch_assoc( $res ) ) {
  13. $return[$row["Subject_ID"]][] = array( "Course_ID" => $row["Course_ID"], "Title" => $row["Course"] );
  14. }
  15.  
  16. print_r( $return );
  17.  
  18. switch($_GET["cmd"]) {
  19. case "populateForm" :
  20. $return = json_encode( populateForm() );
  21. break;
  22. case "populateCourses" :
  23. $return = json_encode( populateCourses( $_GET["faculty"] ) );
  24. break;
  25. }
  26.  
  27. echo $return;
  28.  
  29. function populateCourses( $faculty ) {
  30. $sql = "SELECT
  31. s.Title AS Subject,
  32. s.Subject_ID AS Subject_ID,
  33. c.Title AS Course,
  34. c.Course_ID AS Course_ID
  35. FROM
  36. subjects s
  37. LEFT JOIN courses c ON s.Subject_ID = c.Subject_ID
  38. WHERE s.Faculty_ID = $faculty";
  39. $res = mysql_query( $sql );
  40. while ( $row = mysql_fetch_assoc( $res ) ) {
  41. $return[$row["Subject_ID"]][] = array( "Course_ID" => $row["Course_ID"], "Title" => $row["Course"] );
  42. }
  43.  
  44. return $return;
  45. }
  46.  
  47. Array
  48. (
  49. [8] => Array
  50. (
  51. [0] => Array
  52. (
  53. [Course_ID] => 59
  54. [Title] => Core ICT
  55. )
  56.  
  57. [1] => Array
  58. (
  59. [Course_ID] => 60
  60. [Title] => BTEC Business
  61. )
  62.  
  63. [2] => Array
  64. (
  65. [Course_ID] => 61
  66. [Title] => BTEC ICT
  67. )
  68.  
  69. [3] => Array
  70. (
  71. [Course_ID] => 62
  72. [Title] => GCSE Business
  73. )
  74.  
  75. [4] => Array
  76. (
  77. [Course_ID] => 63
  78. [Title] => GCSE ICT
  79. )
  80.  
  81. )
  82.  
  83. [9] => Array
  84. (
  85. [0] => Array
  86. (
  87. [Course_ID] => 64
  88. [Title] => Advance BTEC Business
  89. )
  90.  
  91. [1] => Array
  92. (
  93. [Course_ID] => 65
  94. [Title] => Advance BTEC ICT
  95. )
  96.  
  97. [2] => Array
  98. (
  99. [Course_ID] => 66
  100. [Title] => AS Applied Business
  101. )
  102.  
  103. [3] => Array
  104. (
  105. [Course_ID] => 67
  106. [Title] => AS Applied ICT
  107. )
  108.  
  109. [4] => Array
  110. (
  111. [Course_ID] => 68
  112. [Title] => A2 Applied Business
  113. )
  114.  
  115. [5] => Array
  116. (
  117. [Course_ID] => 69
  118. [Title] => A2 Applied ICT
  119. )
  120.  
  121. [6] => Array
  122. (
  123. [Course_ID] => 70
  124. [Title] => A2 Economics
  125. )
  126.  
  127. [7] => Array
  128. (
  129. [Course_ID] => 71
  130. [Title] => A2 Law
  131. )
  132.  
  133. [8] => Array
  134. (
  135. [Course_ID] => 72
  136. [Title] => GCSE Maths
  137. )
  138.  
  139. [9] => Array
  140. (
  141. [Course_ID] => 73
  142. [Title] => Maths
  143. )
  144.  
  145. [10] => Array
  146. (
  147. [Course_ID] => 74
  148. [Title] => AS Further Maths
  149. )
  150.  
  151. [11] => Array
  152. (
  153. [Course_ID] => 75
  154. [Title] => AS Maths
  155. )
  156.  
  157. [12] => Array
  158. (
  159. [Course_ID] => 76
  160. [Title] => GSE Maths Rs-Sit
  161. )
  162.  
  163. [13] => Array
  164. (
  165. [Course_ID] => 77
  166. [Title] => A2 Further Maths
  167. )
  168.  
  169. [14] => Array
  170. (
  171. [Course_ID] => 78
  172. [Title] => A2 Maths
  173. )
  174.  
  175. )
  176.  
  177. )
  178.  
  179. $('#courses').on("click", "option", function(event) {
  180. var id = $(this).val();
  181. UWA.Data.getJson(Input.URL + '?cmd=populateCourses&faculty=' + id, Input.populateCourses);
  182. })
  183. }
  184.  
  185. Input.populateCourses = function(data) {
  186. $('#courses').empty();
  187. for (var i = 0; i < data.length; i++) {
  188. alert(data[i]);
  189. $('#courses').append('<optgroup label="' + data[i] + '>');
  190. for (var x = 0; x < data[i].length; x++) {
  191. $('#courses').append('<option value="' + data[i][x].Course_ID + '">' + data[i][x].Title + '</option>');
  192. }
  193. $('#courses').append('</optgroup>');
  194. }
  195. }
  196.  
  197. Input.populateCourses = function(data) {
  198. $('#courses').empty();
  199. for (var i = 0; i < data.length; i++) {
  200. alert(data[i]);
  201. $('#courses').append('<optgroup label="' + data[i] + '>');
  202. for (var x = 0; x < data[i].length; x++) {
  203. $('#courses').append('<option value="' + data[i][x].Course_ID + '">' + data[i][x].Title + '</option>');
  204. }
  205. $('#courses').append('</optgroup>');
  206. }
  207. }
  208.  
  209. Input.populateCourses = function(data) {
  210. var html = "";
  211. for (var i = 0; i < data.length; i++) {
  212. html += <optgroup label="' + data[i] + '>';
  213. for (var x = 0; x < data[i].length; x++) {
  214. html += '<option value="' + data[i][x].Course_ID + '">' + data[i][x].Title + '</option>';
  215. }
  216. html += '</optgroup>';
  217. }
  218. $('#courses').empty().html(html);
  219. }
  220.  
  221. Input.populateCourses = function(data) {
  222. var $courses = $('#courses').empty();
  223. var $optgroup;
  224. for (var i = 0; i < data.length; i++) {
  225. $optgroup = $('<optgroup label="' + data[i] + '>').appendTo($courses);
  226. for (var x = 0; x < data[i].length; x++) {
  227. $('<option value="' + data[i][x].Course_ID + '">' + data[i][x].Title + '</option>').appendTo($optgroup);
  228. }
  229. }
  230. }
  231.  
  232. Input.populateCourses = function(data) {
  233. $('#courses').empty();
  234. for (var i in data) {
  235. alert(data[i]);
  236. /*...*/
  237. }
  238. }
Add Comment
Please, Sign In to add comment