Codice PHP:
<html>
<head>
<title>Inserisci i tuoi dati</title>
</head>
<body>
<center><h1>Inserisci i tuoi dati</h1></center>
<?php
include("db.php");
echo '<center>';
echo "<h2>Il tuo codice utente è: ";
srand((double)microtime()*1000000);
echo rand(0,100000000);
echo '</h2>';
echo '<form method="post" action="insert_iscrizione.php">';
echo ' <table>';
echo ' <tr><td>Nick:</td><td><input type="text" name="nick" size="20" maxlength="20"></td></tr>';
echo ' <tr><td>Forum:</td><td><select name="forum">';
$sql = "select * FROM forum";
$result = mysql_query($sql);
while ($forum = mysql_fetch_row($result)) {
echo(" <option name='$forum[0]'>$forum[1]</option> ");
}
echo '</select></td></tr>';
echo ' <tr><td>Nome:</td><td><input type="text" name="nome" size="20" maxlength="20"></td></tr>';
echo ' <tr><td>Cognome:</td><td><input type="text" name="cognome" size="20" maxlength="20"></td></tr>';
echo ' <tr><td>Email:</td><td><input type="text" name="email" size="20" maxlength="20"></td></tr>';
echo ' <tr><td>Regione:</td><td><select name="regione">';
$sql = "select * FROM regioni";
$result = mysql_query($sql);
while ($regioni = mysql_fetch_row($result)) {
echo(" <option name='$regioni[0]'>$regioni[1]</option> ");
}
echo '</select></td></tr>
<tr><td>Provincia:</td><td><select name="provincia">';
include("db.php");
$sql = "select * FROM province";
$result = mysql_query($sql);
while ($province = mysql_fetch_row($result)) {
echo("
<option name='$province[0]'>$province[1]</option> ");
}
echo '</select></td></tr>
<tr><td>Città:</td><td><select name="citta">';
include("db.php");
$sql = "select * FROM comuni";
$result = mysql_query($sql);
while ($comuni = mysql_fetch_row($result)) {
echo("
<option name='$comuni[0]'>$comuni[1]</option> ");
}
echo '</select></td></tr>
<tr><td colspan=\"2\"><input type="submit" value="Conferma"></td><td <INPUT TYPE="RESET" VALUE="Azzera"></td></tr>';
echo '</table>';
echo '</form></center>';
?>
</body>
</html>