real_escape_string($data['nama']); $no = $conn->real_escape_string($data['no']); $status = $conn->real_escape_string($data['status']); $alamat = isset($data['alamat']) ? $conn->real_escape_string($data['alamat']) : ''; $lat = $data['lat']; $lng = $data['lng']; $sql = "INSERT INTO spbu (nama,no,status,alamat,lat,lng) VALUES ('$nama','$no','$status','$alamat','$lat','$lng')"; if($conn->query($sql)){ echo json_encode([ "status"=>"success", "id"=>$conn->insert_id ]); }else{ echo json_encode(["status"=>"error", "msg"=>$conn->error]); } ?>