API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 6th, 2017
106
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.24 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. $database = mysql_connect("localhost", "group2", "writephp");
  3.  
  4. if(!$database)
  5. {
  6. die('Could not connect' . mysql_error());
  7. }
  8.  
  9. mysql_select_db("sefaddenedelman", $database);
  10.  
  11. function encrypted($unencryptedPassword, $username) /* This function will be kept in Wingdings or something */
  12. {
  13. $encryptedPassword = $unencryptedPassword . $username;
  14.  
  15. for($r = 0; $r < sizeof($encryptedPassowrd); $r = $r + 1)
  16. {
  17. if($encryptedPassword[$r] == 'A')
  18. {
  19. $encryptedPassword[$r] == 'y';
  20. }
  21. else if($encryptedPassword[$r] == 'E')
  22. {
  23. $encryptedPassword[$r] == 'u';
  24. }
  25. else if($encryptedPassword[$r] == 'I')
  26. {
  27. $encryptedPassword[$r] == 'o';
  28. }
  29. else if($encryptedPassword[$r] == 'O')
  30. {
  31. $encryptedPassword[$r] == 'i';
  32. }
  33. else if($encryptedPassword[$r] == 'U')
  34. {
  35. $encryptedPassword[$r] == 'e';
  36. }
  37. else if($encryptedPassword[$r] == 'Y')
  38. {
  39. $encryptedPassword[$r] == 'a';
  40. }
  41. else if($encryptedPassword[$r] == 'a')
  42. {
  43. $encryptedPassword[$r] == 'Y';
  44. }
  45. else if($encryptedPassword[$r] == 'e')
  46. {
  47. $encryptedPassword[$r] == 'U';
  48. }
  49. else if($encryptedPassword[$r] == 'i')
  50. {
  51. $encryptedPassword[$r] == 'O';
  52. }
  53. else if($encryptedPassword[$r] == 'o')
  54. {
  55. $encryptedPassword[$r] == 'I';
  56. }
  57. else if($encryptedPassword[$r] == 'u')
  58. {
  59. $encryptedPassword[$r] == 'E';
  60. }
  61. else if($encryptedPassword[$r] == 'y')
  62. {
  63. $encryptedPassword[$r] == 'A';
  64. }
  65. }
  66.  
  67. return $encryptedPassword;
  68. }
  69.  
  70. function/*bool*/ isDateInRange($sSeason, $sYear, $eSeason, $eYear, $testSubject)
  71. {
  72. if($sSeason == "Spring")
  73. {
  74. $startingDateString = 10 * $sYear;
  75. }
  76. else
  77. {
  78. $startingDateString = (10 * $sYear) + 1;
  79. }
  80.  
  81. if($eSeason == "Spring")
  82. {
  83. $endingDateString = 10 * $eYear;
  84. }
  85. else
  86. {
  87. $endingDateString = (10 * $eYear) + 1;
  88. }
  89.  
  90. if($startingDateString <= $testSubject && $testSubject <= $endingDateString)
  91. {
  92. return true;
  93. }
  94. else
  95. {
  96. return false;
  97. }
  98. }
  99. ?>
  100. <html>
  101. <head>
  102. <title>Geneva College Credit Bank - Results</title>
  103. </head>
  104. <body>
  105. <?php
  106. if(isset($_POST["addProfessor"]))
  107. {
  108. $pCountFile = fopen("/var/www/apache/bankProfessorCounterC.txt", "r"); /* Should be initialized to 0 when the project is delivered */
  109. if(!$pCountFile)
  110. {
  111. die('Could not connect!');
  112. }
  113. $numProfessors = fgets($pCountFile);
  114. fclose($pCountFile);
  115.  
  116. $numProfessors = $numProfessors + 1;
  117.  
  118. $pCountFile = fopen("/var/www/apache/bankProfessorCounterC.txt", "w");
  119. if(!$pCountFile)
  120. {
  121. die('Could not connect');
  122. }
  123. fwrite($pCountFile, $numProfessors);
  124. fclose($pCountFile);
  125.  
  126. $professorName = $_POST["professorName"];
  127. $department = $_POST["department"];
  128. $accessLevel = $_POST["accessLevel"];
  129. $professorUsername = $_POST["professorUsername"];
  130. $professorPassword = $_POST["professorPassword"];
  131.  
  132. mysql_query("INSERT INTO Professor VALUES (" . mysql_real_escape_string($numProfessors) . ", \"" . mysql_real_escape_string($professorName) . "\", \"" . mysql_real_escape_string($department) . "\", \"" . mysql_real_escape_string($accessLevel) . "\", \"" . mysql_real_escape_string($professorUsername) . "\", \"" . mysql_real_escape_string(encrypted($professorPassword, $professorUsername) . "\");") OR print(mysql_error());
  133. }
  134. else if(isset($_POST["addCourse"]))
  135. {
  136. $cCountFile = fopen("/var/www/apache/bankCourseCounterC.txt", "r"); /* Should be initialized to 0 when the project is delivered */
  137. if(!$cCountFile)
  138. {
  139. die('Could not connect!');
  140. }
  141. $numCourses = fgets($cCountFile);
  142. fclose($cCountFile);
  143.  
  144. $numCourses = $numCourses + 1;
  145.  
  146. $cCountFile = fopen("/var/www/apache/bankCourseCounterC.txt", "w");
  147. if(!$cCountFile)
  148. {
  149. die('Could not connect');
  150. }
  151. fwrite($cCountFile, $numCourses);
  152. fclose($cCountFile);
  153.  
  154. $courseName = $_POST["courseName"];
  155. $loadValue = $_POST["loadValue"];
  156.  
  157. mysql_query("INSERT INTO Course VALUES (" . mysql_real_escape_string($numCourses) . ", \"" . mysql_real_escape_string($courseName) . "\", " . mysql_real_escape_string($loadValue) . ");") OR print(mysql_error());
  158. }
  159. else if(isset($_POST["addTransaction"]))
  160. {
  161. $tCountFile = fopen("/var/www/apache/bankTransactionCounterC.txt", "r"); /* Should be initialized to 0 when the project is delivered */
  162. if(!$tCountFile)
  163. {
  164. die('Could not connect!');
  165. }
  166. $numTransactions = fgets($tCountFile);
  167. fclose($tCountFile);
  168.  
  169. $numTransactions = $numTransactions + 1;
  170.  
  171. $tCountFile = fopen("/var/www/apache/bankTransactionCounterC.txt", "w");
  172. if(!$tCountFile)
  173. {
  174. die('Could not connect');
  175. }
  176. fwrite($tCountFile, $numTransactions);
  177. fclose($tCountFile);
  178.  
  179. $addOrSubtract = $_POST["addOrSubtract"];
  180. $processDate = $_POST["processDate"];
  181. $professorID = $_POST["transactionProfessorID"];
  182. $courseID = $_POST["transactionCourseID"];
  183. $semester = $_POST["transactionSemesterSeason"] . " " . $_POST["transactionSemesterYear"];
  184. $loadType = $_POST["loadType"];
  185.  
  186. mysql_query("INSERT INTO Transaction VALUES (" . mysql_real_escape_string($numTransactions) . ", \"" . mysql_real_escape_string($addOrSubtract) . "\", \"" . mysql_real_escape_string($processDate) . "\", " . mysql_real_escape_string($professorID) . ", " . mysql_real_escape_string($courseID) . ", \"" . mysql_real_escape_string($semester) . "\", \"" . mysql_real_escape_string($loadType) . "\");") OR print(mysql_error());
  187. }
  188. else if(isset($_POST["removeProfessor"]))
  189. {
  190. mysql_query("DELETE FROM Professor WHERE ID = " . $_POST["removeProfessorID"] . ";");
  191. }
  192. else if(isset($_POST["removeCourse"]))
  193. {
  194. mysql_query("DELETE FROM Course WHERE ID = " . $_POST["removeCourseID"] . ";");
  195. }
  196. else if(isset($_POST["administratorAll"]))
  197. {
  198. $result = mysql_query("SELECT * FROM Professor INNER JOIN (Transaction INNER JOIN Course ON Transaction.CourseID = Course.CourseID) ON Transaction.ProfessorID = Professor.ProfessorID;") OR print(mysql_error());
  199. ?>
  200. <ul>
  201. <?php
  202. while($row = mysql_fetch_array($result))
  203. {
  204. ?>
  205. <li>
  206. <font size="3">
  207. Professor number&nbsp;
  208. <?=$row['ProfessorID']?>
  209. &nbsp;| Course number&nbsp;
  210. <?=$row['CourseID']?>
  211. &nbsp;| Transaction number&nbsp;
  212. <?=$row['TransactionID']?><br />
  213. <?=$row['AdditionOrSubtraction']?>
  214. ed&nbsp;
  215. <?=$row['LoadValue']?>
  216. &nbsp;on&nbsp;
  217. <?=$row['ProcessDate']?><br /><br />;
  218. </font>
  219. </li>
  220. <?php
  221. }
  222. ?>
  223. </ul>
  224. <?php
  225. }
  226. else if(isset($_POST["administratorAllRange"]))
  227. {
  228. $adminAllStartingSeason = $_POST["administratorSearchAllSemesterSeasonStart"];
  229. $adminAllStartingYear = $_POST["administratorSearchAllSemesterYearStart"];
  230. $adminAllEndingSeason = $_POST["administratorSearchAllSemesterSeasonEnd"];
  231. $adminAllEndingYear = $_POST["administratorSearchAllSemesterYearEnd"];
  232.  
  233. $result = mysql_query("SELECT * FROM Professor INNER JOIN (Transaction INNER JOIN Course ON Transaction.CourseID = Course.CourseID) ON Transaction.ProfessorID = Professor.ProfessorID;") OR print(mysql_error());
  234. ?>
  235. <ul>
  236. <?php
  237. while($row = mysql_fetch_array($result))
  238. {
  239. if($row['Semester'][0] == 'S')
  240. {
  241. $semesterStringValue = (10000 * $row['Semester'][7]) + (1000 * $row['Semester'][8]) + (100 * $row['Semester'][9]) + (10 * $row['Semester'][10]);
  242. }
  243. else if($row['Semester'][0] == 'F')
  244. {
  245. $semesterStringValue = (10000 * $row['Semester'][5]) + (1000 * $row['Semester'][6]) + (100 * $row['Semester'][7]) + (10 * $row['Semester'][8]) + 1;
  246. }
  247.  
  248. if(isDateInRange($adminAllStartingSeason, $adminAllStartingYear, $adminAllEndingSeason, $adminAllEndingYear, $semesterStringValue) == true)
  249. {
  250. ?>
  251. <li>
  252. <font size="3">
  253. Professor number&nbsp;
  254. <?=$row['ProfessorID']?>
  255. &nbsp;| Course number&nbsp;
  256. <?=$row['CourseID']?>
  257. &nbsp;| Transaction number&nbsp;
  258. <?=$row['TransactionID']?><br />
  259. <?=$row['AdditionOrSubtraction']?>
  260. ed&nbsp;
  261. <?=$row['LoadValue']?>
  262. &nbsp;on&nbsp;
  263. <?=$row['ProcessDate']?><br /><br />;
  264. </font>
  265. </li>
  266. <?php
  267. }
  268. }
  269. ?>
  270. </ul>
  271. <?php
  272. }
  273. else if(isset($_POST["administratorDepartment"]))
  274. {
  275. $adminDeptDeptAbbrev = $_POST["administratorSearchDepartmentDepartmentAbbreviation"];
  276.  
  277. $result = mysql_query("SELECT * FROM Professor INNER JOIN (Transaction INNER JOIN Course ON Transaction.CourseID = Course.CourseID) ON Transaction.ProfessorID = Professor.ProfessorID;") OR print(mysql_error());
  278. ?>
  279. <ul>
  280. <?php
  281. while($row = mysql_fetch_array($result))
  282. {
  283. if($row['Department'] == $adminDeptDeptAbbrev)
  284. {
  285. ?>
  286. <li>
  287. <font size="3">
  288. Professor number&nbsp;
  289. <?=$row['ProfessorID']?>
  290. &nbsp;| Course number&nbsp;
  291. <?=$row['CourseID']?>
  292. &nbsp;| Transaction number&nbsp;
  293. <?=$row['TransactionID']?><br />
  294. <?=$row['AdditionOrSubtraction']?>
  295. ed&nbsp;
  296. <?=$row['LoadValue']?>
  297. &nbsp;on&nbsp;
  298. <?=$row['ProcessDate']?><br /><br />;
  299. </font>
  300. </li>
  301. <?php
  302. }
  303. }
  304. ?>
  305. </ul>
  306. <?php
  307. }
  308. else if(isset($_POST["administratorDepartmentRange"]))
  309. {
  310. $adminDeptDeptAbbrevRange = $_POST["administratorSearchDepartmentDepartmentAbbreviationRange"];
  311. $adminDeptStartingSeason = $_POST["administratorSearchDepartmentSemesterSeasonStart"];
  312. $adminDeptStartingYear = $_POST["administratorSearchDepartmentSemesterYearStart"];
  313. $adminDeptEndingSeason = $_POST["administratorSearchDepartmentSemesterSeasonEnd"];
  314. $adminDeptEndingYear = $_POST["administratorSearchDepartmentSemesterYearEnd"];
  315.  
  316. $result = mysql_query("SELECT * FROM Professor INNER JOIN (Transaction INNER JOIN Course ON Transaction.CourseID = Course.CourseID) ON Transaction.ProfessorID = Professor.ProfessorID;") OR print(mysql_error());
  317. ?>
  318. <ul>
  319. <?php
  320. while($row = mysql_fetch_array($result))
  321. {
  322. if($row['Semester'][0] == 'S')
  323. {
  324. $semesterStringValue = (10000 * $row['Semester'][7]) + (1000 * $row['Semester'][8]) + (100 * $row['Semester'][9]) + (10 * $row['Semester'][10]);
  325. }
  326. else if($row['Semester'][0] == 'F')
  327. {
  328. $semesterStringValue = (10000 * $row['Semester'][5]) + (1000 * $row['Semester'][6]) + (100 * $row['Semester'][7]) + (10 * $row['Semester'][8]) + 1;
  329. }
  330.  
  331. if($row['Department'] == $adminDeptDeptAbbrevRange && isDateInRange($adminDeptStartingSeason, $adminDeptStartingYear, $adminDeptEndingSeason, $adminDeptEndingYear, $semesterStringValue) == true)
  332. {
  333. ?>
  334. <li>
  335. <font size="3">
  336. Professor number&nbsp;
  337. <?=$row['ProfessorID']?>
  338. &nbsp;| Course number&nbsp;
  339. <?=$row['CourseID']?>
  340. &nbsp;| Transaction number&nbsp;
  341. <?=$row['TransactionID']?><br />
  342. <?=$row['AdditionOrSubtraction']?>
  343. ed&nbsp;
  344. <?=$row['LoadValue']?>
  345. &nbsp;on&nbsp;
  346. <?=$row['ProcessDate']?><br /><br />;
  347. </font>
  348. </li>
  349. <?php
  350. }
  351. }
  352. ?>
  353. </ul>
  354. <?php
  355. }
  356. else if(isset($_POST["administratorProfessor"]))
  357. {
  358. $adminProfProfID = $_POST["administratorSearchProfessorProfessorID"];
  359.  
  360. $result = mysql_query("SELECT * FROM Professor INNER JOIN (Transaction INNER JOIN Course ON Transaction.CourseID = Course.CourseID) ON Transaction.ProfessorID = Professor.ProfessorID;") OR print(mysql_error());
  361. ?>
  362. <ul>
  363. <?php
  364. while($row = mysql_fetch_array($result))
  365. {
  366. if($row['ProfessorID'] == $adminProfProfID)
  367. {
  368. ?>
  369. <li>
  370. <font size="3">
  371. Professor number&nbsp;
  372. <?=$row['ProfessorID']?>
  373. &nbsp;| Course number&nbsp;
  374. <?=$row['CourseID']?>
  375. &nbsp;| Transaction number&nbsp;
  376. <?=$row['TransactionID']?><br />
  377. <?=$row['AdditionOrSubtraction']?>
  378. ed&nbsp;
  379. <?=$row['LoadValue']?>
  380. &nbsp;on&nbsp;
  381. <?=$row['ProcessDate']?><br /><br />;
  382. </font>
  383. </li>
  384. <?php
  385. }
  386. }
  387. ?>
  388. </ul>
  389. <?php
  390. }
  391. else if(isset($_POST["administratorProfessorRange"]))
  392. {
  393. $adminProfProfIDRange = $_POST["administratorSearchProfessorProfessorIDRange"];
  394. $adminProfStartingSeason = $_POST["administratorSearchProfessorSemesterSeasonStart"];
  395. $adminProfStartingYear = $_POST["administratorSearchProfessorSemesterYearStart"];
  396. $adminProfEndingSeason = $_POST["administratorSearchProfessorSemesterSeasonEnd"];
  397. $adminProfEndingYear = $_POST["administratorSearchProfessorSemesterYearEnd"];
  398.  
  399. $result = mysql_query("SELECT * FROM Professor INNER JOIN (Transaction INNER JOIN Course ON Transaction.CourseID = Course.CourseID) ON Transaction.ProfessorID = Professor.ProfessorID;") OR print(mysql_error());
  400. ?>
  401. <ul>
  402. <?php
  403. while($row = mysql_fetch_array($result))
  404. {
  405. if($row['Semester'][0] == 'S')
  406. {
  407. $semesterStringValue = (10000 * $row['Semester'][7]) + (1000 * $row['Semester'][8]) + (100 * $row['Semester'][9]) + (10 * $row['Semester'][10]);
  408. }
  409. else if($row['Semester'][0] == 'F')
  410. {
  411. $semesterStringValue = (10000 * $row['Semester'][5]) + (1000 * $row['Semester'][6]) + (100 * $row['Semester'][7]) + (10 * $row['Semester'][8]) + 1;
  412. }
  413.  
  414. if($row['ProfessorID'] == $adminProfProfIDRange && isDateInRange($adminProfStartingSeason, $adminProfStartingYear, $adminProfEndingSeason, $adminProfEndingYear, $semesterStringValue) == true)
  415. {
  416. ?>
  417. <li>
  418. <font size="3">
  419. Professor number&nbsp;
  420. <?=$row['ProfessorID']?>
  421. &nbsp;| Course number&nbsp;
  422. <?=$row['CourseID']?>
  423. &nbsp;| Transaction number&nbsp;
  424. <?=$row['TransactionID']?><br />
  425. <?=$row['AdditionOrSubtraction']?>
  426. ed&nbsp;
  427. <?=$row['LoadValue']?>
  428. &nbsp;on&nbsp;
  429. <?=$row['ProcessDate']?><br /><br />;
  430. </font>
  431. </li>
  432. <?php
  433. }
  434. }
  435. ?>
  436. </ul>
  437. <?php
  438. }
  439. else if(isset($_POST["headDepartment"]))
  440. {
  441. $result = mysql_query("SELECT * FROM Professor INNER JOIN (Transaction INNER JOIN Course ON Transaction.CourseID = Course.CourseID) ON Transaction.ProfessorID = Professor.ProfessorID;") OR print(mysql_error());
  442. ?>
  443. <ul>
  444. <?php
  445. while($row = mysql_fetch_array($result))
  446. {
  447. ?>
  448. <li>
  449. <font size="3">
  450. Professor number&nbsp;
  451. <?=$row['ProfessorID']?>
  452. &nbsp;| Course number&nbsp;
  453. <?=$row['CourseID']?>
  454. &nbsp;| Transaction number&nbsp;
  455. <?=$row['TransactionID']?><br />
  456. <?=$row['AdditionOrSubtraction']?>
  457. ed&nbsp;
  458. <?=$row['LoadValue']?>
  459. &nbsp;on&nbsp;
  460. <?=$row['ProcessDate']?><br /><br />;
  461. </font>
  462. </li>
  463. <?php
  464. }
  465. ?>
  466. </ul>
  467. <?php
  468. }
  469. else if(isset($_POST["headDepartmentRange"]))
  470. {
  471. $headDeptStartingSeason = $_POST["headSearchDepartmentSemesterSeasonStart"];
  472. $headDeptStartingYear = $_POST["headSearchDepartmentSemesterYearStart"];
  473. $headDeptEndingSeason = $_POST["headSearchDepartmentSemesterSeasonEnd"];
  474. $headDeptEndingYear = $_POST["headSearchDepartmentSemesterYearEnd"];
  475.  
  476. $result = mysql_query("SELECT * FROM Professor INNER JOIN (Transaction INNER JOIN Course ON Transaction.CourseID = Course.CourseID) ON Transaction.ProfessorID = Professor.ProfessorID;") OR print(mysql_error());
  477. ?>
  478. <ul>
  479. <?php
  480. while($row = mysql_fetch_array($result))
  481. {
  482. if($row['Semester'][0] == 'S')
  483. {
  484. $semesterStringValue = (10000 * $row['Semester'][7]) + (1000 * $row['Semester'][8]) + (100 * $row['Semester'][9]) + (10 * $row['Semester'][10]);
  485. }
  486. else if($row['Semester'][0] == 'F')
  487. {
  488. $semesterStringValue = (10000 * $row['Semester'][5]) + (1000 * $row['Semester'][6]) + (100 * $row['Semester'][7]) + (10 * $row['Semester'][8]) + 1;
  489. }
  490.  
  491. if(isDateInRange($headDeptStartingSeason, $headDeptStartingYear, $headDeptEndingSeason, $headDeptEndingYear, $semesterStringValue) == true)
  492. {
  493. ?>
  494. <li>
  495. <font size="3">
  496. Professor number&nbsp;
  497. <?=$row['ProfessorID']?>
  498. &nbsp;| Course number&nbsp;
  499. <?=$row['CourseID']?>
  500. &nbsp;| Transaction number&nbsp;
  501. <?=$row['TransactionID']?><br />
  502. <?=$row['AdditionOrSubtraction']?>
  503. ed&nbsp;
  504. <?=$row['LoadValue']?>
  505. &nbsp;on&nbsp;
  506. <?=$row['ProcessDate']?><br /><br />;
  507. </font>
  508. </li>
  509. <?php
  510. }
  511. }
  512. ?>
  513. </ul>
  514. <?php
  515. }
  516. else if(isset($_POST["headProfessor"]))
  517. {
  518. $headProfProfID = $_POST["headSearchProfessorProfessorID"];
  519.  
  520. $result = mysql_query("SELECT * FROM Professor INNER JOIN (Transaction INNER JOIN Course ON Transaction.CourseID = Course.CourseID) ON Transaction.ProfessorID = Professor.ProfessorID;") OR print(mysql_error());
  521. ?>
  522. <ul>
  523. <?php
  524. while($row = mysql_fetch_array($result))
  525. {
  526. if($row['ProfessorID'] == $headProfProfID)
  527. {
  528. ?>
  529. <li>
  530. <font size="3">
  531. Professor number&nbsp;
  532. <?=$row['ProfessorID']?>
  533. &nbsp;| Course number&nbsp;
  534. <?=$row['CourseID']?>
  535. &nbsp;| Transaction number&nbsp;
  536. <?=$row['TransactionID']?><br />
  537. <?=$row['AdditionOrSubtraction']?>
  538. ed&nbsp;
  539. <?=$row['LoadValue']?>
  540. &nbsp;on&nbsp;
  541. <?=$row['ProcessDate']?><br /><br />;
  542. </font>
  543. </li>
  544. <?php
  545. }
  546. }
  547. ?>
  548. </ul>
  549. <?php
  550. }
  551. else if(isset($_POST["headProfessorRange"]))
  552. {
  553. $headProfProfIDRange = $_POST["headSearchProfessorProfessorIDRange"];
  554. $headProfStartingSeason = $_POST["headSearchProfessorSemesterSeasonStart"];
  555. $headProfStartingYear = $_POST["headSearchProfessorSemesterYearStart"];
  556. $headProfEndingSeason = $_POST["headSearchProfessorSemesterSeasonEnd"];
  557. $headProfEndingYear = $_POST["headSearchProfessorSemesterYearEnd"];
  558.  
  559. $result = mysql_query("SELECT * FROM Professor INNER JOIN (Transaction INNER JOIN Course ON Transaction.CourseID = Course.CourseID) ON Transaction.ProfessorID = Professor.ProfessorID;") OR print(mysql_error());
  560. ?>
  561. <ul>
  562. <?php
  563. while($row = mysql_fetch_array($result))
  564. {
  565. if($row['Semester'][0] == 'S')
  566. {
  567. $semesterStringValue = (10000 * $row['Semester'][7]) + (1000 * $row['Semester'][8]) + (100 * $row['Semester'][9]) + (10 * $row['Semester'][10]);
  568. }
  569. else if($row['Semester'][0] == 'F')
  570. {
  571. $semesterStringValue = (10000 * $row['Semester'][5]) + (1000 * $row['Semester'][6]) + (100 * $row['Semester'][7]) + (10 * $row['Semester'][8]) + 1;
  572. }
  573.  
  574. if($row['ProfessorID'] == $headProfProfIDRange && isDateInRange($headProfStartingSeason, $headProfStartingYear, $headProfEndingSeason, $headProfEndingYear, $semesterStringValue) == true)
  575. {
  576. ?>
  577. <li>
  578. <font size="3">
  579. Professor number&nbsp;
  580. <?=$row['ProfessorID']?>
  581. &nbsp;| Course number&nbsp;
  582. <?=$row['CourseID']?>
  583. &nbsp;| Transaction number&nbsp;
  584. <?=$row['TransactionID']?><br />
  585. <?=$row['AdditionOrSubtraction']?>
  586. ed&nbsp;
  587. <?=$row['LoadValue']?>
  588. &nbsp;on&nbsp;
  589. <?=$row['ProcessDate']?><br /><br />;
  590. </font>
  591. </li>
  592. <?php
  593. }
  594. }
  595. ?>
  596. </ul>
  597. <?php
  598. }
  599. else if(isset($_POST["professorProfessor"]))
  600. {
  601. $result = mysql_query("SELECT * FROM Professor INNER JOIN (Transaction INNER JOIN Course ON Transaction.CourseID = Course.CourseID) ON Transaction.ProfessorID = Professor.ProfessorID;") OR print(mysql_error());
  602. ?>
  603. <ul>
  604. <?php
  605. while($row = mysql_fetch_array($result))
  606. {
  607. ?>
  608. <li>
  609. <font size="3">
  610. Professor number&nbsp;
  611. <?=$row['ProfessorID']?>
  612. &nbsp;| Course number&nbsp;
  613. <?=$row['CourseID']?>
  614. &nbsp;| Transaction number&nbsp;
  615. <?=$row['TransactionID']?><br />
  616. <?=$row['AdditionOrSubtraction']?>
  617. ed&nbsp;
  618. <?=$row['LoadValue']?>
  619. &nbsp;on&nbsp;
  620. <?=$row['ProcessDate']?><br /><br />;
  621. </font>
  622. </li>
  623. <?php
  624. }
  625. ?>
  626. </ul>
  627. <?php
  628. }
  629. else if(isset($_POST["professorProfessorRange"]))
  630. {
  631. $headProfStartingSeason = $_POST["headSearchProfessorSemesterSeasonStart"];
  632. $headProfStartingYear = $_POST["headSearchProfessorSemesterYearStart"];
  633. $headProfEndingSeason = $_POST["headSearchProfessorSemesterSeasonEnd"];
  634. $headProfEndingYear = $_POST["headSearchProfessorSemesterYearEnd"];
  635.  
  636. $result = mysql_query("SELECT * FROM Professor INNER JOIN (Transaction INNER JOIN Course ON Transaction.CourseID = Course.CourseID) ON Transaction.ProfessorID = Professor.ProfessorID;") OR print(mysql_error());
  637. ?>
  638. <ul>
  639. <?php
  640. while($row = mysql_fetch_array($result))
  641. {
  642. if($row['Semester'][0] == 'S')
  643. {
  644. $semesterStringValue = (10000 * $row['Semester'][7]) + (1000 * $row['Semester'][8]) + (100 * $row['Semester'][9]) + (10 * $row['Semester'][10]);
  645. }
  646. else if($row['Semester'][0] == 'F')
  647. {
  648. $semesterStringValue = (10000 * $row['Semester'][5]) + (1000 * $row['Semester'][6]) + (100 * $row['Semester'][7]) + (10 * $row['Semester'][8]) + 1;
  649. }
  650.  
  651. if(isDateInRange($headProfStartingSeason, $headProfStartingYear, $headProfEndingSeason, $headProfEndingYear, $semesterStringValue) == true)
  652. {
  653. ?>
  654. <li>
  655. <font size="3">
  656. Professor number&nbsp;
  657. <?=$row['ProfessorID']?>
  658. &nbsp;| Course number&nbsp;
  659. <?=$row['CourseID']?>
  660. &nbsp;| Transaction number&nbsp;
  661. <?=$row['TransactionID']?><br />
  662. <?=$row['AdditionOrSubtraction']?>
  663. ed&nbsp;
  664. <?=$row['LoadValue']?>
  665. &nbsp;on&nbsp;
  666. <?=$row['ProcessDate']?><br /><br />;
  667. </font>
  668. </li>
  669. <?php
  670. }
  671. }
  672. ?>
  673. </ul>
  674. <?php
  675. }
  676. ?>
  677. </body>
  678. </html>
  679. <?php
  680. mysql_close($database);
  681. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!