Untitled

<?php
include_once "inc.koneksi.php";
if(isset($_GET['cifubah'])){
$cifubah  = $_GET['cifubah'];
}else{
$cifubah =$TxtcifH;
}
$SQL = "SELECT * FROM dep WHERE cif=\"$cifubah\"";
$ret_SQL = mysql_query($SQL )or die(mysql_error());
if(mysql_num_rows($ret_SQL) == 0){
	echo "data $cifubah tidak ada";
}
$data = mysql_fetch_array($ret_SQL);
?>
<html>
<head>
<title>Form Ubah Data</title>
</head>
<body>
<form name="form1" enctype="multipart/form-data" method="post" action="OutPegEdSim.php">
<table width="760" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#CCFF00">
  <td colspan="2" bgcolor="#99FF66"><div align="center"><b>UBAH DATA BASE REKAP DEPOSITO </b></div></td>
</tr>
<tr>
  <td width="183"><b>C I F BANK</b></td>
  <td width="577">:
    <?php echo $data['cif']; ?>
    <input name="TxtcifH" type="hidden" value="<?php echo $data['cif']; ?>"></td>
</tr>
<tr>
  <td><b>NAMA NASABAH</b></td>
  <td>:
    <input name="Txtnama" type="text" value="<?php echo $data['nama']; ?>" size="30" maxlength="60"></td>
<tr>
  <td><b>NOMOR BILYED</b></td>
  <td>:
    <input name="Txtnobil" type="text" value="<?php echo $data['nobil']; ?>" size="30" maxlength="60"></td>
</tr>
<tr>
  <td><b>ALAMAT</b></td>
  <td>:
    <input name="Txtalamat" type="text" value="<?php echo $data['alamat']; ?>" size="30" maxlength="60"></td>
</tr>
<tr>
  <td><b>NOMOR TELEPON</b></td>
  <td>:
    <input name="Txttelp" type="text" value="<?php echo $data['telp']; ?>" size="30" maxlength="60"></td>
</tr>
<tr>
  <td><b>TANGGAL JATUH TEMPO </b></td>
  <td>:
    <select name="CmbTgl2">
      <?php
        for ($tgl=1; $tgl <= 31; $tgl++) {
            $tgl = (strlen($tgl)==1)?"0".$tgl:$tgl;
            if ($tgl==$datatgl[2]) {
                $cek =" selected";
                echo "<option value='$tgl' $cek> $tgl </option>";
            }
            else {
                $cek ="";
                echo "<option value='$tgl' $cek> $tgl </option>";
            }


        }
      ?>
    </select> /
    <select name="CmbBln2">
      <?php
        for ($bln=1; $bln <= 12; $bln++) {
            $tgla = date("j-M-Y", mktime(0, 0, 0, $bln, $datatgl[0], $datatgl[2]));
            $tglb = $datatgl[0]."-".$datatgl[1]."-".$datatgl[2];
           $bln = (strlen($bln)==1)?"0".$bln:$bln;
            if ($bln == $datatgl[1]) {
                $cek =" selected";
                echo "<option value='$bln' $cek> $bln </option>";
            }
            else {
                $cek ="";
                echo "<option value='$bln' $cek> $bln </option>";
            }


        }
      ?>
     </select> /
    <select name="CmbThn2">
      <?php
        for ($thn=2000; $thn <= 2010; $thn++) {
            if ($thn==$datatgl[0]) {
                $cek =" selected";
                echo "<option value='$thn' $cek> $thn </option>";
            }
            else {
                $cek ="";
                echo "<option value='$thn' $cek> $thn </option>";
            }


        }
      ?>
     </select>
     </td>
</tr>
<tr>
  <td><b>SUKU BUNGA</b></td>
  <td>:
    <input name="Txtsubung" type="text" value="<?php echo $data['subung']; ?>" size="30" maxlength="60"></td>
</tr>
<tr>
  <td><b>JANGKA WAKTU</b></td>
  <td>:
    <input name="Txtjw" type="text" value="<?php echo $data['jw']; ?>" size="30" maxlength="60"></td>
</tr>
<tr>
  <td><b>NOMINAL</b></td>
  <td>:
    <input name="Txtnominal" type="text" value="<?php echo $data['nominal']; ?>" size="30" maxlength="60"></td>
</tr>

<tr>
  <td><b>STATUS </b></td>
  <td>:
      <?php
	$cek_a=$cek_b="";
      if ($data['status']=="A") {
           $cek_a = " checked";
      }
	else{
           $cek_b = " checked";
      }
      ?>
      <input name="Rbstatus" type="radio" value="ACTIVE" <?php echo $cek_a; ?>>
      MASUK
      <input name="Rbstatus" type="radio" value="IN ACTIVE" <?php echo $cek_b; ?>>
      KELUAR </td>
</tr>

<tr>
  <td>&nbsp;</td>
  <td><input type="submit" name="Submit" value="UBAH"></td>
</tr>
</table>
</form>
</body>
</html>