50 lines
1.5 KiB
PHP
50 lines
1.5 KiB
PHP
<?php
|
|
session_start();
|
|
// Cek apakah pengguna sudah login
|
|
if (!isset($_SESSION['loggedin']) || $_SESSION['loggedin'] !== true) {
|
|
header('Location: ../auth/login.php');
|
|
exit;
|
|
}
|
|
|
|
// Include file koneksi ke database
|
|
include '../config/database.php';
|
|
|
|
// Cek jika ada ID kegiatan untuk dihapus
|
|
if (isset($_GET['id'])) {
|
|
$id = intval($_GET['id']);
|
|
|
|
// Query untuk mendapatkan nama gambar dari database
|
|
$query = "SELECT kegiatan_gambar FROM kegiatan WHERE kegiatan_id = $id";
|
|
$result = mysqli_query($conn, $query);
|
|
|
|
if ($result && mysqli_num_rows($result) > 0) {
|
|
$row = mysqli_fetch_assoc($result);
|
|
$gambar = $row['kegiatan_gambar'];
|
|
|
|
// Hapus data dari database
|
|
$delete_query = "DELETE FROM kegiatan WHERE kegiatan_id = $id";
|
|
if (mysqli_query($conn, $delete_query)) {
|
|
// Hapus gambar dari folder jika ada
|
|
if ($gambar) {
|
|
$gambar_path = "../assets/img/kegiatan/" . $gambar;
|
|
if (file_exists($gambar_path)) {
|
|
unlink($gambar_path);
|
|
}
|
|
}
|
|
header('Location: kelolakegiatan.php?status=success');
|
|
} else {
|
|
echo "Error deleting record: " . mysqli_error($conn);
|
|
}
|
|
} else {
|
|
// Redirect jika kegiatan tidak ditemukan
|
|
header('Location: kelolakegiatan.php');
|
|
}
|
|
|
|
// Tutup koneksi
|
|
mysqli_close($conn);
|
|
} else {
|
|
// Redirect jika tidak ada ID
|
|
header('Location: kelolakegiatan.php');
|
|
}
|
|
?>
|