<?php
include 'db_config.php';

// Fungsi Ambil Data
function getAllSPBU($conn) {
    $sql = "SELECT * FROM spbu ORDER BY id DESC";
    return $conn->query($sql);
}

// Fungsi Simpan Data
function insertSPBU($conn, $nama, $no_spbu, $status, $lat, $lng) {
    $nama_clean   = $conn->real_escape_string($nama);
    $no_spbu_clean = $conn->real_escape_string($no_spbu);
    $status_clean = $conn->real_escape_string($status);
    $lat_clean    = (float)$lat;
    $lng_clean    = (float)$lng;

    $sql = "INSERT INTO spbu (nama, no_spbu, status_24jam, lat, lng) 
            VALUES ('$nama_clean', '$no_spbu_clean', '$status_clean', $lat_clean, $lng_clean)";
    
    return $conn->query($sql);
}
?>