Advertisement
habibikapurba

errorupdate

Nov 1st, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.91 KB | None | 0 0
  1.  
  2. <?php
  3.  
  4.     include "koneksi.php";
  5.     if (isset($_GET['edit_id'])) {
  6.         $sql3 = "select * from daftar where id_reg=" .$_GET['edit_id'];
  7.         $result = mysqli_query($connect, $sql3);
  8.         $row = mysqli_fetch_array($result);
  9.                
  10.     }
  11.    
  12.  
  13.         if (isset($_POST['update'])) {
  14.             $nama_reg = $_POST['nama_reg'];
  15.             $no_telp = $_POST['no_telp'];
  16.             $alamat = $_POST['alamat'];
  17.             $jenis_kel = $_POST['jenis_kel'];
  18.             $agama = $_POST['agama'];
  19.             $email = $_POST['email'];
  20.             $username = $_POST['username'];
  21.             $password = $_POST['password'];
  22.  
  23.         $edit = "update daftar set nama_reg='$nama_reg', no_telp='$no_telp', alamat='$alamat', email='$email', username='$username', password='$password' where id_reg=".$_GET['update'];
  24.         $result = mysqli_query($connect,$edit);
  25.         if (!isset($sql3)) {
  26.                 die("error $sql3" .mysqli_connect_error());
  27.             }else{
  28.                 header("location:data.php");
  29.             }
  30.         }
  31.  
  32.  ?>
  33. <h4 align="right"><a href="data.php">Lihat Data</a></h4>
  34. <center><h1>Form Edit</h1></center>
  35.  
  36.  
  37.  <form method="post" action="">
  38.     <table align="center" cellpadding="3" cellspacing="0" width="600">
  39.        
  40.     <tr>
  41.         <td>Nama</td><td>:</td><td><input type="text" name="nama_reg" size="40" value="<?=$row['nama_reg'];?>"></td>
  42.     </tr>
  43.     <tr>
  44.         <td>No. Telp</td><td>:</td><td><input type="text" name="no_telp" size="40" value="<?=$row['no_telp'];?>"></td>
  45.     </tr>
  46.     <tr>
  47.         <td>Alamat</td><td>:</a></td><td><textarea name="alamat" cols="42" rows="7"><?=$row['alamat'];?></textarea></td>
  48.     </tr>
  49.     <tr>
  50.         <td>Jenis Kelamin</td><td>:</td><td><input type="radio" value="Laki-laki" name="jenis_kel">Laki-laki
  51.                                             <input type="radio" value="Perempuan" name="jenis_kel">Perempuan</td>
  52.     </tr>
  53.     <tr>
  54.         <td>Agama</td><td>:</td><td><select name="agama">
  55.                                         <option value="">--Pilih--</option>
  56.                                         <option value="Islam">Islam</option>
  57.                                         <option value="Budha">Budha</option>
  58.                                         <option value="Hindu">Hindu</option>
  59.                                         <option value="Khatolik">Katholik</option>
  60.                                         <option value="Kristen">Kristen</option>
  61.                                     </select></td>
  62.     </tr>
  63.     <tr>
  64.         <td>E-mail</td><td>:</td><td><input type="text" name="email" size="40" value="<?=$row['email'];?>"></td>
  65.     </tr>
  66.     <tr>
  67.         <td>Username</td><td>:</td><td><input type="text" name="username" size="40" value="<?=$row['username'];?>"></td>
  68.     </tr>
  69.     <tr>
  70.         <td>Password</td><td>:</td><td><input type="password" name="password" size="40" value="<?=$row['password'];?>"></td>
  71.         <td></td><td></td><td><input type="hidden" name="id_reg" value="<?=$row['id_reg'];?>"></td>
  72.     </tr>
  73.     <tr>
  74.         <td colspan="3" align="center">
  75.         <button type="submit" name="update" id="update" onclick="update()">Update</button>
  76.             <a href="data.php"><button type="reset" name="Cancel" id="cancel">Cancel</button></a>
  77.         </td>
  78.     </tr>
  79.  
  80.     </table>
  81.    
  82.  
  83. </form>
  84. <script type="text/javascript">
  85.    
  86. function Update(){
  87.     var x;
  88.     if (confirm("Update data berhasil") == true) {
  89.         x="update";
  90.     }
  91. }
  92. </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement