API tools faq
paste
ridho123

edit.php

ridho123
Jan 23rd, 2017
86
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 13.35 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <head><title>Update Data Mahasiswa</title></head>
  3. <body bgcolor="purple">
  4. <?php
  5.  
  6. include "koneksi.php";
  7.  
  8. $kode=$_GET['kode'];
  9.  
  10. $query= "SELECT * FROM admin WHERE kode='$kode'";
  11. $hasil_query = mysql_query($query);
  12. $row= mysql_fetch_array($hasil_query);
  13.  
  14. $nisn= $row ['nisn'];
  15. $nama= $row ['nama'];
  16. $tgl_lahir= $row ['tgl_lahir'];
  17. $tempat= $row ['tempat'];
  18. $kelamin= $row ['kelamin'];
  19. $warga= $row ['warga'];
  20. $agama= $row ['agama'];
  21. $status= $row ['status'];
  22. $rumah= $row ['rumah'];
  23. $smg= $row ['smg'];
  24. $telp=$row ['telp'];
  25. $asal=$row ['asal'];
  26. $jenis= $row ['jenis'];
  27. $statuss= $row ['statuss'];
  28. $jurusan= $row ['jurusan'];
  29. $thun= $row ['thun'];
  30. $jurusan_pilihan= $row ['jurusan_pilihan'];
  31. $sts_mhs= $row ['sts_mhs'];
  32. $pilih_kuliah= $row ['pilih_kuliah'];
  33. $ayah= $row ['ayah'];
  34. $ibu= $row ['ibu'];
  35. $almt_ort= $row ['almt_ort'];
  36. $ayah= $row ['ayah'];
  37. $ibu= $row ['ibu'];
  38. $pdk_orta= $row ['pdk_orta'];
  39. $pdk_orti= $row ['pdk_orti'];
  40. $pkrayah= $row ['pkrayah'];
  41. $pkribu= $row ['pkribu'];
  42.  
  43. ?>
  44.  
  45. <form method="post" action="update.php">
  46. <table align="center" border="1" cellpadding="5" cellspacing="0">
  47. <tr bgcolor="lightgreen">
  48. <td Colspan="3" align="center"><H3>Ubah Data Mahasiswa Baru</H3></td>
  49.     </tr>
  50.     <tr>
  51.         <td>Kode</td>
  52.         <td>:</td>
  53.         <td>
  54.         <input type="text" name="kode"  size="40" value="<?php echo "$kode"; ?>" >
  55.         <input type="hidden" name="kode" size="40" value=" <?php echo "$kode"; ?>" >
  56.         </td>
  57.     </tr>
  58.    
  59.     <tr>
  60.         <td>NISN</td>
  61.         <td>:</td>
  62.         <td>
  63.         <input type="text" name="nisn" size="40" value="<?php echo "$nisn"; ?>"  >
  64.         </td>
  65.     </tr>
  66.    
  67.         <tr>
  68.         <td>Nama Mahasiswa</td>
  69.         <td>:</td>
  70.         <td>
  71.         <input type="text" name="nama" size="40"  value="<?php echo "$nama"; ?>" >
  72.         </td>
  73.     </tr>
  74.    
  75.     <tr>
  76.         <td>Tanggal Lahir</td>
  77.         <td>:</td>
  78.         <td>
  79.         <input type="text" name="tgl_lahir" size="40" value="<?php echo "$tgl_lahir"; ?>"  >
  80.         </td>
  81.     </tr>
  82.     <tr>
  83.         <td>Tempat Lahir</td>
  84.         <td>:</td>
  85.         <td>
  86.         <input type="text" name="tempat" size="40" value="<?php echo "$tempat"; ?>" >
  87.         </td>
  88.     </tr>
  89.     <tr>
  90.         <td>Kelamin</td>
  91.         <td>:</td>
  92.         <td>
  93.         <select name="kelamin">
  94.         <option></option>
  95.         <option value="Pria" <?php if($row['kelamin']=='Pria'){ echo 'selected';} ?>>Pria</option>
  96.         <option value="Wanita" <?php if($row['kelamin']=='Wanita'){ echo 'selected';} ?>>Wanita</option>
  97.         </select>
  98.         </td>
  99.     </tr>
  100.     <tr>
  101.         <td>Kewarganegaraan</td>
  102.         <td>:</td>
  103.         <td>
  104.         <select name="warga">
  105.         <option></option>
  106.         <option value="WNI" <?php if($row['warga']=='WNI'){ echo 'selected';} ?>>WNI</option>
  107.         <option value="WNA" <?php if($row['warga']=='WNA'){ echo 'selected';} ?>>WNA</option>
  108.         </select>
  109.         </td>
  110.     </tr>
  111.     <tr>
  112.         <td>Agama</td>
  113.         <td>:</td>
  114.         <td>
  115.         <select name="agama">
  116.         <option></option>
  117.         <option value="islam" <?php if($row['agama']=='islam'){ echo 'selected';} ?>>Islam</option>
  118.         <option value="katolik" <?php if($row['agama']=='katolik'){ echo 'selected';} ?>>Katolik</option>
  119.         <option value="kristen" <?php if($row['agama']=='kristen'){ echo 'selected';} ?>>Kristen</option>
  120.         <option value="budha" <?php if($row['agama']=='budha'){ echo 'selected';} ?>>Budha</option>
  121.         <option value="hindu" <?php if($row['agama']=='hindu'){ echo 'selected';} ?>>Hindu</option>
  122.         <option value="lain" <?php if($row['agama']=='lain'){ echo 'selected';} ?>>Lain</option>
  123.         </select>
  124.         </td>
  125.     </tr>
  126.     <tr>
  127.         <td>Status</td>
  128.         <td>:</td>
  129.         <td>
  130.         <select name="status">
  131.         <option></option>
  132.         <option value="belum" <?php if($row['status']=='belum'){ echo 'selected';} ?>>Belum Nikah</option>
  133.         <option value="nikah" <?php if($row['status']=='nikah'){ echo 'selected';} ?>>Nikah</option>
  134.         </td>
  135.     </tr>
  136.     <tr>
  137.         <td>Alamat Rumah</td>
  138.         <td>:</td>
  139.         <td>
  140.         <input type="text" name="rumah" size="40" value="<?php echo "$rumah"; ?>">
  141.         </td>
  142.     </tr>
  143.     <tr>
  144.         <td>Alamat Semarang</td>
  145.         <td>:</td>
  146.         <td>
  147.         <input type="text" name="smg" size="40"value="<?php echo "$smg"; ?>">
  148.         </td>
  149.     </tr>
  150.     <tr>
  151.         <td>Telepon</td>
  152.         <td>:</td>
  153.         <td>
  154.         <input type="text" name="telp" size="40" value="<?php echo "$telp"; ?>">
  155.         </td>
  156.     </tr>
  157.     <tr>
  158.         <td>Asal Sekolah</td>
  159.         <td>:</td>
  160.         <td>
  161.         <input type="text" name="asal" size="40" value="<?php echo "$asal"; ?>">
  162.         </td>
  163.     </tr>
  164.     <tr>
  165.         <td>Jenis Ijazah</td>
  166.         <td>:</td>
  167.         <td>
  168.         <select name="jenis">
  169.         <option></option>
  170.         <option value="SMA" <?php if($row['jenis']=='SMA'){ echo 'selected';} ?>>SMA</option>
  171.         <option value="SMK" <?php if($row['jenis']=='SMK'){ echo 'selected';} ?>>SMK</option>
  172.         <option value="Ponpes" <?php if($row['jenis']=='Ponpes'){ echo 'selected';} ?>>Ponpes</option>
  173.         <option value="MA" <?php if($row['jenis']=='MA'){ echo 'selected';} ?>>MA</option>
  174.         <option value="lain" <?php if($row['jenis']=='lain'){ echo 'selected';} ?>>Lain</option>
  175.         </select>
  176.         </td>
  177.     </tr>
  178.     <tr>
  179.         <td>Status Ijazah</td>
  180.         <td>:</td>
  181.         <td>
  182.         <select name="statuss">
  183.         <option></option>
  184.         <option value="negeri" <?php if($row['statuss']=='negeri'){ echo 'selected';} ?>>Negeri</option>
  185.         <option value="swasta" <?php if($row['statuss']=='swasta'){ echo 'selected';} ?>>Swasta</option>
  186.         <option value="luar negeri" <?php if($row['statuss']=='luar negeri'){ echo 'selected';} ?>>Luar Negeri</option>
  187.         <option value="lain" <?php if($row['statuss']=='lain'){ echo 'selected';} ?>>Lain</option>
  188.         </select>
  189.         </td>
  190.     </tr>
  191.     <tr>
  192.         <td>Jurusan Ijazah</td>
  193.         <td>:</td>
  194.         <td>
  195.         <select name="jurusan">
  196.         <option></option>
  197.         <option value="IPA" <?php if($row['jurusan']=='IPA'){ echo 'selected';} ?>>IPA</option>
  198.         <option value="IPS" <?php if($row['jurusan']=='IPS'){ echo 'selected';} ?>>IPS</option>
  199.         <option value="Bahasa" <?php if($row['jurusan']=='Bahasa'){ echo 'selected';} ?>>Bahasa</option>
  200.         <option value="Agama" <?php if($row['jurusan']=='Agama'){ echo 'selected';} ?>>Agama</option>
  201.         <option>Lain</option></select>
  202.         </td>
  203.     </tr>
  204.     <tr>
  205.         <td>Tahun Ijazah</td>
  206.         <td>:</td>
  207.         <td>
  208.         <input type="text" name="thun" size="40" value="<?php echo "$thun"; ?>">
  209.         </td>
  210.     </tr>
  211.     <tr>
  212.         <td>Jurusan Pilihan</td>
  213.         <td>:</td>
  214.         <td>
  215.         <select name="jurusan_pilihan">
  216.         <option></option>
  217.         <option value="teknik mesin" <?php if($row['jurusan_pilihan']=='teknik mesin'){ echo 'selected';} ?>>Teknik Mesin</option>
  218.         <option value="Teknik kimia" <?php if($row['jurusan_pilihan']=='Teknik kimia'){ echo 'selected';} ?>>Teknik Kimia</option>
  219.         <option value="Teknik Informatika" <?php if($row['jurusan_pilihan']=='Teknik Informatika'){ echo 'selected';} ?>>Teknik Informatika</option>
  220.         <option value="Farmasi" <?php if($row['jurusan_pilihan']=='Farmasi'){ echo 'selected';} ?>>Farmasi</option>
  221.         <option value="Manajemen" <?php if($row['jurusan_pilihan']=='Manajemen'){ echo 'selected';} ?>>Manajemen</option>
  222.         <option value="Akuntansi" <?php if($row['jurusan_pilihan']=='Akuntansi'){ echo 'selected';} ?>>Akuntansi</option>
  223.         <option value="Hukum" <?php if($row['jurusan_pilihan']=='Hukum'){ echo 'selected';} ?>>Hukum</option>
  224.         <option value="Agribisnis" <?php if($row['jurusan_pilihan']=='Agribisnis'){ echo 'selected';} ?>>Agribisnis</option>
  225.         <option value="PAI" <?php if($row['jurusan_pilihan']=='PAI'){ echo 'selected';} ?>>PAI</option>
  226.         <option value="PGMI" <?php if($row['jurusan_pilihan']=='PGMI'){ echo 'selected';} ?>>PGMI</option>
  227.         <option value="Hukum Ekonomi Syariah" <?php if($row['jurusan_pilihan']=='Hukum Ekonomi syariah'){ echo 'selected';} ?>>Hukum Ekonomi Syari'ah</option>
  228.         <option value="Ilmu Politik" <?php if($row['jurusan_pilihan']=='Ilmu Politik'){ echo 'selected';} ?>>Ilmu Politik</option>
  229.         <option value="Hub.internasional" <?php if($row['jurusan_pilihan']=='Hub.internasional'){ echo 'selected';} ?>>Hub. Internasional</option>
  230.         <option value="Ekonomi Syariah" <?php if($row['jurusan_pilihan']=='Ekonomi Syariah'){ echo 'selected';} ?>>Ekonomi Syari'ah</option>
  231.         <option value="Pend. Olahraga" <?php if($row['jurusan_pilihan']=='Pend. Olahraga'){ echo 'selected';} ?>>Pend. Olahraga</option>
  232.         <option value="Kedokteran" <?php if($row['jurusan_pilihan']=='Kedokteran'){ echo 'selected';} ?>>Kedokteran</option></select>
  233.         </td>
  234.     </tr>
  235.     <tr>
  236.         <td>Status Mahasiswa</td>
  237.         <td>:</td>
  238.         <td>
  239.         <select name="sts_mhs">
  240.         <option></option>
  241.         <option value="baru" <?php if($row['sts_mhs']=='baru'){ echo 'selected';} ?>>Baru</option>
  242.         <option value="transfer" <?php if($row['sts_mhs']=='transfer'){ echo 'selected';} ?>>Transfer</option>
  243.         </select>
  244.         </td>
  245.     </tr>
  246.     <tr>
  247.         <td>Pilihan Kuliah</td>
  248.         <td>:</td>
  249.         <td>
  250.         <select name="pilih_kuliah">
  251.         <option></option>
  252.         <option value="reguler" <?php if($row['pilih_kuliah']=='reguler'){ echo 'selected';} ?>>Reguler</option>
  253.         <option value="Ekstensi" <?php if($row['pilih_kuliah']=='Ekstensi'){ echo 'selected';} ?>>Ekstensi</option></select>
  254.         </td>
  255.     </tr>
  256.     <tr class="genap">
  257.         <td>Nama Ayah</td>
  258.         <td>:</td>
  259.         <td>
  260.         <input type="text" name="ayah" size="40"value="<?php echo "$ayah"; ?>">
  261.         </td>
  262.     </tr>  
  263.     <tr>
  264.         <td>Nama Ibu</td>
  265.         <td>:</td>
  266.         <td>
  267.         <input type="text" name="ibu" size="40"value="<?php echo "$ibu"; ?>">
  268.         </td>
  269.     </tr>
  270.     <tr>
  271.         <td>Alamat</td>
  272.         <td>:</td>
  273.         <td>
  274.         <input type="text" name="almt_ort" size="40"value="<?php echo "$almt_ort"; ?>">
  275.         </td>
  276.     </tr>
  277.     <tr>
  278.         <td>Pendidikan Ayah</td>
  279.         <td>:</td>
  280.         <td>
  281.         <select name="pdk_orta">
  282.         <option></option>
  283.         <option value="SD" <?php if($row['pdk_orta']=='SD'){ echo 'selected';} ?>>SD</option>
  284.         <option value="SLTP" <?php if($row['pdk_orta']=='SLTP'){ echo 'selected';} ?>>SLTP</option>
  285.         <option value="SLTA" <?php if($row['pdk_orta']=='SLTA'){ echo 'selected';} ?>>SLTA</option>
  286.         <option value="Sarjana" <?php if($row['pdk_orta']=='Sarjana'){ echo 'selected';} ?>>Sarjana</option>
  287.         <option value="Sarjana Muda" <?php if($row['pdk_orta']=='Sarjana Muda'){ echo 'selected';} ?>>Sarjana Muda</option>
  288.         <option value="Magister" <?php if($row['pdk_orta']=='Magister'){ echo 'selected';} ?>>Magister</option>
  289.         <option value="Profesor" <?php if($row['pdk_orta']=='Profesor'){ echo 'selected';} ?>>Profesor</option>
  290.         <option value="Doktor" <?php if($row['pdk_orta']=='Doktor'){ echo 'selected';} ?>>Doktor</option>
  291.         <option value="Lain" <?php if($row['pdk_orta']=='Lain'){ echo 'selected';} ?>>Lain</option>
  292.         </select>
  293.         </td>
  294.     </tr>
  295.     <tr>
  296.         <td>Pendidikan Ibu</td>
  297.         <td>:</td>
  298.         <td>
  299.         <select name="pdk_orti">
  300.         <option></option>
  301.         <option value="SD" <?php if($row['pdk_orti']=='SD'){ echo 'selected';} ?>>SD</option>
  302.         <option value="SLTP" <?php if($row['pdk_orta']=='SLTP'){ echo 'selected';} ?>>SLTP</option>
  303.         <option value="SLTA" <?php if($row['pdk_orta']=='SLTA'){ echo 'selected';} ?>>SLTA</option>
  304.         <option value="Sarjana" <?php if($row['pdk_orta']=='Sarjana'){ echo 'selected';} ?>>Sarjana</option>
  305.         <option value="Sarjana Muda" <?php if($row['pdk_orta']=='Sarjana Muda'){ echo 'selected';} ?>>Sarjana Muda</option>
  306.         <option value="Magister" <?php if($row['pdk_orta']=='Magister'){ echo 'selected';} ?>>Magister</option>
  307.         <option value="Profesor" <?php if($row['pdk_orta']=='Profesor'){ echo 'selected';} ?>>Profesor</option>
  308.         <option value="Doktor" <?php if($row['pdk_orta']=='Doktor'){ echo 'selected';} ?>>Doktor</option>
  309.         <option value="Lain" <?php if($row['pdk_orta']=='Lain'){ echo 'selected';} ?>>Lain</option>
  310.         </select>
  311.         </td>
  312.     </tr>
  313.     <tr>
  314.         <td>Pekerjaan Ayah</td>
  315.         <td>:</td>
  316.         <td>
  317.         <select name="pkrayah">
  318.         <option></option>
  319.         <option value="PNS" <?php if($row['pkrayah']=='PNS'){ echo 'selected';} ?>>PNS</option>
  320.         <option value="TNI" <?php if($row['pkrayah']=='TNI'){ echo 'selected';} ?>>TNI</option>
  321.         <option value="POLRI" <?php if($row['pkrayah']=='POLRI'){ echo 'selected';} ?>>POLRI</option>
  322.         <option value="WIRASWASTA" <?php if($row['pkrayah']=='WIRASWASTA'){ echo 'selected';} ?>>WIRASWASTA</option>
  323.         <option value="PETANI" <?php if($row['pkrayah']=='PETANI'){ echo 'selected';} ?>>PETANI</option>
  324.         <option value="PENSIUNAN" <?php if($row['pkrayah']=='PENSIUNAN'){ echo 'selected';} ?>>PENSIUNAN</option>
  325.         <option value="PEGAWAI SWASTA" <?php if($row['pkrayah']=='PEGAWAI SWASTA'){ echo 'selected';} ?>>PEGAWAI SWASTA</option>
  326.         <option value="LAIN" <?php if($row['pkrayah']=='LAIN'){ echo 'selected';} ?>>LAIN</option>
  327.         </select>
  328.         </td>
  329.     </tr>
  330.     <tr>
  331.         <td>Pekerjaan Ibu</td>
  332.         <td>:</td>
  333.         <td>
  334.         <select name="pkribu">
  335.         <option></option>
  336.         <option value="PNS" <?php if($row['pkribu']=='PNS'){ echo 'selected';} ?>>PNS</option>
  337.         <option value="TNI" <?php if($row['pkrayah']=='TNI'){ echo 'selected';} ?>>TNI</option>
  338.         <option value="POLRI" <?php if($row['pkrayah']=='POLRI'){ echo 'selected';} ?>>POLRI</option>
  339.         <option value="WIRASWASTA" <?php if($row['pkrayah']=='WIRASWASTA'){ echo 'selected';} ?>>WIRASWASTA</option>
  340.         <option value="PETANI" <?php if($row['pkrayah']=='PETANI'){ echo 'selected';} ?>>PETANI</option>
  341.         <option value="PENSIUNAN" <?php if($row['pkrayah']=='PENSIUNAN'){ echo 'selected';} ?>>PENSIUNAN</option>
  342.         <option value="PEGAWAI SWASTA" <?php if($row['pkrayah']=='PEGAWAI SWASTA'){ echo 'selected';} ?>>PEGAWAI SWASTA</option>
  343.         <option value="LAIN" <?php if($row['pkrayah']=='LAIN'){ echo 'selected';} ?>>LAIN</option>
  344.         </select>
  345.         </td>
  346.     </tr>
  347.    
  348. <tr align=center>
  349. <td Colspan=3>
  350. <table align="center" width="400" height="100"  cellpadding="4" cellspacing="0">
  351. <tr bgcolor="deepskyblue"><td>
  352. <input type="submit" value="Update" name="simpan">
  353. [<a href=view.php>Lihat Data Mahasiswa Baru</a>]
  354. </td></tr></table></form></body></html>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!