| Server IP : 153.92.12.133 / Your IP : 216.73.217.80 Web Server : LiteSpeed System : Linux id-dci-web1986.main-hosting.eu 5.14.0-611.26.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Jan 29 05:24:47 EST 2026 x86_64 User : u686484674 ( 686484674) PHP Version : 8.0.30 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u686484674/domains/idikotabandung.com/public_html/berita/webadmin/ |
Upload File : |
<?php
include 'header.php';
$kode = $_GET['id'];
$kat_sql = "SELECT kategori FROM kategori WHERE id_kategori='".$mysqli->real_escape_string($kode)."'";
$kat_qry = $mysqli->query($kat_sql);
$kat = $kat_qry->fetch_assoc();
if (isset($_POST['hapus_btn'])) {
$pilihan = $_POST['opt_hapus'];
switch ($pilihan) {
case 'hapus':
//Hapus Kategori berita
$del_kat_sql = "DELETE FROM kategori WHERE id_kategori = '$kode'";
//Hapus berita berdasarkan id_kategori
$del_berita_sql = "DELETE FROM berita WHERE id_kategori = '$kode'";
//Hapus gambar dalam berita berdasarkan id_kategori
$gambar_sql = "SELECT gambar FROM berita WHERE id_kategori = '$kode'";
$gambar_qry = $mysqli->query($gambar_sql) or die ($mysqli->error);
while ($data_gbr = $gambar_qry->fetch_assoc()) {
unlink('../images/'.$data_gbr['gambar']);
}
//Menjalankan query hapus untuk berita & kategori
$del_kat_qry = $mysqli->query($del_kat_sql) or die ($mysqli->error);
$del_berita_qry = $mysqli->query($del_berita_sql) or die ($mysqli->error);
echo "<script>alert('Data Berhasil Dihapus'); window.location = 'kategori.php'</script>";
break;
case 'pindah':
//Hapus Kategori Berita
$del_kat_qry = "DELETE FROM kategori WHERE id_kategori = '$kode'";
$del_kat = $mysqli->query($del_kat_qry) or die ($mysqli->error);
//Pindahkan Berita ke Kategori "Uncategorized"
$mv_berita_qry = "UPDATE berita SET id_kategori = '4' WHERE id_kategori = '$kode'";
$mv_berita = $mysqli->query($mv_berita_qry) or die ($mysqli->error);
echo "<script>alert('Data Berhasil Dihapus'); window.location = 'kategori.php'</script>";
break;
default:
header('location: kategori.php');
break;
}
}
?>
<div class="container-fluid body">
<div class="row">
<div class="col-lg-2 sidebar">
<?php include 'sidebar.php'; ?>
</div>
<div class="col-lg-10 main-content">
<div class="panel panel-default">
<div class="panel-body">
<div class="row">
<div class="col-md-12">
<h2 class="page-header"><i class="fa fa-folder-o"></i> Hapus Kategori: <strong><?php echo $kat['kategori']; ?></strong></h2>
</div>
</div>
<div class="row">
<div class="col-md-12">
<form action="" method="POST">
<div class="form-group">
<input type="radio" name="opt_hapus" value="pindah" checked="true"> Pindahkan semua posting dalam kategori ini ke "Uncategorized"
</div>
<div class="form-group">
<input type="radio" name="opt_hapus" value="hapus"> Hapus semua posting dalam kategori ini
</div>
<div class="form-group">
<a class="btn btn-danger btn-sm" href="kategori.php"><i class="fa fa-times"></i> Batal</a>
<button class="btn btn-primary btn-sm" name="hapus_btn" type="submit">
<i class="fa fa-check"></i> Pilih
</button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include 'footer.php'; ?>