Files
WEB-GIS/fitur_spbu/api/update_coords.php

37 lines
1.0 KiB
PHP

<?php
header('Content-Type: application/json');
include __DIR__ . '/../../db_config.php';
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$id = (int)($_POST['id'] ?? 0);
$lat = $_POST['lat'] ?? '';
$lng = $_POST['lng'] ?? '';
if ($id <= 0 || empty($lat) || empty($lng)) {
http_response_code(400);
echo json_encode(['status' => 'error', 'message' => 'Data tidak lengkap']);
exit;
}
$stmt = $conn->prepare("UPDATE locations SET latitude = ?, longitude = ? WHERE id = ?");
if (!$stmt) {
http_response_code(500);
echo json_encode(['status' => 'error', 'message' => $conn->error]);
$conn->close();
exit;
}
$stmt->bind_param("ddi", $lat, $lng, $id);
if ($stmt->execute()) {
echo json_encode(['status' => 'success', 'message' => 'Koordinat SPBU berhasil diperbarui']);
} else {
http_response_code(500);
echo json_encode(['status' => 'error', 'message' => $stmt->error]);
}
$stmt->close();
}
$conn->close();
?>