33 lines
545 B
PHP
33 lines
545 B
PHP
<?php
|
|
|
|
include 'koneksi.php';
|
|
|
|
if (!$conn) {
|
|
die("Koneksi database gagal");
|
|
}
|
|
|
|
// Pindahkan semua operator ke masjid ID 13
|
|
mysqli_query($conn, "
|
|
UPDATE users
|
|
SET id_rumah_ibadah = 13
|
|
WHERE role IN ('operator', 'admin_ibadah')
|
|
");
|
|
|
|
// Hapus semua masjid kecuali ID 13
|
|
$sql = "
|
|
DELETE FROM tabel_ibadah
|
|
WHERE id <> 13
|
|
";
|
|
|
|
if (mysqli_query($conn, $sql)) {
|
|
|
|
echo "<h2>Berhasil</h2>";
|
|
echo "Semua data rumah ibadah selain ID 13 telah dihapus.";
|
|
|
|
} else {
|
|
|
|
echo "<h2>Gagal</h2>";
|
|
echo mysqli_error($conn);
|
|
|
|
}
|
|
?>
|