Editing Drop Down Tanggal dengan Database Part 4 - 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($_GET['id']){
    $id = $_GET['id'];
    mysql_connect("localhost","root","");
    mysql_select_db("tanggal");
    $query = mysql_query("select * from profil where id='$id'");
    $data = mysql_fetch_array($query);
    $tanggal = explode("-",$data['tanggal']);
    $tgl = $tanggal[0];
    $bln = $tanggal[1];
    $thn = $tanggal[2];

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("update profil set nama='$nama', tanggal='$tgl-$bln-$thn' where id='$id'");
    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" value="<?=$data['nama'];?>" /></td>
    </tr>
    <tr>
      <td><div align="right">Tanggal</div></td>
      <td><select name="tgl" id="tgl">
        <?
        for($n=1; $n<=31; $n++){
            if($tgl == $n){
        ?>
        <option value="<?=$n;?>" selected="selected"><?=$n;?></option>
        <?
            }else{
        ?>
        <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++){
            if($bln == $bulan[$n]){
          ?>
          <option value="<?=$bulan[$n];?>" selected="selected"><?=$bulan[$n];?></option>
          <?
            }else{
          ?>
          <option value="<?=$bulan[$n];?>"><?=$bulan[$n];?></option>
          <?
            }
          }
          ?>
        </select>
        <select name="thn" id="thn">
          <?
          for($n=1920; $n<=2013; $n++){
            if($thn == $n){
          ?>
          <option value="<?=$n;?>" selected="selected"><?=$n;?></option>
          <?
            }else{
          ?>
          <option value="<?=$n;?>"><?=$n;?></option>
          <?
            }
          }
          ?>
        </select>
      </td>
    </tr>
    <tr>
      <td><div align="right"></div></td>
      <td><input type="submit" name="button" id="button" value="Edit" /></td>
    </tr>
  </table>
</form>
<?
}
?>
</body>
</html>