unknown
44 lines
1.4 KiB
PHP
44 lines
1.4 KiB
PHP
<?php
|
|
// ========================================
|
|
// FILE: php/hapus_data.php
|
|
// Menghapus data masyarakat miskin atau rumah ibadah
|
|
// ========================================
|
|
|
|
include 'koneksi.php';
|
|
|
|
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
|
|
|
|
$tipe = sanitize($_POST['tipe'] ?? '', $conn); // 'masyarakat' atau 'rumah_ibadah'
|
|
$id = intval($_POST['id'] ?? 0);
|
|
|
|
if ($id == 0 || empty($tipe)) {
|
|
sendJSON('error', 'Data tidak lengkap');
|
|
}
|
|
|
|
if ($tipe === 'masyarakat') {
|
|
$query = "DELETE FROM masyarakat_miskin WHERE id = $id";
|
|
} elseif ($tipe === 'ibadah' || $tipe === 'rumah_ibadah') { // To be safe
|
|
$query = "DELETE FROM rumah_ibadah WHERE id = $id";
|
|
} elseif ($tipe === 'jalan') {
|
|
$query = "DELETE FROM fasilitas_jalan WHERE id = $id";
|
|
} elseif ($tipe === 'polygon') {
|
|
$query = "DELETE FROM fasilitas_polygon WHERE id = $id";
|
|
} elseif ($tipe === 'spbu') {
|
|
$query = "DELETE FROM fasilitas_spbu WHERE id = $id";
|
|
} else {
|
|
sendJSON('error', 'Tipe tidak valid');
|
|
}
|
|
|
|
if ($conn->query($query) === TRUE) {
|
|
if ($conn->affected_rows > 0) {
|
|
sendJSON('success', 'Data berhasil dihapus');
|
|
} else {
|
|
sendJSON('error', 'Data tidak ditemukan');
|
|
}
|
|
} else {
|
|
sendJSON('error', 'Gagal menghapus: ' . $conn->error);
|
|
}
|
|
}
|
|
|
|
?>
|