prepare("INSERT INTO spbu (nama, no, status, latitude, longitude) VALUES (:nama,:no,:status,:lat,:lng)");
$stmt->execute([':nama'=>trim($_POST['nama']),':no'=>trim($_POST['no']),':status'=>isset($_POST['status'])?1:0,':lat'=>floatval($_POST['latitude']),':lng'=>floatval($_POST['longitude'])]);
$message = ['type'=>'success','text'=>'Data SPBU berhasil ditambahkan!'];
}
if ($_POST['action'] === 'update') {
$stmt = $pdo->prepare("UPDATE spbu SET nama=:nama,no=:no,status=:status,latitude=:lat,longitude=:lng WHERE id=:id");
$stmt->execute([':nama'=>trim($_POST['nama']),':no'=>trim($_POST['no']),':status'=>isset($_POST['status'])?1:0,':lat'=>floatval($_POST['latitude']),':lng'=>floatval($_POST['longitude']),':id'=>intval($_POST['id'])]);
$message = ['type'=>'success','text'=>'Data berhasil diperbarui!'];
}
if ($_POST['action'] === 'delete') {
$pdo->prepare("DELETE FROM spbu WHERE id=:id")->execute([':id'=>intval($_POST['id'])]);
$message = ['type'=>'danger','text'=>'Data berhasil dihapus.'];
}
}
if (isset($_GET['edit'])) {
$stmt = $pdo->prepare("SELECT * FROM spbu WHERE id=:id");
$stmt->execute([':id'=>intval($_GET['edit'])]);
$edit_data = $stmt->fetch(PDO::FETCH_ASSOC);
}
$all = $pdo->query("SELECT * FROM spbu ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
?>
Input SPBU — WebGIS Pontianak
📍
Klik Peta — Tentukan Lokasi
Klik titik mana saja untuk mengisi koordinat otomatis
📋
Daftar SPBU data
Belum ada data. Tambahkan SPBU lewat form di atas.