46 lines
1.4 KiB
PHP
46 lines
1.4 KiB
PHP
<?php
|
|
header('Content-Type: application/json');
|
|
ini_set('display_errors', '0');
|
|
include __DIR__ . '/../../db_config.php';
|
|
|
|
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
|
|
$nama = trim($_POST['nama'] ?? '');
|
|
$kategori = 'Jalan';
|
|
$status = trim($_POST['status'] ?? 'Jalan Kabupaten');
|
|
$type = trim($_POST['type'] ?? 'polyline');
|
|
$geometry = $_POST['geometry'] ?? '';
|
|
$nilai = (float)($_POST['nilai'] ?? 0);
|
|
|
|
if ($nama === '' || $geometry === '') {
|
|
http_response_code(400);
|
|
echo json_encode(['status' => 'error', 'message' => 'Data jalan tidak lengkap']);
|
|
$conn->close();
|
|
exit;
|
|
}
|
|
|
|
$stmt = $conn->prepare("INSERT INTO spatial_features (nama_objek, kategori, status_objek, type, geometry_data, nilai_ukur) VALUES (?, ?, ?, ?, ?, ?)");
|
|
if (!$stmt) {
|
|
http_response_code(500);
|
|
echo json_encode(['status' => 'error', 'message' => $conn->error]);
|
|
$conn->close();
|
|
exit;
|
|
}
|
|
|
|
$stmt->bind_param("sssssd", $nama, $kategori, $status, $type, $geometry, $nilai);
|
|
|
|
if ($stmt->execute()) {
|
|
echo json_encode(['status' => 'success', 'message' => 'Data jalan berhasil disimpan']);
|
|
} else {
|
|
http_response_code(500);
|
|
echo json_encode(['status' => 'error', 'message' => $stmt->error]);
|
|
}
|
|
$stmt->close();
|
|
$conn->close();
|
|
exit;
|
|
}
|
|
|
|
http_response_code(405);
|
|
echo json_encode(['status' => 'error', 'message' => 'Method tidak diizinkan']);
|
|
$conn->close();
|
|
?>
|