API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 25th, 2019
151
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.34 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. if (empty($_SESSION["usuari"])) {
  4. session_unset();
  5. session_destroy();
  6. header("Location: index.php");
  7. }
  8. require('connexio.php');
  9. ?>
  10.  
  11.  
  12. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  13. <html xmlns="http://www.w3.org/1999/xhtml">
  14. <head>
  15. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  16. <link href="https://fonts.googleapis.com/css?family=ZCOOL+KuaiLe" rel="stylesheet">
  17. <link rel="stylesheet" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
  18. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
  19. <script type="text/javascript" src="https://code.jquery.com/jquery-3.3.1.js"></script>
  20. <script type="text/javascript" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
  21. <style type="text/css">
  22. #main {
  23. font-family: Verdana, Geneva, sans-serif;
  24. font-size: 16px;
  25. border: solid;
  26. padding-left: 10px;
  27. position: absolute;
  28. width: 90%;
  29. height: 1019px;
  30. z-index: 1;
  31. top: 172px;
  32. left: 150px;
  33. }
  34. #header {
  35. position: absolute;
  36. width: 660px;
  37. height: 161px;
  38. z-index: 2;
  39. }
  40. #nav {
  41. position: absolute;
  42. width: 138px;
  43. height: 1014px;
  44. z-index: 3;
  45. top: 174px;
  46. font-family: Verdana, Geneva, sans-serif;
  47. text-decoration: none;
  48. background-color: #F63;
  49. list-style-type: none;
  50. text-align: center;
  51. }
  52. #logo {
  53. position: absolute;
  54. width: 198px;
  55. height: 161px;
  56. z-index: 1;
  57. }
  58. #textoHeader {
  59. position: absolute;
  60. width: 403px;
  61. height: 126px;
  62. z-index: 4;
  63. left: 215px;
  64. top: 16px;
  65. font-family: 'ZCOOL KuaiLe', cursive;
  66. font-size: 18px;
  67. background-color: #FFF;
  68. color: #999;
  69. }
  70. #nav {
  71. border-radius: 10px;
  72. }
  73. #nav ul {
  74. list-style-type: none;
  75. border: 0px solid #000;
  76. list-style-type: none;
  77. padding: 0px;
  78. margin-top: 0px;
  79. border-radius: 10px;
  80. }
  81. #nav ul li {
  82. text-decoration: none;
  83. position: relative;
  84. border: 2px solid #000;
  85. padding: 5px;
  86. margin-top: 2px;
  87. margin-right: 0px;
  88. margin-bottom: 2px;
  89. margin-left: 0px;
  90. border-radius: 10px;
  91. }
  92. #nav ul li a {
  93. text-decoration: none;
  94. }
  95. #nav ul li:hover {
  96. background-color: #666;
  97. }
  98. </style>
  99. <title>Resultats del teu camí</title>
  100. <!--<script type="text/javascript">
  101. function MM_showHideLayers() { //v9.0
  102. var i,p,v,obj,args=MM_showHideLayers.arguments;
  103. for (i=0; i<(args.length-2); i+=3)
  104. with (document) if (getElementById && ((obj=getElementById(args[i]))!=null)) { v=args[i+2];
  105. if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
  106. obj.visibility=v; }
  107. }
  108. </script>-->
  109. <script>
  110. $(document).ready(function() {
  111. $('#taula').DataTable( {
  112. "language": {
  113. "lengthMenu": "Mostra _MENU_ registres per plana",
  114. "zeroRecords": "No s'ha trobat - disculpa",
  115. "info": "Mostrant plana _PAGE_ de _PAGES_",
  116. "infoEmpty": "No hi ha registres.",
  117. "search": "Cerca:",
  118. "infoFiltered": "(filtrat de _MAX_ registres totals.)",
  119. "paginate": {
  120. "previous": "Anterior",
  121. "next": "Següent"
  122. }
  123.  
  124. }
  125. } );
  126. } );
  127. </script>
  128. </head>
  129.  
  130. <body>
  131. <div id="main">
  132. <h1>Resultats del teu camí</h1>
  133.  
  134. <div id = "results">
  135. <?php
  136.  
  137. // ENS ARRIBA
  138.  
  139. /*
  140. e = Ensenyament
  141. t = Titularitat
  142. m = Matricula
  143. n = Naturalesa
  144. mn = Municipi
  145. */
  146.  
  147. if (!empty($_GET)) {
  148. if (!empty($_GET["action"])) {
  149. if ($_GET["action"] == "add") {
  150. if (!empty($_POST)) {
  151. $sql = "INSERT INTO universitats (centre_codi, denominacio_completa , nom_naturalesa , nom_titularitat ,nom_municipi ,ensenyament_estudi) VALUES (". $_POST["codi_centre"].",'". $_POST["centre"]."','". $_POST["naturalesa"]."','". $_POST["titularitat"]."','". $_POST["municipi"]."','". $_POST["ensenyament"]."')";
  152.  
  153. if (mysqli_query($conn, $sql)) {
  154. echo "Universitat Afegida";
  155.  
  156. }
  157. else {
  158. echo "Error: " . $sql . "" . mysqli_error($conn);
  159. }
  160. }
  161. else {
  162.  
  163. ?>
  164. <form method="POST" action="?action=add">
  165. <br><br>Codi Centre:
  166. <input type="number" name="codi_centre"><br>
  167. Denominació:
  168. <input type="text" name="centre"><br>
  169. Public
  170. <input type="radio" name="naturalesa" value="Public"><br>
  171. Privat
  172. <input type="radio" name="naturalesa" value="Privat"><br>
  173. Titularitat<br>
  174. <select name="titularitat">
  175. <?php
  176. $sql = "SELECT DISTINCT nom_titularitat FROM universitats";
  177. $result = mysqli_query($conn, $sql);
  178.  
  179. while ($row = mysqli_fetch_assoc($result)) {
  180. echo '<option value="'. $row["nom_titularitat"].'">'. $row["nom_titularitat"].'</option>';
  181. }
  182. ?>
  183. </select><br>
  184. Municipi<br>
  185. <select name="municipi">
  186. <?php
  187. $sql = "SELECT DISTINCT nom_municipi FROM universitats";
  188. $result = mysqli_query($conn, $sql);
  189.  
  190. while ($row = mysqli_fetch_assoc($result)) {
  191. echo '<option value="'. $row["nom_municipi"].'">'. $row["nom_municipi"].'</option>';
  192. }
  193. ?>
  194. </select><br>
  195. Ensenyament<br>
  196. <select name="ensenyament">
  197. <?php
  198. $sql = "SELECT DISTINCT ensenyament_estudi FROM universitats";
  199. $result = mysqli_query($conn, $sql);
  200.  
  201. while ($row = mysqli_fetch_assoc($result)) {
  202. echo '<option value="'. $row["ensenyament_estudi"].'">'. $row["ensenyament_estudi"].'</option>';
  203. }
  204. ?>
  205. </select><br><br>
  206.  
  207. <input type="submit" name="enviar" value="Afegir">
  208.  
  209.  
  210. </form>
  211.  
  212. <?php
  213. }
  214.  
  215. }
  216. else if ($_GET["action"] == "edit") {
  217. if (!empty($_POST)) {
  218.  
  219. $sql = "UPDATE universitats SET centre_codi = ". $_POST["codi_centre"]." , denominacio_completa = '". $_POST["centre"]."' , nom_naturalesa = '". $_POST["naturalesa"]."' , nom_titularitat = '". $_POST["titularitat"]."' ,nom_municipi = '". $_POST["municipi"]."' ,ensenyament_estudi = '". $_POST["ensenyament"]."' WHERE centre_codi = ". $_POST["id"] . " AND ensenyament_estudi = '".$_POST["ensenyament_anterior"]."'";
  220.  
  221. if (mysqli_query($conn, $sql)) {
  222. echo "Universitat Editada";
  223.  
  224. }
  225. else {
  226. echo "Error: " . $sql . "" . mysqli_error($conn);
  227. }
  228. }
  229. else {
  230. $sql = "SELECT * FROM universitats WHERE centre_codi = " . $_GET["id"];
  231.  
  232. $result = mysqli_query($conn, $sql);
  233. $row = mysqli_fetch_assoc($result);
  234.  
  235. echo '<form method="POST" action="?action=edit">
  236. <br><br>Codi Centre:';
  237. echo '<input type="hidden" name="id" value="'. $_GET["id"].'">';
  238. echo '<input type="number" name="codi_centre" value="'. $row["centre_codi"].'"><br>';
  239. echo 'Denominació:';
  240. echo '<input type="text" name="centre" value="'. $row["denominacio_completa"].'"><br>';
  241. echo 'Public';
  242. if ($row["nom_naturalesa"] == "Public") {
  243. echo '<input type="radio" name="naturalesa" value="Public" checked><br>';
  244. echo 'Privat';
  245. echo '<input type="radio" name="naturalesa" value="Privat"><br>';
  246. }
  247. else {
  248. echo '<input type="radio" name="naturalesa" value="Public"><br>';
  249. echo 'Privat';
  250. echo '<input type="radio" name="naturalesa" value="Privat" checked><br>';
  251. }
  252. echo 'Titularitat<br>';
  253.  
  254. echo '<select name="titularitat">';
  255. $sql = "SELECT DISTINCT nom_titularitat FROM universitats";
  256.  
  257. $result = mysqli_query($conn, $sql);
  258.  
  259. while ($row_T = mysqli_fetch_assoc($result)) {
  260. if ($row["nom_titularitat"] == $row_T["nom_titularitat"]) {
  261. echo '<option value="'. $row_T["nom_titularitat"].'" selected>'. $row_T["nom_titularitat"].'</option>';
  262. }
  263. else {
  264. echo '<option value="'. $row_T["nom_titularitat"].'">'. $row_T["nom_titularitat"].'</option>';
  265. }
  266. }
  267. echo '</select><br>';
  268.  
  269. echo 'Municipi<br>';
  270. echo '<select name="municipi">';
  271.  
  272. $sql = "SELECT DISTINCT nom_municipi FROM universitats";
  273.  
  274. $result = mysqli_query($conn, $sql);
  275.  
  276. while ($row_T = mysqli_fetch_assoc($result)) {
  277. if ($row["nom_municipi"] == $row_T["nom_municipi"]) {
  278. echo '<option value="'. $row_T["nom_municipi"].'" selected>'. $row_T["nom_municipi"].'</option>';
  279. }
  280. else {
  281. echo '<option value="'. $row_T["nom_municipi"].'">'. $row_T["nom_municipi"].'</option>';
  282. }
  283. }
  284. echo '</select><br>';
  285.  
  286. echo 'Ensenyament<br>';
  287.  
  288. $sql = "SELECT DISTINCT ensenyament_estudi FROM universitats";
  289.  
  290. $result = mysqli_query($conn, $sql);
  291.  
  292. while ($row_R = mysqli_fetch_assoc($result)) {
  293. if ($row["ensenyament_estudi"] == $row_R["ensenyament_estudi"]) {
  294. echo '<input type="hidden" name="ensenyament_anterior" value="'.$row_R["ensenyament_estudi"].'">';
  295. }
  296. }
  297.  
  298. echo '<select name="ensenyament">';
  299.  
  300. $sql = "SELECT DISTINCT ensenyament_estudi FROM universitats";
  301.  
  302. $result = mysqli_query($conn, $sql);
  303.  
  304. while ($row_T = mysqli_fetch_assoc($result)) {
  305. if ($row["ensenyament_estudi"] == $row_T["ensenyament_estudi"]) {
  306. echo '<option value="'. $row_T["ensenyament_estudi"].'" selected>'. $row_T["ensenyament_estudi"].'</option>';
  307. }
  308. else {
  309. echo '<option value="'. $row_T["ensenyament_estudi"].'">'. $row_T["ensenyament_estudi"].'</option>';
  310. }
  311. }
  312. echo '</select><br>';
  313.  
  314. ?>
  315. <input type="submit" name="enviar" value="Editar">
  316. </form>
  317.  
  318. <?php
  319. }
  320.  
  321. }
  322. else if ($_GET["action"] == "delete") {
  323. $sql = "DELETE FROM universitats WHERE centre_codi = " . $_GET["id"]. " AND ensenyament_estudi LIKE '". $_GET["ensenyament"] . "'";
  324.  
  325. if (mysqli_query($conn, $sql)) {
  326. echo "Universitat Eliminada";
  327.  
  328. }
  329. else {
  330. echo "Error: " . $sql . "" . mysqli_error($conn);
  331. }
  332. }
  333. else {
  334. echo "ALGO FALLA";
  335. }
  336. }
  337. else {
  338.  
  339. if ($_GET["q"] == "e") {
  340. $sql = "SELECT centre_codi, denominacio_completa , nom_naturalesa , nom_titularitat , nom_municipi , ensenyament_estudi FROM universitats WHERE ensenyament_estudi = '" . $_POST["ensenyament"] . "'";
  341. }
  342. else if ($_GET["q"] == "t") {
  343. $sql = "SELECT centre_codi, denominacio_completa , nom_naturalesa , nom_titularitat ,nom_municipi ,ensenyament_estudi FROM universitats WHERE nom_titularitat = '" . $_POST["preferencia_titol"] . "'";
  344. }
  345. else if ($_GET["q"] == "m") {
  346. $sql = "SELECT centre_codi, denominacio_completa , nom_naturalesa , nom_titularitat ,nom_municipi ,ensenyament_estudi FROM universitats WHERE matricules_total >= " . intval($_POST["matricules_total"]);
  347. }
  348. else if ($_GET["q"] == "n") {
  349. $sql = "SELECT centre_codi, denominacio_completa , nom_naturalesa , nom_titularitat ,nom_municipi ,ensenyament_estudi FROM universitats WHERE nom_naturalesa = '" . $_POST["naturalesa"] . "'";
  350. }
  351. else if ($_GET["q"] == "mn") {
  352. $sql = "SELECT centre_codi, denominacio_completa , nom_naturalesa , nom_titularitat ,nom_municipi ,ensenyament_estudi FROM universitats WHERE nom_municipi = '" . $_POST["municipiestudis"] . "'";
  353. }
  354. else {
  355. echo "NO TENS QUE VEURE AIXO";
  356. }
  357. $result = mysqli_query($conn, $sql);
  358. echo "<table id=\"taula\" class=\"table table-striped\">";
  359. echo '<thead class="thead-dark"><tr><th class="align-middle">Nom Institut</th><th class="align-middle">Naturalesa</th><th>Titularitat</th><th>Municipi</th><th>Ensenyament</th><th><a class="btn btn-success" role="button" href="?action=add"><i class="fas fa-edit"></i> Afegir</a> </th></tr></thead>';
  360. echo '<tbody>';
  361. while ($row = mysqli_fetch_assoc($result)) {
  362. echo '<tr><td class="align-middle">'. $row["denominacio_completa"] .'</td><td class="align-middle">'. $row["nom_naturalesa"] .'</td><td class="align-middle">'. $row["nom_titularitat"] .'</td><td class="align-middle">'. $row["nom_municipi"] .'</td><td class="align-middle">'. $row["ensenyament_estudi"] .'</td>';
  363. echo '<td class="align-middle">';
  364. echo "<a class='btn btn-warning' role='button' href=?action=edit&id=". $row["centre_codi"]."><i class=\"fas fa-edit\"></i> Editar</a> ";
  365. echo "<a class='btn btn-danger' role='button' href=?action=delete&id=". $row["centre_codi"]."&ensenyament=". $row["ensenyament_estudi"]."><i class=\"fas fa-user-minus\"></i> Eliminar</a> ";
  366. echo '</td></tr>';
  367. }
  368. echo '</tbody>';
  369. echo "</table>";
  370. }
  371.  
  372. }
  373.  
  374. ?>
  375. <br />
  376. </div>
  377. </div>
  378.  
  379. <div id="header">
  380. <div id="logo"></div>
  381. <img src="Logo.jpg" width="198" height="164" alt="eligetucamino" />
  382. <div id="textoHeader">
  383. <h1>El teu camí, al abast</h1>
  384. </div></div>
  385. <div id="nav">
  386. <ul>
  387. <li><a href="index.php">Inici</a></li>
  388. <li><a href="filtre.php?logged=true">Filtre</a></li>
  389. <li><a href="resultat.php?logged=true">Resultat</a></li>
  390. <li><a href="index.php?action=logout">Tancar sessió</a></li>
  391. </ul>
  392. </div>
  393. </body>
  394. </html>
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!