<?php
ini_set('display_errors',1);
error_reporting(E_ALL);

include 'koneksi.php';

if(!isset($_POST['tipe'])){
    die("Error: tipe tidak ada");
}

$tipe = $_POST['tipe'];

// ================= JALAN =================
if($tipe=="jalan"){

    $nama = $_POST['nama_jalan'];
    $status = $_POST['status'];
    $panjang = $_POST['panjang'];
    $geom = $_POST['geom'];

    $sql = "INSERT INTO jalan (nama_jalan,status,panjang,geom)
            VALUES (?,?,?,?)";

    $stmt = $conn->prepare($sql);
    $stmt->bind_param("ssds",$nama,$status,$panjang,$geom);

    if($stmt->execute()){
        echo "success";
    }else{
        echo "Error: ".$stmt->error;
    }
}

// ================= TANAH =================
if($tipe=="tanah"){

    $nama = $_POST['nama_pemilik'];
    $status = $_POST['status'];
    $luas = $_POST['luas'];
    $geom = $_POST['geom'];

    $sql = "INSERT INTO tanah (nama_pemilik,status,luas,geom)
            VALUES (?,?,?,?)";

    $stmt = $conn->prepare($sql);
    $stmt->bind_param("ssds",$nama,$status,$luas,$geom);

    if($stmt->execute()){
        echo "success";
    }else{
        echo "Error: ".$stmt->error;
    }
}
// ================= POINT RUSAK =================
if($tipe=="rusak"){

    $nama = $_POST['nama'];
    $ket = $_POST['keterangan'];
    $lat = $_POST['lat'];
    $lng = $_POST['lng'];

    $sql = "INSERT INTO rusak (nama,keterangan,lat,lng)
            VALUES (?,?,?,?)";

    $stmt = $conn->prepare($sql);
    $stmt->bind_param("ssdd",$nama,$ket,$lat,$lng);

    if($stmt->execute()){
        echo "success";
    }else{
        echo "Error: ".$stmt->error;
    }
}
?>