190 lines
7.0 KiB
PHP
190 lines
7.0 KiB
PHP
<?php
|
|
session_start();
|
|
if (!isset($_SESSION['loggedin']) || $_SESSION['loggedin'] !== true) {
|
|
header('Location: ../auth/login.php');
|
|
exit;
|
|
}
|
|
|
|
include '../config/database.php';
|
|
|
|
// Cek apakah ada parameter ID di URL
|
|
if (!isset($_GET['id'])) {
|
|
header('Location: kelolakegiatan.php');
|
|
exit;
|
|
}
|
|
|
|
$id = intval($_GET['id']);
|
|
$query = "SELECT * FROM kegiatan WHERE kegiatan_id = $id";
|
|
$result = mysqli_query($conn, $query);
|
|
$kegiatan = mysqli_fetch_assoc($result);
|
|
|
|
// Jika data tidak ditemukan, redirect
|
|
if (!$kegiatan) {
|
|
header('Location: kelolakegiatan.php');
|
|
exit;
|
|
}
|
|
|
|
// Set edit mode
|
|
$edit_mode = true;
|
|
|
|
// Proses update kegiatan saat form disubmit
|
|
if ($_SERVER["REQUEST_METHOD"] == "POST") {
|
|
$kegiatan_nama = mysqli_real_escape_string($conn, $_POST['kegiatan_nama']);
|
|
$kegiatan_keterangan = mysqli_real_escape_string($conn, $_POST['kegiatan_keterangan']);
|
|
$kegiatan_tglmulai = $_POST['kegiatan_tglmulai'];
|
|
$kegiatan_tglakhir = $_POST['kegiatan_tglakhir'];
|
|
$target_dir = "../assets/img/kegiatan/";
|
|
$kegiatan_gambar = $kegiatan['kegiatan_gambar']; // Simpan gambar lama jika tidak ada perubahan
|
|
|
|
// Cek apakah ada file gambar yang diunggah
|
|
if (!empty($_FILES["kegiatan_gambar"]["name"])) {
|
|
$gambar_baru = time() . "_" . basename($_FILES["kegiatan_gambar"]["name"]);
|
|
$target_file = $target_dir . $gambar_baru;
|
|
$imageFileType = strtolower(pathinfo($target_file, PATHINFO_EXTENSION));
|
|
|
|
// Validasi file gambar
|
|
$check = getimagesize($_FILES["kegiatan_gambar"]["tmp_name"]);
|
|
if ($check === false) {
|
|
die("File yang diunggah bukan gambar.");
|
|
}
|
|
|
|
if (!in_array($imageFileType, ['jpg', 'jpeg', 'png', 'gif', 'webp'])) {
|
|
die("Hanya file JPG, JPEG, PNG, Webp, & GIF yang diperbolehkan.");
|
|
}
|
|
|
|
// Upload file baru
|
|
if (move_uploaded_file($_FILES["kegiatan_gambar"]["tmp_name"], $target_file)) {
|
|
// Hapus gambar lama jika ada
|
|
if (!empty($kegiatan['kegiatan_gambar']) && file_exists($target_dir . $kegiatan['kegiatan_gambar'])) {
|
|
unlink($target_dir . $kegiatan['kegiatan_gambar']);
|
|
}
|
|
$kegiatan_gambar = $gambar_baru;
|
|
} else {
|
|
die("Gagal mengunggah gambar.");
|
|
}
|
|
}
|
|
|
|
// Query update data kegiatan
|
|
$sql = "UPDATE kegiatan SET
|
|
kegiatan_nama = '$kegiatan_nama',
|
|
kegiatan_keterangan = '$kegiatan_keterangan',
|
|
kegiatan_tglmulai = '$kegiatan_tglmulai',
|
|
kegiatan_tglakhir = '$kegiatan_tglakhir',
|
|
kegiatan_gambar = '$kegiatan_gambar'
|
|
WHERE kegiatan_id = $id";
|
|
|
|
if (mysqli_query($conn, $sql)) {
|
|
header("Location: kelolakegiatan.php?status=success");
|
|
exit();
|
|
} else {
|
|
echo "Error: " . mysqli_error($conn);
|
|
}
|
|
}
|
|
|
|
mysqli_close($conn);
|
|
?>
|
|
|
|
<!DOCTYPE html>
|
|
<html lang="en">
|
|
|
|
<head>
|
|
<meta charset="utf-8">
|
|
<meta content="width=device-width, initial-scale=1.0" name="viewport">
|
|
|
|
<title>Edit Kegiatan - Masjid-E</title>
|
|
|
|
<!-- Favicons -->
|
|
<link href="../assets/img/favicon.png" rel="icon">
|
|
<link href="../assets/img/apple-touch-icon.png" rel="apple-touch-icon">
|
|
|
|
<!-- Google Fonts -->
|
|
<link href="https://fonts.gstatic.com" rel="preconnect">
|
|
<link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i|Nunito:300,300i,400,400i,600,600i,700,700i|Poppins:300,300i,400,400i,500,500i,600,600i,700,700" rel="stylesheet">
|
|
|
|
<!-- Vendor CSS Files -->
|
|
<link href="../assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
|
|
<link href="../assets/vendor/bootstrap-icons/bootstrap-icons.css" rel="stylesheet">
|
|
<link href="../assets/vendor/boxicons/css/boxicons.min.css" rel="stylesheet">
|
|
<link href="../assets/vendor/quill/quill.snow.css" rel="stylesheet">
|
|
<link href="../assets/vendor/quill/quill.bubble.css" rel="stylesheet">
|
|
<link href="../assets/vendor/remixicon/remixicon.css" rel="stylesheet">
|
|
<link href="../assets/vendor/simple-datatables/style.css" rel="stylesheet">
|
|
|
|
<!-- Template Main CSS File -->
|
|
<link href="../assets/css/admin.css" rel="stylesheet">
|
|
</head>
|
|
|
|
<body>
|
|
|
|
<?php
|
|
include '../forms/section/header.php';
|
|
include '../forms/section/sidebar.php';
|
|
?>
|
|
|
|
<main id="main" class="main">
|
|
<div class="pagetitle">
|
|
<h1>Edit Kegiatan</h1>
|
|
<nav>
|
|
<ol class="breadcrumb">
|
|
<li class="breadcrumb-item"><a href="dashboard.php">Home</a></li>
|
|
<li class="breadcrumb-item"><a href="kelolakegiatan.php">Kelola Kegiatan</a></li>
|
|
<li class="breadcrumb-item active">Edit Kegiatan</li>
|
|
</ol>
|
|
</nav>
|
|
</div>
|
|
|
|
<section class="section">
|
|
<div class="row">
|
|
<div class="col-lg-12">
|
|
<div class="card">
|
|
<div class="card-body">
|
|
<h5 class="card-title">Form Edit Kegiatan</h5>
|
|
|
|
<form action="editkegiatan.php?id=<?php echo $id; ?>" method="post" enctype="multipart/form-data">
|
|
<input type="hidden" name="kegiatan_id" value="<?php echo $kegiatan['kegiatan_id']; ?>">
|
|
|
|
<div class="mb-3">
|
|
<label for="kegiatan_nama" class="form-label">Nama Kegiatan</label>
|
|
<input type="text" class="form-control" id="kegiatan_nama" name="kegiatan_nama" value="<?php echo htmlspecialchars($kegiatan['kegiatan_nama']); ?>" required>
|
|
</div>
|
|
|
|
<div class="mb-3">
|
|
<label for="kegiatan_keterangan" class="form-label">Keterangan</label>
|
|
<textarea class="form-control" id="kegiatan_keterangan" name="kegiatan_keterangan" rows="8" required><?php echo htmlspecialchars($kegiatan['kegiatan_keterangan']); ?></textarea>
|
|
</div>
|
|
|
|
<div class="mb-3">
|
|
<label for="kegiatan_tglmulai" class="form-label">Tanggal Mulai</label>
|
|
<input type="date" class="form-control" id="kegiatan_tglmulai" name="kegiatan_tglmulai" value="<?php echo htmlspecialchars($kegiatan['kegiatan_tglmulai']); ?>" required>
|
|
</div>
|
|
|
|
<div class="mb-3">
|
|
<label for="kegiatan_tglakhir" class="form-label">Tanggal Akhir</label>
|
|
<input type="date" class="form-control" id="kegiatan_tglakhir" name="kegiatan_tglakhir" value="<?php echo htmlspecialchars($kegiatan['kegiatan_tglakhir']); ?>">
|
|
</div>
|
|
|
|
<div class="mb-3">
|
|
<label for="kegiatan_gambar">Upload Gambar</label>
|
|
<input type="file" id="kegiatan_gambar" name="kegiatan_gambar">
|
|
<?php if (!empty($kegiatan['kegiatan_gambar'])): ?>
|
|
<p>Gambar Saat Ini:</p>
|
|
<img src="../assets/img/kegiatan/<?php echo htmlspecialchars($kegiatan['kegiatan_gambar']); ?>" width="150">
|
|
<?php endif; ?>
|
|
</div>
|
|
|
|
<button type="submit" class="btn btn-primary">Update Kegiatan</button>
|
|
</form>
|
|
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</section>
|
|
|
|
</main>
|
|
|
|
<?php include('../forms/section/footer.php'); ?>
|
|
|
|
</body>
|
|
</html>
|