<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Modulo d'iscrizione</title>
<link href="style.css" rel="stylesheet" type="text/css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
</head>
<body>
</body>
<DOCTYP<?php
require_once("connettimysqli.php");
require_once("data.php");
if (!empty($_POST)) {
$id = mysqli_real_escape_string($con, $_POST['id']);
$cognome = mysqli_real_escape_string($con, $_POST['cognome']);
$nome = mysqli_real_escape_string($con, $_POST['nome']);
$giorno = mysqli_real_escape_string($con, $_POST['giorno']);
$mese = mysqli_real_escape_string($con, $_POST['mese']);
$anno = mysqli_real_escape_string($con, $_POST['anno']);
$nazionalita = mysqli_real_escape_string($con, $_POST['nazionalita']);
$citta = mysqli_real_escape_string($con, $_POST['citta']);
$prov = mysqli_real_escape_string($con, $_POST['prov']);
$username = mysqli_real_escape_string($con, $_POST['username']);
$email = mysqli_real_escape_string($con, $_POST['email']);
$ripemail = mysqli_real_escape_string($con, $_POST['ripemail']);
$password = mysqli_real_escape_string($con, $_POST['password']);
$rippassword = mysqli_real_escape_string($con, $_POST['rippassword']);
if (!checkdate($mese, $giorno, $anno)) {
echo "<p><strong>Errore</strong>: Data non valida</p>";
}
$nascita = sprintf("%04d%02d%02d", $anno, $mese, $giorno);
$query = "SELECT count(*) FROM UTENTI";
$result = mysqli_query($con, $query);
if(!$result) echo "Errore Query";
else{
$row = mysqli_num_rows($result);
if($row > 0) $indice = 1;
else $indice = 0;
}
$query = "INSERT INTO utenti (cognome, nome, nascita, nazionalita, username, email, password) "
. "VALUES('$cognome','$nome','$nascita','$nazionalita','$username','$email','$password')";
$result = mysqli_query($con, $query);
if ($result !== false) {
echo "<p>Inserimento avvenuto correttamente<p>";
} else {
echo "<p>Inserimento non eseguito.<br />";
echo '<strong>Errore</strong>: '.mysqli_error($con).'</p>';
}
}
?>
<DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<script>
function funzione(indice){
if(indice == 1){
$("#nazione").show();
$("#nazionalita").hide();
}
else {
$("#nazionalita").show();
$("#nazione").hide();
}
</script>
</head>
<body onLoad="funzione(<?php echo $indice ?>)">
</head>
<body>
<div id="intestazione">
<h2>BENVENUTI NEL MODULO D'ISCRIZIONE</h2>
<hr>
</div>
<div id="divhr">
<form method="POST" autocomplete="off" action="<?php $_SERVER['PHP_SELF'] ?>">
<p>
<label for="campo-cognome">Cognome: </label>
<input type="text" name="cognome" required />
</p>
<p>
<label for="campo-nome">Nome: </label>
<input type="text" name="nome" required />
</p>
Seleziona la data di nascita (gg/mm/aaaa):
<select name="giorno">
<option value="">Scegli giorno: </option>
<?php for ($i = 0; $i < 32; $i++): ?>
<option value="<?= $i ?>"><?= $i ?></option>;
<?php endfor; ?>
</select>
<select name="mese">
<option value="">Scegli mese: </option>
<?php for ($i = 1; $i < 13; $i++): ?>
<option value="<?= $i ?>"><?= $i ?></option>
<?php endfor; ?>
</select>
<select name="anno">
<option value="">Scegli anno: </option>
<?php for ($i = 2012; $i >= 1920; $i--): ?>
<option value="<?= $i ?>"><?= $i ?></option>
<?php endfor; ?>
</select>
<div id = "posnazionalita">
<p>
<label for="campo-nazionalita">Nazionalità: </label>
<input type="text" name="nazionalita" required/>
</p>
</div>
<?php if (!empty($nazionalite)): ?>
<select hidden="true" name="nazione"
<option value="">-seleziona-</option>
<?php foreach ($nazionalite as $entry): ?>
<option value="<?= $entry ?>"><?= $entry ?></option>
<?php endforeach; ?>
</select>
<?php endif; ?>
<div id="posusername">
<p>
<label for="campo-username">Username: </label>
<input type="text" name="username" required/>
</p>
</div>
<div id="posemail">
<p>
<label for="campo-email">Email: </label>
<input type="text" name="email" required/>
</p>
</div>
<div id="posripemail">
<p>
<label for="campo-ripemail">Ripeti-Email: </label>
<input type="text" name="ripemail" required/>
</p>
</div>
<div id="pospassword">
<p>
<label for="campo-password">Password: </label>
<input type="password" name="password" required/>
</p>
</div>
<div id="posripassword">
<p>
<label for="campo-ripemail">Ripeti-Password: </label>
<input type="password" name="rippassword" required/>
</p>
</div>
<div align ="center">
<input type="submit" name="reg" value="Invio dati" id="submit" />
</div>
</form>
</div>
<?php
echo "</hr>";
?>
</body>
</html>