Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.00 KB | None | 0 0
  1. <?php
  2.   // buka koneksi dengan MySQL
  3.   include("connection.php");
  4.  
  5.   // cek apakah form telah di submit (untuk menghapus data)
  6.   if (isset($_POST["submit"])) {
  7.     // form telah disubmit, proses data
  8.    
  9.     // ambil nilai kode_brg
  10.     $kode_brg = htmlentities(strip_tags(trim($_POST["kode_brg"])));
  11.     // filter data
  12.     $kode_brg = mysqli_real_escape_string($link,$kode_brg);
  13.    
  14.     //jalankan query DELETE
  15.     $query = "DELETE FROM barang WHERE kode_brg='$kode_brg' ";
  16.     $hasil_query = mysqli_query($link, $query);
  17.  
  18.     //periksa query, tampilkan pesan kesalahan jika gagal
  19.     if($hasil_query) {
  20.       // DELETE berhasil, redirect ke tampil_mahasiswa.php + pesan
  21.       $pesan = "Mahasiswa dengan kode_brg = \"<b>$kode_brg</b>\" sudah berhasil di hapus";
  22.       $pesan = urlencode($pesan);
  23.         header("Location: tampil_barang.php?pesan={$pesan}");
  24.     }
  25.     else {
  26.       die ("Query gagal dijalankan: ".mysqli_errno($link).
  27.            " - ".mysqli_error($link));
  28.     }
  29.   }
  30. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement