powji17
44 lines
1.3 KiB
PHP
44 lines
1.3 KiB
PHP
<?php
|
|
// simpan_spbu.php
|
|
|
|
header('Content-Type: application/json');
|
|
|
|
// Konfigurasi Database (Sesuaikan dengan milik Anda)
|
|
require_once '../config.php';
|
|
$conn = getDB();
|
|
|
|
// Ambil data JSON yang dikirim oleh Fetch API
|
|
$data = json_decode(file_get_contents("php://input"), true);
|
|
|
|
if ($data) {
|
|
$lat = $data['lat'];
|
|
$lng = $data['lng'];
|
|
$nama_spbu = $data['nama_spbu'];
|
|
$no_wa = $data['no_wa'];
|
|
$buka_24jam = $data['buka_24jam'];
|
|
|
|
// Gunakan Prepared Statement untuk keamanan (mencegah SQL Injection)
|
|
$stmt = $conn->prepare("INSERT INTO spbu_point (lat, lng, nama_spbu, no_wa, buka_24jam) VALUES (?, ?, ?, ?, ?)");
|
|
$stmt->bind_param("ddssi", $lat, $lng, $nama_spbu, $no_wa, $buka_24jam);
|
|
|
|
if ($stmt->execute()) {
|
|
// AMBIL ID TERAKHIR YANG BARU SAJA DISIMPAN
|
|
$new_id = $stmt->insert_id;
|
|
|
|
// Kirim kembali ID tersebut ke JavaScript
|
|
echo json_encode([
|
|
"status" => "success",
|
|
"message" => "Data berhasil disimpan",
|
|
"id" => $new_id
|
|
]);
|
|
} else {
|
|
echo json_encode(["status" => "error", "message" => "Gagal mengeksekusi query: " . $stmt->error]);
|
|
}
|
|
|
|
$stmt->close();
|
|
} else {
|
|
echo json_encode(["status" => "error", "message" => "Tidak ada data yang diterima"]);
|
|
}
|
|
|
|
$conn->close();
|
|
?>
|