API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 15th, 2017
90
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.68 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. $sv_name = "";
  3. $username = "";
  4. $password = "";
  5. $db_name = "";
  6. ?>
  7.  
  8. <style type="text/css">
  9. table {
  10. border: none;
  11. }
  12.  
  13. table tr {
  14. border: none;
  15. }
  16.  
  17. table tr td {
  18. border: 1px solid black;
  19. }
  20. </style>
  21. <b><a href="index.php">Click to Refresh</a></b>
  22. <br/>
  23. <div style="float: left; width: 40%;">
  24. <script type="text/javascript">
  25. function deleteSubject(name)
  26. {
  27. answer = confirm("Are you sure you wish to delete \"" + name + "\"?");
  28. if(!answer) { return; }
  29. else { window.location = "./?deleteSubject=1&param1=" + name; }
  30. }
  31. </script>
  32.  
  33. <table>
  34. <h3>Add Subject:</h3>
  35. <form action="./" method="get">
  36. <input type="hidden" name="addSubject" value="1" />
  37. Name: <input type="text" name="param1" />
  38. <br /> <br/>
  39. Module IDs for each level (e.g. 2,4,5) <br/>
  40. Leave space empty if subject does not exist in the level. <br/>
  41. Master 1: <input type="text" name="param2" /><br/>
  42. Master 2: <input type="text" name="param3" /><br/>
  43. Bachelor 1: <input type="text" name="param4" /><br/>
  44. Bachelor 2: <input type="text" name="param5" /><br/>
  45. <br />
  46. <input type="submit" />
  47. </form>
  48.  
  49. <tr>
  50. <td>Delete</td>
  51. <td>Subject</td>
  52. <td>ID</td>
  53. <td>Modules (Master 1)</td>
  54. <td>Modules (Master 2)</td>
  55. <td>Modules (Bachelor 1)</td>
  56. <td>Modules (Bachelor 2)</td>
  57. </tr>
  58.  
  59. <?php
  60.  
  61. $pages_table_name = "uni_subjects";
  62.  
  63. $con = mysql_connect($sv_name, $username, $password) or die(mysql_error());
  64. mysql_select_db($db_name, $con) or die(mysql_error());
  65.  
  66. if($_GET['deleteSubject'] == 1)
  67. {
  68. if($_GET['param1'] != "")
  69. {
  70. //$query = "DELETE FROM " . $pages_table_name . " WHERE name='" . mysql_real_escape_string($_GET['param1']) . "'";
  71. $query = "UPDATE " . $pages_table_name . " SET name='DELETED' WHERE name='" . mysql_real_escape_string($_GET['param1']) . "'";
  72. mysql_query($query, $con) or die(mysql_error());
  73. }
  74. }
  75. else if($_GET['addSubject'] == 1)
  76. {
  77. if($_GET['param1'] != "" && $_GET['param2'] != "")
  78. {
  79. $query_fixid = "SELECT * FROM " . $pages_table_name;
  80. $result_fixid = mysql_query($query_fixid, $con) or die(mysql_error());
  81. while($row_fixid = mysql_fetch_array($result_fixid))
  82. {
  83. $lastid = $row_fixid['id'];
  84. }
  85. $newid = $lastid + 1;
  86. $query = "REPLACE INTO " . $pages_table_name . " (id, name, modules1, modules2, modules3, modules4) VALUES ('$newid', '" . mysql_real_escape_string($_GET['param1']) . "', '" . mysql_real_escape_string($_GET['param2']) . "', '" . mysql_real_escape_string($_GET['param3']) . "', '" . mysql_real_escape_string($_GET['param4']) . "', '" . mysql_real_escape_string($_GET['param5']) . "')";
  87. mysql_query($query, $con) or die(mysql_error());
  88. }
  89. }
  90.  
  91. $query = "SELECT * FROM " . $pages_table_name;
  92. $result = mysql_query($query, $con) or die(mysql_error());
  93.  
  94. while($row = mysql_fetch_array($result))
  95. {
  96. if ($row['name'] != "DELETED")
  97. {
  98. echo "<tr>";
  99. echo "<td><img src=\"x.png\" style=\"width:20px;\" onclick=\"deleteSubject('" . $row['name'] . "');\" /></td>";
  100. echo "<td>" . $row['id'] . "</td>";
  101. echo "<td>" . $row['name'] . "</td>";
  102. echo "<td>" . $row['modules1'] . "</td>";
  103. echo "<td>" . $row['modules2'] . "</td>";
  104. echo "<td>" . $row['modules3'] . "</td>";
  105. echo "<td>" . $row['modules4'] . "</td>";
  106. echo "</tr><br />";
  107. }
  108. }
  109. ?>
  110. </table>
  111.  
  112. <br/>
  113. </div>
  114.  
  115. <div style="float: right; width: 55%;">
  116. <script type="text/javascript">
  117. function deleteCombination(id)
  118. {
  119. answer = confirm("Are you sure you wish to delete this combination?");
  120. if(!answer) { return; }
  121. else { window.location = "./?deleteCombination=1&param1=" + id; }
  122. }
  123. </script>
  124.  
  125. <?php
  126. $pages_table_name = "uni_combinations";
  127.  
  128. if($_GET['deleteCombination'] == 1)
  129. {
  130. if($_GET['param1'] != "")
  131. {
  132. $query = "DELETE FROM " . $pages_table_name . " WHERE id='" . mysql_real_escape_string($_GET['param1']) . "'";
  133. mysql_query($query, $con) or die(mysql_error());
  134. }
  135. }
  136. else if($_GET['addCombination'] == 1)
  137. {
  138. if($_GET['param1'] != "" && $_GET['param2'] != "" && $_GET['param3'] != "")
  139. {
  140. if($_GET['param2'] != $_GET['param3'] && $_GET['param2'] != $_GET['param4'] && $_GET['param2'] != $_GET['param5'])
  141. {
  142. if($_GET['param3'] != $_GET['param4'] && $_GET['param3'] != $_GET['param5'])
  143. {
  144. $query = "INSERT INTO " . $pages_table_name . " (typeid,subid1,subid2,subid3,subid4) VALUES ('" . mysql_real_escape_string($_GET['param1']) . "','" . mysql_real_escape_string($_GET['param2']) . "','" . mysql_real_escape_string($_GET['param3']) . "','" . mysql_real_escape_string($_GET['param4']) . "','" . mysql_real_escape_string($_GET['param5']) . "')";
  145. mysql_query($query, $con) or die(mysql_error());
  146. }
  147. }
  148. }
  149. }
  150. ?>
  151.  
  152. <!--
  153. <table>
  154. <tr>
  155. <td>Delete</td>
  156. <td>Type</td>
  157. <td>Subject 1</td>
  158. <td>Subject 2</td>
  159. <td>Subject 3</td>
  160. <td>Subject 4</td>
  161. </tr>
  162.  
  163. <?php/*
  164. $pages_table_name = "uni_combinations";
  165.  
  166. $query = "SELECT * FROM " . $pages_table_name;
  167. $result_combinations = mysql_query($query, $con) or die(mysql_error());
  168.  
  169. while($row_combinations = mysql_fetch_array($result_combinations))
  170. {
  171. echo("<tr>");
  172.  
  173. echo("<td><img src=\"x.png\" style=\"width:20px;\" onclick=\"deleteCombination('" . $row_combinations['id'] . "');\" /></td>");
  174.  
  175. $pages_table_name = "uni_types";
  176. $query = "SELECT * FROM " . $pages_table_name . " WHERE id='" . $row_combinations['typeid'] . "'";
  177. $result_types = mysql_query($query, $con) or die(mysql_error());
  178. $row_types = mysql_fetch_array($result_types);
  179. echo("<td>" . $row_types['name'] . "</td>");
  180.  
  181. $pages_table_name = "uni_subjects";
  182.  
  183. $query = "SELECT * FROM " . $pages_table_name . " WHERE id='" . $row_combinations['subid1'] . "'";
  184. $result_sub1 = mysql_query($query, $con) or die(mysql_error());
  185. $row_sub1 = mysql_fetch_array($result_sub1);
  186. if ($row_sub1['name'] != "DELETED")
  187. {
  188. echo("<td>" . $row_sub1['name'] . "</td>");
  189. }
  190.  
  191. $query = "SELECT * FROM " . $pages_table_name . " WHERE id='" . $row_combinations['subid2'] . "'";
  192. $result_sub2 = mysql_query($query, $con) or die(mysql_error());
  193. $row_sub2 = mysql_fetch_array($result_sub2);
  194. if ($row_sub2['name'] != "DELETED")
  195. {
  196. echo("<td>" . $row_sub2['name'] . "</td>");
  197. }
  198.  
  199. $query = "SELECT * FROM " . $pages_table_name . " WHERE id='" . $row_combinations['subid3'] . "'";
  200. $result_sub3 = mysql_query($query, $con) or die(mysql_error());
  201. if($row_sub3 = mysql_fetch_array($result_sub3))
  202. {
  203. echo("<td>" . $row_sub3['name'] . "</td>");
  204. }
  205. else
  206. {
  207. echo("<td>N/A</td>");
  208. }
  209.  
  210. $query = "SELECT * FROM " . $pages_table_name . " WHERE id='" . $row_combinations['subid4'] . "'";
  211. $result_sub4 = mysql_query($query, $con) or die(mysql_error());
  212. if($row_sub4 = mysql_fetch_array($result_sub4))
  213. {
  214. echo("<td>" . $row_sub4['name'] . "</td>");
  215. }
  216. else
  217. {
  218. echo("<td>N/A</td>");
  219. }
  220.  
  221.  
  222. echo("</tr>");
  223. }
  224. */?>
  225. </table>
  226. -->
  227.  
  228. <script type="text/javascript">
  229. function typeChanged()
  230. {
  231. if(document.formCombinations.param1.value == "1")
  232. {
  233. document.formCombinations.param4.disabled = false;
  234. document.formCombinations.param5.disabled = true;
  235. }
  236. else if(document.formCombinations.param1.value == "2")
  237. {
  238. document.formCombinations.param4.disabled = true;
  239. document.formCombinations.param5.disabled = true;
  240. }
  241. else if(document.formCombinations.param1.value == "3")
  242. {
  243. document.formCombinations.param4.disabled = false;
  244. document.formCombinations.param5.disabled = true;
  245. }
  246. else if(document.formCombinations.param1.value == "4")
  247. {
  248. document.formCombinations.param4.disabled = false;
  249. document.formCombinations.param5.disabled = false;
  250. }
  251. }
  252. </script>
  253. <br/>
  254. <h3>Add Combination:</h3>
  255. <form name="formCombinations" action="./" method="get">
  256. <input type="hidden" name="addCombination" value="1" />
  257. Type:
  258. <select name="param1" value="1" onchange="typeChanged();">
  259. <?php
  260. $pages_table_name = "uni_types";
  261.  
  262. $query = "SELECT * FROM " . $pages_table_name;
  263. $result_types = mysql_query($query, $con) or die(mysql_error());
  264. while($row_types = mysql_fetch_array($result_types))
  265. {
  266. echo("<option value=\"" . $row_types['id'] . "\">" . $row_types['name'] . " (" . $row_types['id'] . ")</option>");
  267. }
  268. ?>
  269. </select>
  270. <br />
  271. Subject 1:
  272. <select name="param2">
  273. <?php
  274. $pages_table_name = "uni_subjects";
  275.  
  276. $query = "SELECT * FROM " . $pages_table_name;
  277. $result_types = mysql_query($query, $con) or die(mysql_error());
  278. while($row_types = mysql_fetch_array($result_types))
  279. {
  280. echo("<option value=\"" . $row_types['id'] . "\">" . $row_types['name'] . " (" . $row_types['id'] . ")</option>");
  281. }
  282. ?>
  283. </select>
  284. <br />
  285. Subject 2:
  286. <select name="param3">
  287. <?php
  288. $pages_table_name = "uni_subjects";
  289.  
  290. $query = "SELECT * FROM " . $pages_table_name;
  291. $result_types = mysql_query($query, $con) or die(mysql_error());
  292. while($row_types = mysql_fetch_array($result_types))
  293. {
  294. echo("<option value=\"" . $row_types['id'] . "\">" . $row_types['name'] . " (" . $row_types['id'] . ")</option>");
  295. }
  296. ?>
  297. </select>
  298. <br />
  299. Subject 3:
  300. <select name="param4">
  301. <?php
  302. $pages_table_name = "uni_subjects";
  303.  
  304. $query = "SELECT * FROM " . $pages_table_name;
  305. $result_types = mysql_query($query, $con) or die(mysql_error());
  306. while($row_types = mysql_fetch_array($result_types))
  307. {
  308. echo("<option value=\"" . $row_types['id'] . "\">" . $row_types['name'] . " (" . $row_types['id'] . ")</option>");
  309. }
  310. ?>
  311. </select>
  312. <br />
  313. Subject 4:
  314. <select name="param5">
  315. <?php
  316. $pages_table_name = "uni_subjects";
  317.  
  318. $query = "SELECT * FROM " . $pages_table_name;
  319. $result_types = mysql_query($query, $con) or die(mysql_error());
  320. while($row_types = mysql_fetch_array($result_types))
  321. {
  322. echo("<option value=\"" . $row_types['id'] . "\">" . $row_types['name'] . " (" . $row_types['id'] . ")</option>");
  323. }
  324. ?>
  325. </select>
  326. <br />
  327. <input type="submit" />
  328. </form>
  329.  
  330. -----------------------------------------------------------------------------
  331. <br/>
  332. <br/>
  333. <br/>
  334. <br/>
  335. <br/>
  336. <br/>
  337. <br/>
  338. <br/>
  339.  
  340. <script type="text/javascript">
  341. typeChanged();
  342. </script>
  343. </div>
  344.  
  345. <div style="float: right; width: 55%;">
  346. <script type="text/javascript">
  347. function deleteModule(name)
  348. {
  349. answer = confirm("Are you sure you wish to delete \"" + name + "\"?");
  350. if(!answer) { return; }
  351. else { window.location = "./?deleteModule=1&param1=" + name; }
  352. }
  353. </script>
  354. <br/>
  355. <br/>
  356. <br/>
  357. <h3>Add Module:</h3>
  358. <form action="./" method="get">
  359. <input type="hidden" name="addModule" value="1" />
  360. Name: <input type="text" name="param2" />
  361. <br />
  362. Summary Idanlass: <input type="text" name="param1" />
  363. <br />
  364. <input type="submit" />
  365. </form>
  366. <br/>
  367. <table>
  368. <tr>
  369. <td>Delete</td>
  370. <td>Module ID</td>
  371. <td>Name</td>
  372. <td>Summary ID</td>
  373. </tr>
  374.  
  375. <?php
  376. $pages_table_name = "uni_modules";
  377.  
  378. if($_GET['deleteModule'] == 1)
  379. {
  380. if($_GET['param1'] != "")
  381. {
  382. $query = "DELETE FROM " . $pages_table_name . " WHERE name='" . mysql_real_escape_string($_GET['param1']) . "'";
  383. mysql_query($query, $con) or die(mysql_error());
  384. }
  385. }
  386. else if($_GET['addModule'] == 1)
  387. {
  388. if($_GET['param1'] != "" && $_GET['param2'] != "")
  389. {
  390. $query = "REPLACE INTO " . $pages_table_name . " (summaryid,name) VALUES ('" . mysql_real_escape_string($_GET['param1']) . "','" . mysql_real_escape_string($_GET['param2']) . "')";
  391. mysql_query($query, $con) or die(mysql_error());
  392. }
  393. }
  394.  
  395. $query = "SELECT * FROM " . $pages_table_name;
  396. $result = mysql_query($query, $con) or die(mysql_error());
  397.  
  398. while($row = mysql_fetch_array($result))
  399. {
  400. echo("<tr>");
  401.  
  402. echo("<td><img src=\"x.png\" style=\"width:20px;\" onclick=\"deleteModule('" . $row['name'] . "');\" /></td>");
  403. echo("<td>" . $row['id'] . "</td>");
  404. echo("<td>" . $row['name'] . "</td>");
  405. echo("<td>" . $row['summaryid'] . "</td>");
  406.  
  407. /*echo("<img src=\"x.png\" style=\"width:20px;\" onclick=\"deleteModule('" . $row['name'] . "');\" />");
  408. echo($row['name'] . ": blabla.aspx?idanlass=" . $row['summaryid']);
  409. echo("<br />");*/
  410.  
  411. echo("</tr>");
  412. }
  413.  
  414. include "cleandb.php";
  415. ?>
  416. </table>
  417. <br/>
  418.  
  419. </div>
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!