24 lines
1.0 KiB
PHP
24 lines
1.0 KiB
PHP
<?php
|
|
include 'koneksi.php';
|
|
|
|
$data = json_decode(file_get_contents("php://input"), true);
|
|
|
|
$id = rand(1000,9999);
|
|
$nama = isset($data['nama']) ? $conn->real_escape_string($data['nama']) : '';
|
|
$no_telp = isset($data['no_telp']) ? $conn->real_escape_string($data['no_telp']) : '';
|
|
$buka = isset($data['buka_24_jam']) ? intval($data['buka_24_jam']) : 0;
|
|
$alamat = isset($data['alamat']) ? $conn->real_escape_string($data['alamat']) : '';
|
|
$jenis = isset($data['jenis']) ? $conn->real_escape_string($data['jenis']) : '';
|
|
$lat = isset($data['latitude']) ? $data['latitude'] : '';
|
|
$lng = isset($data['longitude']) ? $data['longitude'] : '';
|
|
|
|
// Insert specifying columns (ensure your `lokasi` table has `jenis` and `alamat` columns)
|
|
$sql = "INSERT INTO lokasi (id, nama, jenis, no_telp, buka_24_jam, alamat, latitude, longitude) VALUES ('$id', '$nama', '$jenis', '$no_telp', '$buka', '$alamat', '$lat', '$lng')";
|
|
$res = $conn->query($sql);
|
|
|
|
if($res){
|
|
echo json_encode(["success"=>true, "id"=>$id]);
|
|
} else {
|
|
echo json_encode(["success"=>false, "error"=> $conn->error]);
|
|
}
|
|
?>
|