prova a fare così. Fammi sapere se non ti funziona
Codice PHP:
<?php
if(isset($_POST['invia'])) {
$connessione = mysql_connect("localhost", "kennedyconnect", "");
if(!mysql_select_db($connessione, "my_kennedyconnect"))
die("Errore nella connessione al database");
$username = $_POST['username'];
$giorno = $_POST['birthday_day'];
$mese = $_POST['birthday_month'];
$anno = $_POST['birthday_year'];
$sql = "SELECT username FROM utenti WHERE username = '".$username."' LIMIT 1";
$q = mysql_query($sql);
$righe = mysql_num_rows($q);
if($righe == 1) {
die("Username già esistente!");
} else {
$sql2 = "INSERT INTO utenti(username, data_nascita) VALUES('".$username."', '".$giorno."/".$mese."/".$anno"')";
if(!mysql_query($sql2)
die("Errore nell'inserimento dei dati");
}
} else {
?>
<form method="post" action="">
Username:
<input type="text" name="username" id="username">
Data di nascita:
<select name="birthday_day" id="birthday_day">
<option value="-1">Giorno:</option>
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select class="" id="birthday_month" name="birthday_month">
<option value="-1">Mese:</option>
<option value="01">gennaio</option>
<option value="02">febbraio</option>
<option value="03">marzo</option>
<option value="04">aprile</option>
<option value="05">maggio</option>
<option value="06">giugno</option>
<option value="07">luglio</option>
<option value="08">agosto</option>
<option value="09">settembre</option>
<option value="10">ottobre</option>
<option value="11">novembre</option>
<option value="12">dicembre</option>
</select>
<select name="birthday_year" id="birthday_year">
<option value="-1">Anno:</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
</select>
<input type="submit" name="invia">
</form>
<?php
}
?>