query($query);
$profil_masjid = $result->fetch_assoc();
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
// Data profil
$profil_nama = $_POST['profil_nama'] ?? '';
$profil_alamat = $_POST['profil_alamat'] ?? '';
$profil_alamatlengkap = $_POST['profil_alamatlengkap'] ?? '';
$profil_maps = $_POST['profil_maps'] ?? '';
$profil_desmasjid = $_POST['profil_desmasjid'] ?? '';
$profil_rekening = $_POST['profil_rekening'] ?? '';
$profil_dompet = $_POST['profil_dompet'] ?? '';
$profil_nohp = $_POST['profil_nohp'] ?? '';
$profil_facebook = $_POST['profil_facebook'] ?? '';
$profil_instagram = $_POST['profil_instagram'] ?? '';
// Menyaring inputan untuk mengambil URL embed Google Maps
$profil_maps = extractMapUrl($profil_maps);
$errors = [];
if (empty($profil_nama) || empty($profil_alamat) || empty($profil_alamatlengkap) ||
empty($profil_maps) || empty($profil_desmasjid) || empty($profil_rekening) ||
empty($profil_dompet) || empty($profil_nohp)) {
$errors[] = "Semua kolom wajib diisi!";
}
if (!empty($errors)) {
echo ''. implode("
", $errors) .'
';
} else {
// Proses upload & simpan data
}
// Direktori upload
$dir_cover = "../assets/img/gambarcover/";
$dir_struktur = "../assets/img/gambarstruktur/";
$dir_donasi = "../assets/img/gambardonasi/";
if (!is_dir($dir_cover)) mkdir($dir_cover, 0777, true);
if (!is_dir($dir_struktur)) mkdir($dir_struktur, 0777, true);
if (!is_dir($dir_donasi)) mkdir($dir_donasi, 0777, true);
function uploadFile($file, $oldFile, $directory) {
if (!empty($file['name']) && $file['error'] == 0) {
$ext = strtolower(pathinfo($file['name'], PATHINFO_EXTENSION));
$allowed_exts = ['jpg', 'jpeg', 'png', 'webp', 'gif'];
if (!in_array($ext, $allowed_exts)) {
die("Error: Format file tidak diperbolehkan!");
}
$newFileName = uniqid('img_', true) . '.' . $ext;
$filePath = $directory . $newFileName;
if (move_uploaded_file($file['tmp_name'], $filePath)) {
// Hapus gambar lama jika ada
if (!empty($oldFile) && file_exists($directory . $oldFile)) {
unlink($directory . $oldFile);
}
return $newFileName;
} else {
die("Error: Gagal memindahkan file!");
}
}
return $oldFile;
}
// Upload gambar cover, struktur, donasi
$profil_gambarcover = uploadFile($_FILES['profil_gambarcover'], $profil_masjid['profil_gambarcover'] ?? '', $dir_cover);
$profil_gambarstruktur = uploadFile($_FILES['profil_gambarstruktur'], $profil_masjid['profil_gambarstruktur'] ?? '', $dir_struktur);
$profil_gambardonasi = uploadFile($_FILES['profil_gambardonasi'], $profil_masjid['profil_gambardonasi'] ?? '', $dir_donasi);
// **PERBAIKAN QUERY SQL**
$query = "UPDATE profil SET
profil_nama = ?,
profil_alamat = ?,
profil_alamatlengkap = ?,
profil_maps = ?,
profil_desmasjid = ?,
profil_rekening = ?,
profil_dompet = ?,
profil_nohp = ?,
profil_facebook = ?,
profil_instagram = ?,
profil_gambarcover = ?,
profil_gambarstruktur = ?,
profil_gambardonasi = ?
LIMIT 1"; // ✅ Koma dihilangkan setelah kolom terakhir
$stmt = $conn->prepare($query);
// **PERBAIKAN BIND PARAM**
$stmt->bind_param("sssssssssssss",
$profil_nama, $profil_alamat, $profil_alamatlengkap, $profil_maps,
$profil_desmasjid, $profil_rekening,
$profil_dompet, $profil_nohp, $profil_facebook, $profil_instagram,
$profil_gambarcover, $profil_gambarstruktur, $profil_gambardonasi
);
if ($stmt->execute()) {
$_SESSION['success'] = "Data berhasil diperbarui!";
header('Location: kelolaprofilmasjid.php');
exit;
} else {
echo "Error saat menyimpan data: " . $stmt->error;
}
}
function extractMapUrl($input) {
// Cek jika input adalah