Say Hello

Rabu, 06 April 2011

Membuat Form Update.php

ni script buat bikin halaman update...bukan tuk update status kaya d facebook gan,,cuman tuk update data yg ada di database


<?php
include ("config.php");

$id=$_GET['id'];
$sql="SELECT * FROM mhs WHERE id='$id'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
?>

<!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=iso-8859-1" />
<title>Untitled Document</title>
<link href="coba2.css" type="text/css" rel="stylesheet" />

</head>

<body>
<form action="proses_update.php" method="post">
<table align="center"width="534" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="89"><div align="right">Nim</div></td>
<td width="451"><input name="nim" type="text" id="nim" value="<?php echo $row ['nim']; ?>" size="10" />
<input name="id" type="hidden" id="id" value="<?php echo $row ['id']; ?>"></td>
</tr>
<tr>
<td><div align="right">Nama</div></td>
td><input name="nama" type="text" id="nama" value="<?php echo $row ['nama']; ?>" size="25" /></td>

</tr>
  <tr>
<td><div align="right">Jenis Kelamin </div></td>
<td><select name="jkl" id="jkl">
<option>Jenis Kelamin</option>
<?php if ($row['jkl'] == "L") echo "<option value='L' selected>Laki-laki</option>";
      else echo "<option value='L'>Laki-laki</option>";
   if ($row['jkl'] == "P") echo "<option value='P' selected>Perempuan</option>";
      else echo "<option value='P'>Perempuan</option>";
 ?>  
</select>
</td>
           
  </tr>
  <tr>
  <td><div align="right">Jurusan</div></td>
  <td><select name="jurusan" id="jurusan">
  <option>Jurusan</option>
     
<?php if ($row['jurusan'] == "Teknik Mesin") echo "<option value='Teknik Mesin' selected>Teknik Mesin</option>";

 else echo "<option value='Teknik Mesin'>Teknik Mesin</option>";
               if ($row['jurusan'] == "Teknik Informatika") echo "<option value='Teknik Informatika' selected>Teknik Informatika</option>";
           else echo "<option value='Teknik Informatika'>Teknik Informatika</option>";
            ?>  
            </select>    </td>
  </tr>
  <tr>
    <td><div align="right">TTL</div></td>
    <td><input name="tmpt_lahir" type="text" id="tmpt_lahir" value="<?php echo $row ['tmpt_lahir']; ?>" />
    ,
      <select name="tgl_lahir" id="tgl_lahir">
        <option>Tanggal</option>
            <?php if ($row ['tgl_lahir']=="1") echo "<option value='1' selected>1</option>";
                  else echo "<option value='1'>1</options>";
        if ($row ['tgl_lahir']=="2") echo "<option value='2' selected>2</option>";
                  else echo "<option value='2'>2</options>";
            if ($row ['tgl_lahir']=="3") echo "<option value='3' selected>3</option>";
                  else echo "<option value='3'>3</options>";     
            if ($row ['tgl_lahir']=="4") echo "<option value='4' selected>4</option>";
                  else echo "<option value='1'>1</options>";  
        if ($row ['tgl_lahir']=="5") echo "<option value='5' selected>5</option>";
                  else echo "<option value='5'>5</options>";  
                    ?>
      </select>
      <select name="bln_lahir" id="bln_lahir">
        <option selected="selected">Bulan</option>
    <?php if ($row ['bln_lahir']=="Januari") echo "<option value='Januari' selected>Januari</option>";
          else echo "<option value='Januari'>Januari</option>";
            if ($row ['bln_lahir']=="Februari") echo "<option value='Februari' selected>Februari</option>";
            else echo "<option value='Februari'>Februari</option>";
              if ($row ['bln_lahir']=="Maret") echo "<option value='Maret' selected>Maret</option>";
            else echo "<option value='Maret'>Maret</option>";

      ?>
          </select>
      <select name="thn_lahir" id="thn_lahir">
        <option>Tahun</option>
        <?php if ($row ['thn_lahir']=="1990") echo "<option value='1990' selected>1990</option>";
                  else echo "<option value='1990'>1990</options>";
        if ($row ['thn_lahir']=="1991") echo "<option value='1991' selected>1991</option>";
                  else echo "<option value='1991'>1991</options>";
            ?>
      </select>      </td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><input type="submit" name="Submit" value="Update" /></td>
  </tr>
</table>

</form>
</body>
</html>


pusink ya gan liatnya,,,hahahaaa..ane juga pusink gan,,,tapi klo udh ngerti dasar PHP ngampang koq gan...

Tidak ada komentar:

Posting Komentar