Editing Drop Down Tanggal dengan Database Part 3 - AaEzha

<!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" />
<title>Untitled Document</title>
</head>

<body>
<?
if(isset($_POST['nama'])){
    $nama = $_POST['nama'];
    $tgl = $_POST['tgl'];
    $bln = $_POST['bln'];
    $thn = $_POST['thn'];

    mysql_connect("localhost","root","");
    mysql_select_db("tanggal");

    $query = mysql_query("insert into profil values('','$nama','$tgl-$bln-$thn')");
    if($query){
        echo "berhasil";
    }else{
        echo "gagal";
    }
}
?>
<form id="form1" name="form1" method="post" action="">
  <table width="700" border="0" cellspacing="0" cellpadding="5">
    <tr>
      <td width="144"><div align="right">Nama</div></td>
      <td width="536"><input type="text" name="nama" id="nama" /></td>
    </tr>
    <tr>
      <td><div align="right">Tanggal</div></td>
      <td><select name="tgl" id="tgl">
        <?
        for($n=1; $n<=31; $n++){
        ?>
        <option value="<?=$n;?>"><?=$n;?></option>
        <?
        }
        ?>
      </select>
        <select name="bln" id="bln">
          <?
          $bulan = array('Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September','Oktober','November','Desember');
          for($n=0; $n<=11; $n++){
          ?>
          <option value="<?=$bulan[$n];?>"><?=$bulan[$n];?></option>
          <?
          }
          ?>
        </select>
        <select name="thn" id="thn">
          <?
        for($n=1920; $n<=2013; $n++){
        ?>
          <option value="<?=$n;?>"><?=$n;?></option>
          <?
          }
          ?>
        </select>
      </td>
    </tr>
    <tr>
      <td><div align="right"></div></td>
      <td><input type="submit" name="button" id="button" value="Submit" /></td>
    </tr>
  </table>
</form>
</body>
</html>