23 lines
696 B
PHP
23 lines
696 B
PHP
<?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);
|
|
}
|
|
?>
|