Advertisement
Guest User

EDIT

a guest
Jul 13th, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.58 KB | None | 0 0
  1. <?php
  2.     $servername = "localhost";
  3.     $username = "root";
  4.     $password = "";
  5.     $dbname = "pendaftaran";
  6.  
  7.     $connect = new mysqli($servername,$username,$password,$dbname);
  8.  
  9.     if ($connect->connect_error) {
  10.         echo "CONNECTING ERROR";
  11.     }
  12.     $id = $_GET['ID'];
  13.     $sql = "SELECT Name,Email,No_Telepon,Kelamin FROM form_pendaftaran WHERE ID='$id' ";
  14.     $result = $connect->query($sql);
  15.     while ($show = mysqli_fetch_array($result)) {
  16.             $nama = $show['Name'];
  17.             $email = $show['Email'];
  18.             $no_telp = $show['No_Telepon'];
  19.             $gender = $show['Kelamin'];
  20.  
  21.            
  22.         echo "<html>
  23.         <form method='POST' name='form_edit'>  
  24.         <table>
  25.         <tr>
  26.             <td>Nama : </td>
  27.             <td><input type='text' name='nama' value='$nama'></td>
  28.         </tr>
  29.         <tr>
  30.             <td>Email : </td>
  31.             <td><input type='text' name='email' value='$email'></td>
  32.         </tr>
  33.         <tr>
  34.             <td>No_Telepon : </td>
  35.             <td><input type='text' name='no_telp' value='$no_telp'></td>
  36.         </tr>
  37.         <tr>
  38.             <td><input type='radio' name='gender' value='$gender'>MALE</td>
  39.             <td><input type='radio' name='gender' value='$gender'>FEMALE</td>
  40.         </tr>
  41.         <tr>
  42.             <td><input type='submit' name='edit' value='EDIT'></td>
  43.         </tr>
  44.     </table></form></html>";
  45.        
  46.  
  47.     if (isset($_POST['edit'])) {
  48.         $name = ($_POST['nama']);
  49.         $email = ($_POST['email']);
  50.         $notelpon = ($_POST['no_telp']);
  51.         $kelamin = ($_POST['gender']);
  52.  
  53.         $edit = "UPDATE form_pendaftaran SET Name='$name',Email='$email',No_Telepeon='$notelpon',Kelamin='$kelamin' WHERE ID='$id' ";
  54.  
  55.         if ($connect->query($edit)===TRUE) {
  56.             echo "SUCCESS UPDATING";
  57.         }else{
  58.             echo "ERROR UPDATING";
  59.         }
  60.     }
  61.     }
  62.  
  63.  
  64. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement