Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- require('connexio.php');
- $logged = false;
- if (empty($_POST) && empty($_SESSION["usuari"])) {
- session_unset();
- session_destroy();
- header("Location: index.php");
- }
- if (!empty($_POST)) {
- if ($_GET["action"] == "register") {
- if (!ctype_alpha($_POST["nom"])){
- header("Location: index.php?error=nom");
- }
- else if (!ctype_alpha($_POST["cognom"])){
- header("Location: index.php?error=cognom");
- }
- $password = hash('sha512', $_POST["passwordRegistre"]);
- $sql = "INSERT INTO usuaris (nom,cognom,usuari,contrasenya) VALUES ('".$_POST["nom"]."','".$_POST["cognom"]."','".$_POST["usuariRegistre"]."','".$password."')";
- if (mysqli_query($conn, $sql)) {
- $_SESSION["usuari"] = $_POST["usuariRegistre"];
- $_SESSION["password"] = $password;
- }
- else {
- echo "Error: " . $sql . "" . mysqli_error($conn);
- }
- }
- else if ($_GET["action"] == "login") {
- $sql = "SELECT usuari,contrasenya FROM usuaris";
- $result = mysqli_query($conn, $sql);
- while ($row = mysqli_fetch_assoc($result)) {
- $usuari = $row["usuari"];
- $passwordLogin = hash('sha512', $_POST["passwordLogin"]);
- if ($_POST["usuariLogin"] == $usuari) {
- echo "USUARI CORRECTE";
- if ($row["contrasenya"] == $passwordLogin) {
- echo "PASSWORD CORRECTE";
- $logged = true;
- $_SESSION["usuari"] = $_POST["usuariLogin"];
- $_SESSION["password"] = $password;
- }
- else {
- echo "<br>". $row["contrasenya"] . "<br>" . $passwordLogin;
- }
- }
- }
- }
- }
- if (!$logged && empty($_SESSION["usuari"])) {
- header("Location: index.php?error=login");
- }
- else {
- ?>
- <!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">
- <style type="text/css">
- #main #formFiltre {
- font-family: Verdana, Geneva, sans-serif;
- font-size: 16px;
- border-top-width: thin;
- border-right-width: thin;
- border-bottom-width: thin;
- border-left-width: thin;
- border-top-style: solid;
- border-right-style: solid;
- border-bottom-style: solid;
- border-left-style: solid;
- padding-top: 0px;
- padding-right: 5px;
- padding-bottom: 5px;
- padding-left: 10px;
- font-style: oblique;
- }
- #main #formFiltre #Enviar {
- background-color: #060;
- color: #000;
- font-family: Verdana, Geneva, sans-serif;
- border-top-style: solid;
- border-right-style: solid;
- border-bottom-style: solid;
- border-left-style: solid;
- border-top-color: #000;
- border-right-color: #000;
- border-bottom-color: #000;
- border-left-color: #000;
- width: 500px;
- height: 30px;
- }
- #main #formFiltre #Enviar:hover {
- color: #FFF;
- background-color: #0F0;
- }
- #main #formFiltre .inputText {
- width: 475px;
- height: 30px;
- display: block;
- text-align: center;
- }
- #main #formFiltre .inputSelect {
- width: 300px;
- height: 30px;
- }
- #main #formFiltre p #imgEnviar {
- height: 110px;
- width: 200px;
- margin-left: 150px;
- }
- #main {
- position: absolute;
- width: 517px;
- 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>Busca el teu camí</title>
- </head>
- <body>
- <div id="main">
- <form id="formFiltre" name="formFiltre" method="post" action="filtre.php">
- <h1>Filtrat de Estudis</h1>
- <p>
- <b>Ensenyament</b><br />
- <?php
- echo '<select name="ensenyament">';
- $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>';
- }
- echo '</select>';
- ?>
- <!--<label>
- <input type="radio" name="Nivell d'Anglès" value="cap" id="NivelldAnglegraves_0" />
- Cap</label>
- <br />
- <label>
- <input type="radio" name="Nivell d'Anglès" value="baix" id="NivelldAnglegraves_1" />
- Baix</label>
- <br />
- <label>
- <input type="radio" name="Nivell d'Anglès" value="mitja" id="NivelldAnglegraves_2" />
- Mitjà</label>
- <br />
- <label>
- <input type="radio" name="Nivell d'Anglès" value="alt" id="NivelldAnglegraves_3" />
- Alt</label>
- <br />
- <label>
- <input type="radio" name="Nivell d'Anglès" value="moltAlt" id="NivelldAnglegraves_4" />
- Molt Alt</label>-->
- <br />
- </p>
- <p>
- <label for="preferencia"><b>Preferencia de titularitat</b></label>
- <?php
- echo '<select name="preferencia-titol" class="inputSelect">';
- $sql = "SELECT DISTINCT codi_titularitat, nom_titularitat FROM universitats WHERE nom_titularitat != 'No informat'";
- $result = mysqli_query($conn, $sql);
- while ($row = mysqli_fetch_assoc($result)) {
- echo '<option value="'. $row["codi_titularitat"]. '"> '. $row["nom_titularitat"]. '</option>';
- }
- echo '</select>';
- ?>
- <!-- <input name="preferencia" class="inputText" type="text" required /> -->
- </p>
- <p>
- <!--<label for="presupost"><b>Minim de diners de presupost</b></label>
- <input name="presupost" class="inputText" type="number" required />
- </p>
- <p>
- <label for="maxPresupost"><b>Maxim de diners de presupost</b></label>
- <input name="maxPresupost" class="inputText" type="number" required />-->
- </p>
- <p>
- <label for="matricules"><b>Mínim matricules (Opcional)</b></label>
- <?php
- echo '<input name="matricules_total" class="inputText" type="text">';
- ?>
- <!-- <input name="preferencia" class="inputText" type="text" required /> -->
- </p>
- <p>
- <b>Públic/Privat <br /></b>
- <label>
- <input type="radio" name="naturalesa" value="public" id="nivellEstudis_0" />
- Public</label>
- <br />
- <label>
- <input type="radio" name="naturalesa" value="privat" id="nivellEstudis_1" />
- Privat</label>
- <br />
- <br />
- <?php
- echo '<b>Preferencia de Municipis (Manté el CTRL per sel·leccionar més de un municipi)</b><br />';
- echo '<select multiple size="7" name="municipiestudis[]">';
- $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>';
- }
- echo '</select>';
- ?>
- <!--<b>Provincia dels Estudis</b><br />
- <select name="paisestudis" class="inputSelect">-->
- <!--<option value='alava'>Álava</option>
- <option value='albacete'>Albacete</option>
- <option value='alicante'>Alicante/Alacant</option>
- <option value='almeria'>Almería</option>
- <option value='asturias'>Asturias</option>
- <option value='avila'>Ávila</option>
- <option value='badajoz'>Badajoz</option>
- <option value='barcelona'>Barcelona</option>
- <option value='burgos'>Burgos</option>
- <option value='caceres'>Cáceres</option>
- <option value='cadiz'>Cádiz</option>
- <option value='cantabria'>Cantabria</option>
- <option value='castellon'>Castellón/Castelló</option>
- <option value='ceuta'>Ceuta</option>
- <option value='ciudadreal'>Ciudad Real</option>
- <option value='cordoba'>Córdoba</option>
- <option value='cuenca'>Cuenca</option>
- <option value='girona'>Girona</option>
- <option value='laspalmas'>Las Palmas</option>
- <option value='granada'>Granada</option>
- <option value='guadalajara'>Guadalajara</option>
- <option value='guipuzcoa'>Guipúzcoa</option>
- <option value='huelva'>Huelva</option>
- <option value='huesca'>Huesca</option>
- <option value='illesbalears'>Illes Balears</option>
- <option value='jaen'>Jaén</option>
- <option value='acoruña'>A Coruña</option>
- <option value='larioja'>La Rioja</option>
- <option value='leon'>León</option>
- <option value='lleida'>Lleida</option>
- <option value='lugo'>Lugo</option>
- <option value='madrid'>Madrid</option>
- <option value='malaga'>Málaga</option>
- <option value='melilla'>Melilla</option>
- <option value='murcia'>Murcia</option>
- <option value='navarra'>Navarra</option>
- <option value='ourense'>Ourense</option>
- <option value='palencia'>Palencia</option>
- <option value='pontevedra'>Pontevedra</option>
- <option value='salamanca'>Salamanca</option>
- <option value='segovia'>Segovia</option>
- <option value='sevilla'>Sevilla</option>
- <option value='soria'>Soria</option>
- <option value='tarragona'>Tarragona</option>
- <option value='santacruztenerife'>Santa Cruz de Tenerife</option>
- <option value='teruel'>Teruel</option>
- <option value='toledo'>Toledo</option>
- <option value='valencia'>Valencia/Valéncia</option>
- <option value='valladolid'>Valladolid</option>
- <option value='vizcaya'>Vizcaya</option>
- <option value='zamora'>Zamora</option>
- <option value='zaragoza'>Zaragoza</option></select>-->
- </p>
- <p> </p>
- <p>
- <input type="image" src="lupa.png" id="imgEnviar" />
- </p>
- </form>
- </div>
- <div id="header">
- <div id="logo"></div>
- <img src="Logo.jpg" width="198" height="164" alt="eligetucamino" />
- <div id="textoHeader">
- <h1>Filtre
- <br/>
- Busca el teu camí
- </h1>
- </div></div>
- <div id="nav">
- <ul>
- <li><a href="index.php">Inici</a></li>
- <li><a href="filtre.php">Filtre</a></li>
- <li><a href="resultat.php">Resultat</a></li>
- <li><a href="index.php?action=logout">Tancar sessió</a></li>
- </ul>
- </div>
- </body>
- </html>
- <?php
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement