Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- if (empty($_SESSION["usuari"])) {
- session_unset();
- session_destroy();
- header("Location: index.php");
- }
- require('connexio.php');
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <link href="https://fonts.googleapis.com/css?family=ZCOOL+KuaiLe" rel="stylesheet">
- <link rel="stylesheet" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
- <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
- <script type="text/javascript" src="https://code.jquery.com/jquery-3.3.1.js"></script>
- <script type="text/javascript" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
- <style type="text/css">
- #main {
- font-family: Verdana, Geneva, sans-serif;
- font-size: 16px;
- border: solid;
- padding-left: 10px;
- position: absolute;
- width: 90%;
- height: 1019px;
- z-index: 1;
- top: 172px;
- left: 150px;
- }
- #header {
- position: absolute;
- width: 660px;
- height: 161px;
- z-index: 2;
- }
- #nav {
- position: absolute;
- width: 138px;
- height: 1014px;
- z-index: 3;
- top: 174px;
- font-family: Verdana, Geneva, sans-serif;
- text-decoration: none;
- background-color: #F63;
- list-style-type: none;
- text-align: center;
- }
- #logo {
- position: absolute;
- width: 198px;
- height: 161px;
- z-index: 1;
- }
- #textoHeader {
- position: absolute;
- width: 403px;
- height: 126px;
- z-index: 4;
- left: 215px;
- top: 16px;
- font-family: 'ZCOOL KuaiLe', cursive;
- font-size: 18px;
- background-color: #FFF;
- color: #999;
- }
- #nav {
- border-radius: 10px;
- }
- #nav ul {
- list-style-type: none;
- border: 0px solid #000;
- list-style-type: none;
- padding: 0px;
- margin-top: 0px;
- border-radius: 10px;
- }
- #nav ul li {
- text-decoration: none;
- position: relative;
- border: 2px solid #000;
- padding: 5px;
- margin-top: 2px;
- margin-right: 0px;
- margin-bottom: 2px;
- margin-left: 0px;
- border-radius: 10px;
- }
- #nav ul li a {
- text-decoration: none;
- }
- #nav ul li:hover {
- background-color: #666;
- }
- </style>
- <title>Resultats del teu camí</title>
- <!--<script type="text/javascript">
- function MM_showHideLayers() { //v9.0
- var i,p,v,obj,args=MM_showHideLayers.arguments;
- for (i=0; i<(args.length-2); i+=3)
- with (document) if (getElementById && ((obj=getElementById(args[i]))!=null)) { v=args[i+2];
- if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
- obj.visibility=v; }
- }
- </script>-->
- <script>
- $(document).ready(function() {
- $('#taula').DataTable( {
- "language": {
- "lengthMenu": "Mostra _MENU_ registres per plana",
- "zeroRecords": "No s'ha trobat - disculpa",
- "info": "Mostrant plana _PAGE_ de _PAGES_",
- "infoEmpty": "No hi ha registres.",
- "search": "Cerca:",
- "infoFiltered": "(filtrat de _MAX_ registres totals.)",
- "paginate": {
- "previous": "Anterior",
- "next": "Següent"
- }
- }
- } );
- } );
- </script>
- </head>
- <body>
- <div id="main">
- <h1>Resultats del teu camí</h1>
- <div id = "results">
- <?php
- // ENS ARRIBA
- /*
- e = Ensenyament
- t = Titularitat
- m = Matricula
- n = Naturalesa
- mn = Municipi
- */
- if (!empty($_GET)) {
- if (!empty($_GET["action"])) {
- if ($_GET["action"] == "add") {
- if (!empty($_POST)) {
- $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"]."')";
- if (mysqli_query($conn, $sql)) {
- echo "Universitat Afegida";
- }
- else {
- echo "Error: " . $sql . "" . mysqli_error($conn);
- }
- }
- else {
- ?>
- <form method="POST" action="?action=add">
- <br><br>Codi Centre:
- <input type="number" name="codi_centre"><br>
- Denominació:
- <input type="text" name="centre"><br>
- Public
- <input type="radio" name="naturalesa" value="Public"><br>
- Privat
- <input type="radio" name="naturalesa" value="Privat"><br>
- Titularitat<br>
- <select name="titularitat">
- <?php
- $sql = "SELECT DISTINCT nom_titularitat FROM universitats";
- $result = mysqli_query($conn, $sql);
- while ($row = mysqli_fetch_assoc($result)) {
- echo '<option value="'. $row["nom_titularitat"].'">'. $row["nom_titularitat"].'</option>';
- }
- ?>
- </select><br>
- Municipi<br>
- <select name="municipi">
- <?php
- $sql = "SELECT DISTINCT nom_municipi FROM universitats";
- $result = mysqli_query($conn, $sql);
- while ($row = mysqli_fetch_assoc($result)) {
- echo '<option value="'. $row["nom_municipi"].'">'. $row["nom_municipi"].'</option>';
- }
- ?>
- </select><br>
- Ensenyament<br>
- <select name="ensenyament">
- <?php
- $sql = "SELECT DISTINCT ensenyament_estudi FROM universitats";
- $result = mysqli_query($conn, $sql);
- while ($row = mysqli_fetch_assoc($result)) {
- echo '<option value="'. $row["ensenyament_estudi"].'">'. $row["ensenyament_estudi"].'</option>';
- }
- ?>
- </select><br><br>
- <input type="submit" name="enviar" value="Afegir">
- </form>
- <?php
- }
- }
- else if ($_GET["action"] == "edit") {
- if (!empty($_POST)) {
- $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"]."'";
- if (mysqli_query($conn, $sql)) {
- echo "Universitat Editada";
- }
- else {
- echo "Error: " . $sql . "" . mysqli_error($conn);
- }
- }
- else {
- $sql = "SELECT * FROM universitats WHERE centre_codi = " . $_GET["id"];
- $result = mysqli_query($conn, $sql);
- $row = mysqli_fetch_assoc($result);
- echo '<form method="POST" action="?action=edit">
- <br><br>Codi Centre:';
- echo '<input type="hidden" name="id" value="'. $_GET["id"].'">';
- echo '<input type="number" name="codi_centre" value="'. $row["centre_codi"].'"><br>';
- echo 'Denominació:';
- echo '<input type="text" name="centre" value="'. $row["denominacio_completa"].'"><br>';
- echo 'Public';
- if ($row["nom_naturalesa"] == "Public") {
- echo '<input type="radio" name="naturalesa" value="Public" checked><br>';
- echo 'Privat';
- echo '<input type="radio" name="naturalesa" value="Privat"><br>';
- }
- else {
- echo '<input type="radio" name="naturalesa" value="Public"><br>';
- echo 'Privat';
- echo '<input type="radio" name="naturalesa" value="Privat" checked><br>';
- }
- echo 'Titularitat<br>';
- echo '<select name="titularitat">';
- $sql = "SELECT DISTINCT nom_titularitat FROM universitats";
- $result = mysqli_query($conn, $sql);
- while ($row_T = mysqli_fetch_assoc($result)) {
- if ($row["nom_titularitat"] == $row_T["nom_titularitat"]) {
- echo '<option value="'. $row_T["nom_titularitat"].'" selected>'. $row_T["nom_titularitat"].'</option>';
- }
- else {
- echo '<option value="'. $row_T["nom_titularitat"].'">'. $row_T["nom_titularitat"].'</option>';
- }
- }
- echo '</select><br>';
- echo 'Municipi<br>';
- echo '<select name="municipi">';
- $sql = "SELECT DISTINCT nom_municipi FROM universitats";
- $result = mysqli_query($conn, $sql);
- while ($row_T = mysqli_fetch_assoc($result)) {
- if ($row["nom_municipi"] == $row_T["nom_municipi"]) {
- echo '<option value="'. $row_T["nom_municipi"].'" selected>'. $row_T["nom_municipi"].'</option>';
- }
- else {
- echo '<option value="'. $row_T["nom_municipi"].'">'. $row_T["nom_municipi"].'</option>';
- }
- }
- echo '</select><br>';
- echo 'Ensenyament<br>';
- $sql = "SELECT DISTINCT ensenyament_estudi FROM universitats";
- $result = mysqli_query($conn, $sql);
- while ($row_R = mysqli_fetch_assoc($result)) {
- if ($row["ensenyament_estudi"] == $row_R["ensenyament_estudi"]) {
- echo '<input type="hidden" name="ensenyament_anterior" value="'.$row_R["ensenyament_estudi"].'">';
- }
- }
- echo '<select name="ensenyament">';
- $sql = "SELECT DISTINCT ensenyament_estudi FROM universitats";
- $result = mysqli_query($conn, $sql);
- while ($row_T = mysqli_fetch_assoc($result)) {
- if ($row["ensenyament_estudi"] == $row_T["ensenyament_estudi"]) {
- echo '<option value="'. $row_T["ensenyament_estudi"].'" selected>'. $row_T["ensenyament_estudi"].'</option>';
- }
- else {
- echo '<option value="'. $row_T["ensenyament_estudi"].'">'. $row_T["ensenyament_estudi"].'</option>';
- }
- }
- echo '</select><br>';
- ?>
- <input type="submit" name="enviar" value="Editar">
- </form>
- <?php
- }
- }
- else if ($_GET["action"] == "delete") {
- $sql = "DELETE FROM universitats WHERE centre_codi = " . $_GET["id"]. " AND ensenyament_estudi LIKE '". $_GET["ensenyament"] . "'";
- if (mysqli_query($conn, $sql)) {
- echo "Universitat Eliminada";
- }
- else {
- echo "Error: " . $sql . "" . mysqli_error($conn);
- }
- }
- else {
- echo "ALGO FALLA";
- }
- }
- else {
- if ($_GET["q"] == "e") {
- $sql = "SELECT centre_codi, denominacio_completa , nom_naturalesa , nom_titularitat , nom_municipi , ensenyament_estudi FROM universitats WHERE ensenyament_estudi = '" . $_POST["ensenyament"] . "'";
- }
- else if ($_GET["q"] == "t") {
- $sql = "SELECT centre_codi, denominacio_completa , nom_naturalesa , nom_titularitat ,nom_municipi ,ensenyament_estudi FROM universitats WHERE nom_titularitat = '" . $_POST["preferencia_titol"] . "'";
- }
- else if ($_GET["q"] == "m") {
- $sql = "SELECT centre_codi, denominacio_completa , nom_naturalesa , nom_titularitat ,nom_municipi ,ensenyament_estudi FROM universitats WHERE matricules_total >= " . intval($_POST["matricules_total"]);
- }
- else if ($_GET["q"] == "n") {
- $sql = "SELECT centre_codi, denominacio_completa , nom_naturalesa , nom_titularitat ,nom_municipi ,ensenyament_estudi FROM universitats WHERE nom_naturalesa = '" . $_POST["naturalesa"] . "'";
- }
- else if ($_GET["q"] == "mn") {
- $sql = "SELECT centre_codi, denominacio_completa , nom_naturalesa , nom_titularitat ,nom_municipi ,ensenyament_estudi FROM universitats WHERE nom_municipi = '" . $_POST["municipiestudis"] . "'";
- }
- else {
- echo "NO TENS QUE VEURE AIXO";
- }
- $result = mysqli_query($conn, $sql);
- echo "<table id=\"taula\" class=\"table table-striped\">";
- 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>';
- echo '<tbody>';
- while ($row = mysqli_fetch_assoc($result)) {
- 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>';
- echo '<td class="align-middle">';
- echo "<a class='btn btn-warning' role='button' href=?action=edit&id=". $row["centre_codi"]."><i class=\"fas fa-edit\"></i> Editar</a> ";
- 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> ";
- echo '</td></tr>';
- }
- echo '</tbody>';
- echo "</table>";
- }
- }
- ?>
- <br />
- </div>
- </div>
- <div id="header">
- <div id="logo"></div>
- <img src="Logo.jpg" width="198" height="164" alt="eligetucamino" />
- <div id="textoHeader">
- <h1>El teu camí, al abast</h1>
- </div></div>
- <div id="nav">
- <ul>
- <li><a href="index.php">Inici</a></li>
- <li><a href="filtre.php?logged=true">Filtre</a></li>
- <li><a href="resultat.php?logged=true">Resultat</a></li>
- <li><a href="index.php?action=logout">Tancar sessió</a></li>
- </ul>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement