Advertisement
cecepsuwanda

hapus

Oct 4th, 2017
155
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.92 KB | None | 0 0
  1.   if (isset($_POST['hapus'])) {
  2.     $no_surat=$_POST['no_surat'];
  3.     $sql="select * from surat_masuk where no_surat='$no_surat'";
  4.     $hasil=mysqli_query($konek,$sql);
  5.     $data = mysqli_fetch_array($hasil);
  6.    
  7.     // Cek apakah file fotonya ada di folder images
  8.     if(is_file("../images/".$data['foto'])); // Jika foto ada  
  9.     unlink("../images/".$data['foto']); // Hapus foto yang telah diupload dari folder images
  10.    
  11.     // Query untuk menghapus data surat_masuk berdasarkan No surat yang dikirim
  12.     $query2 = "DELETE FROM surat_masuk WHERE no_surat='$no_surat'";
  13.     $sql2 = mysqli_query($konek, $query2); // Eksekusi/Jalankan query dari variabel $query
  14.     if ($sql2) {
  15.             echo '<script>
  16.                 alert("data Berhasil di hapus");
  17.              </script>';
  18.         }else{
  19.            echo '<script>
  20.                 alert("data gagal di hapus");
  21.              </script>';
  22.         }
  23.    
  24.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement